ResultSet.getCursorName

JDBC drivers generate a cursor name for any SQL query so that a string can always be returned. However, jConnect does not return a name when ResultSet.getCursorName is called.

Provided you either:
  • Called setFetchSize or setCursorName on the corresponding statement, or

  • Set the SELECT_OPENS_CURSOR connection property to true, and your query was in the form of SELECT... FOR UPDATE. For example:
    select au_id from authors for update

If you do not call setFetchSize or setCursorName on the corresponding statement, or set the SELECT_OPENS_CURSOR connection property to true, null is returned.

According to the JDBC 2.0 API documentation, all other SQL statements do not need to open a cursor and return a name.

For more information on how to use cursors in jConnect, see Cursors with Result Sets.

Related reference
Use Cursors with Result Sets