A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
JBDC error while reading records from DB2
Joined: Sep 23, 2008
Nov 28, 2008 05:03:00
I am trying to read records from DB2 database using
. 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.
It is sorta covered in the
JavaRanch Style Guide
subject: JBDC error while reading records from DB2
How to use DB2 decrypt_char() with Hibernate
JNDI Resource Bindings
Performance problem in jdbc
Db2 invalid column name error
effects of using static methods
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015