java.sql.SQLException: Io exception: not in streaming mode

My company is having a very difficult time with the exception: java.sql.SQLException: Io Exception: not in streaming mode.

We use connection pooling, and there is still one LONG column in our database that hasn't been converted to a CLOB or BLOB.

From what I've been able to find, there are three ways to cause this error.

1. Getting data from the resultset out of order, so you access something else after the long, then access the long, but the stream is closed.
2. Getting the long value using resultSet.getBytes(x)
3. Inserting a long value into the database while two threads access the same connection. If one of the threads closes the connection and one is still trying to insert the long, this error will occur.

However, we've gone diligently through the code, and we always access the resultSet in the proper order, we use resultSet.getString(x) to get the long, and there are no longs inserted into our database. In addition, we're using Oracle 8.1.6 with the latest jdbc driver for it.  We also use CLOBs and BLOBs.

The question is, does anyone know of any other ways to get the not in streaming mode exception? It shows up very randomly so that we can't nail it down, and when it does show up, that connection is rendered unusable and gets that error over and over if anyone tries to use it.

There is so little information on this error, can anyone help???? Please!!! Received on Mon Jul 16 2001 - 17:05:22 CEST