[DERBY-6388] Example WHERE CURRENT OF clause in Reference Guide is nonsense

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.11.1.1
• Fix Version/s: 10.10.2.0, 10.11.1.1
• Component/s: Documentation
• Urgency: Normal
• Assignee: Camilla Haase
• Reporter: Richard N. Hillegas
• Created: 22/Oct/13 13:17
• Updated: 03/Sep/14 11:52
• Resolved: 13/Jan/14 20:43

Description

The Reference Guide section titled "WHERE CURRENT OF clause" provides some sample code. The code doesn't even compile. It has a number of defects:

1) Autocommit needs to be turned on.

2) The cursor name needs to be ALL CAPS in the s.setCursorName() statement.

3) The ResultSet needs to be created from the statement and can't be created directly from the connection.

4) The ResultSet needs to be positioned before the UPDATE is run.

The following cleaned-up code compiles and runs correctly:

conn.setAutoCommit( false );

Statement s = conn.createStatement();
s.setCursorName("AIRLINESRESULTS");
ResultSet rs = s.executeQuery(
"SELECT Airline, basic_rate " +
"FROM Airlines FOR UPDATE OF basic_rate");
rs.next();
Statement s2 = conn.createStatement();
s2.executeUpdate("UPDATE Airlines SET basic_rate = basic_rate " +
"+ .25 WHERE CURRENT OF AirlinesResults");