I'm using the Oracle thin driver to update a batch of records using a prepared statement, addBatch() and executeBatch(). All of the updates go through fine and the data is updated correctly, but all of the updateCounts returned are "-2". I haven't been able to find any documentation for the thin driver, so I don't know if this return code is something I should be worried about, or if I should just ignore it.
Joe Sam Shirah From the JDK 1.3 Statement.executeBatch() API documentation: "A value of -2 -- indicates that the command was processed successfully but that the number of rows affected is unknown." See the documentation and Batch Update Facility for more information.