db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DERBY-6388) Example WHERE CURRENT OF clause in Reference Guide is nonsense
Date Tue, 22 Oct 2013 13:18:43 GMT
Rick Hillegas created DERBY-6388:
------------------------------------

             Summary: Example WHERE CURRENT OF clause in Reference Guide is nonsense
                 Key: DERBY-6388
                 URL: https://issues.apache.org/jira/browse/DERBY-6388
             Project: Derby
          Issue Type: Bug
          Components: Documentation
    Affects Versions: 10.11.0.0
            Reporter: Rick Hillegas


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");




--
This message was sent by Atlassian JIRA
(v6.1#6144)

Mime
View raw message