Results 1 to 8 of 8
  1. #1
    Join Date
    Oct 2009
    Posts
    16

    Unanswered: Invalid operation: ResultSet holdability HOLD_CURSORS_OVER_COMMIT is not allowed on a

    Hi

    Iam getting following exception.

    What could be the.. is there any work around.

    Its bit urgent .. any info on this would be thankful

    com.ibm.db2.jcc.b.SqlException
    [jcc][t4][10434][12579][3.53.95] Invalid operation: ResultSet holdability HOLD_CURSORS_OVER_COMMIT is not allowed on an XA connection. ERRORCODE=-4476, SQLSTATE=null

    Thanks a lot

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    you are using 2 phase commit and hold on cursor
    as the message indicates
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Oct 2009
    Posts
    16
    Actually when i made a setResultsetHoldability value to 1 in WAS Admin i got the above problem..

    if i made setResultsetHoldability value to 2 ... i am getting this error

    ( Invalid operation: result set is closed. ERRORCODE=-4470, SQLSTATE=null )

    And While creating the Data Source in WAS 7.0 . I used XA Data Source( Two phase commit ).

    is there any work around for this. what could be the problem

  4. #4
    Join Date
    Oct 2009
    Posts
    16
    yes .. 2 phase commit and hold on cursor .

    Is there something to change.

    Please its bit urgent... Plz help

  5. #5
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Don't use holdable cursors over XA connections.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  6. #6
    Join Date
    Oct 2009
    Posts
    16
    if i remove holdable cursors over XA connection .. i am getting following exception.

    ( Invalid operation: result set is closed. ERRORCODE=-4470, SQLSTATE=null )

  7. #7
    Join Date
    Oct 2009
    Posts
    16
    if i remove holdable cursors over XA connection .. i am getting following exception.

    ( Invalid operation: result set is closed. ERRORCODE=-4470, SQLSTATE=null )

  8. #8
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Then you should not commit the transaction while still working with the cursor.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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