JBDC error while reading records from DB2
Phaneendra Gugggilam
Greenhorn
Posts: 14
posted 8 years ago
I am trying to read records from DB2 database using JDBC. I have given the error message occured below.
com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -913, SQLSTATE: 57033
Also I am getting timeout issue. Error detail as below
"Transaction 0000011DD5115FD9000000010000000B255CF9651235030D8334515131177DFC21F418050000011DD5115FD9000000010000000B255CF9651235030D8334515131177DFC21F4180500000001 has timed out after 120 seconds."
I am using Webspere 6.0. For datasource I have given the isolation level as Repeatable_Read. I tried with Read_Uncommited also. Also by appending "FOR READ ONLY WITH UR" with the query.
com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -913, SQLSTATE: 57033
Also I am getting timeout issue. Error detail as below
"Transaction 0000011DD5115FD9000000010000000B255CF9651235030D8334515131177DFC21F418050000011DD5115FD9000000010000000B255CF9651235030D8334515131177DFC21F4180500000001 has timed out after 120 seconds."
I am using Webspere 6.0. For datasource I have given the isolation level as Repeatable_Read. I tried with Read_Uncommited also. Also by appending "FOR READ ONLY WITH UR" with the query.
|