Meaningless Drivel is fun!*
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 Murach's Java Servlets and JSP this week in the Servlets 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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JBDC error while reading records from DB2
 
Similar Threads
JNDI Resource Bindings
effects of using static methods
Performance problem in jdbc
Db2 invalid column name error
How to use DB2 decrypt_char() with Hibernate