Hi there,

I've been searching the net for possible solutions or even the cause of the following problem:

com.ibm.db2.jcc.b.SQLException:
at com.ibm.db2.jcc.b.ca.next(ca.java:255)
at org.apache.commons.dbcp.DelegatingResultSet.next(D elegatingResultSet.java:196)


Unfortunately the SQL Message is not being displayed.

The only thing that I could find is that REORG needs to be run on the respective table. Does anyone else have another suggestion?

can you speify, when and where these messages are produced -
starting the connection / connection pool - starting the application
specific statement for application
in an application, always print out the sqlca if error occured.
check log if application server is involved...
specify a bit of detail, so we don't have to guess what is going on..

Hi there, and thanks for the reply.

The error occurs on a specific statement.

Unfortunately, this error is happening in a production system, and the sqlca is not being printed.
I've deployed a change to the system last night to get the error code.

I've run a REORG on the table that I thought was causing the problem, but it doesn't seem to have helped.

Furthermore, the error is intermittent.

Will try to get more detail...

Thanks again...