Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

JBDC error while reading records from DB2  RSS feed

 
Phaneendra Gugggilam
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!