Broken ResultSet with DB2 and JDBC

From: Daniel Grundmann (Daniel.Grundmann_at_brockhaus-ag.de)
Date: 01/15/04


Date: Thu, 15 Jan 2004 10:41:10 +0100

Hi,
I have a serious problem, hopefully you can help:

I'm executing a simple select Statement like "Select * from <table> where
<column> = A".
The effect is that I can read several rows correctly but in one of the last
rows I can't get more Information from the Result set. The call
"resultSet.getObject(i)" does not return right in the middle of a row.

If I a non-JDBC-Tool the select works.
A "select count(*) from <table> where <column> = A" works.
If I change the parameter in the where-clause from "A" to "B" the select
works.

Any idea?
Im using the db2java.jar against a IBM DB2 V7.2

Thanks in advance,

Daniel