JDBC driver gives error with batched insert

From: David <david.wynter_at_btclick.com>
Date: Fri, 4 Jan 2002 23:16:06 -0000
Message-ID: <TJqZ7.72808$Q66.265878@NewsReader>

I am using classes12.zip connected to 8.15i on W2K under the JRE 1.3.1.

I had code that worked with a executeUpdate call and a following commit, it still works now that I have setup using the
((OraclePreparedStatement)ps).sendBatch(); and the
((OracleConnection)conn).setDefaultExecuteBatch (1); at the appropriate
spots as outlined in the Oracle documentation, but only where it is set to the default of 1.

If I set it to a higher value then it fails everytime with an 17440 error - "DBItem/DBType is null". I have traced through the execution and all seems fine with the values and data types in the statement each time the ps.executeUpdate() occurs.

Any ideas or experience with this problem?

Thanks,

David Received on Fri Jan 04 2002 - 17:16:06 CST