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

you are using 2 phase commit and hold on cursor
as the message indicates

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

yes .. 2 phase commit and hold on cursor .

Is there something to change.

Please its bit urgent... Plz help

Don't use holdable cursors over XA connections.

if i remove holdable cursors over XA connection .. i am getting following exception.

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

if i remove holdable cursors over XA connection .. i am getting following exception.

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

Then you should not commit the transaction while still working with the cursor.