Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004
    Posts
    374

    Unanswered: cursor with hold

    Anyone having a simple jdbc -java program using a select and setting the cursor to hold
    (keeping the cursor open with commit) for a db2 connection ?
    any sample can be shipped/published...
    Thanks for all info/help
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified
    http://users.skynet.be/przytula/dbss.html

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    java.sql.Connection.setHoldability

    void setHoldability(int holdability)
    throws SQLException

    Changes the holdability of ResultSet objects created using this Connection object to the given holdability.

    Parameters:
    holdability - a ResultSet holdability constant; one of ResultSet.HOLD_CURSORS_OVER_COMMIT or ResultSet.CLOSE_CURSORS_AT_COMMIT
    Throws:
    SQLException - if a database access occurs, the given parameter is not a ResultSet constant indicating holdability, or the given holdability is not supported
    Since:
    1.4
    See Also:
    getHoldability(), ResultSet
    http://java.sun.com/j2se/1.5.0/docs/...onnection.html

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •