aspose file tools*
The moose likes JDBC and the fly likes JBDC error while reading records from DB2 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JBDC error while reading records from DB2" Watch "JBDC error while reading records from DB2" New topic
Author

JBDC error while reading records from DB2

Phaneendra Gugggilam
Greenhorn

Joined: Sep 23, 2008
Posts: 14
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.
 
Consider Paul's rocket mass heater.
 
subject: JBDC error while reading records from DB2