Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JBDC error while reading records from DB2

 
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