Holdability question ....

From: Raquel (raquel_at_nospam.com)
Date: 07/08/04

  • Next message: kaeli: "Re: CLOSE_CURSORS_AT_COMMIT" 
    Date: Thu, 08 Jul 2004 08:55:02 -0400

    I am slightly confused. We can specify "Holdability" while creating a
    statement.

    Statement stmt = conn.createStatement(int resultSetType, int
    resultSetConcurrency, int resultSetHoldability);

    So far so good; it makes sense to have Holdability at Statement level
    since various statement object associated with the same Connection may
    have different Holdability attribute.

    Now, Connection inteface also has a method setHoldability with the
    following description:

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

    So, what does this mean? If I have two Statements stmt1 and stmt2 which
    were created with different Holdability attributes, will setHoldability of
    Connection interface override those Holdabilities and set it whatever we
    specify in setHoldability method?

    TIA
    Raquel.

  • Next message: kaeli: "Re: CLOSE_CURSORS_AT_COMMIT"