Adding support for large update counts

Lance Andersen - Oracle Lance.Andersen at oracle.com
Sun Nov 25 12:52:31 PST 2012


The jdbc methods which return an update count only return an int value.  As datasets continue to grow, this has caused problems for some JDBC vendors.

To address this problem, we will add the following methods to Statement which will return a long. These methods should be used when the returned row count may exceed Integer.MAX_VALUE.

executetLargeBatch
executeLargeUpdate
getLargeUpdateCount
getLargeMaxRows

Overload

setMaxRows(long rows)


We will also need to update  BatchUpdateException to also accommodate this change by adding:

- getLargeUpdateCounts
- a long[] for updateCounts
- a constructor which takes long[] for the updatecounts


Lance Andersen| Principal Member of Technical Staff | +1.781.442.2037
Oracle Java Engineering 
1 Network Drive 
Burlington, MA 01803
Lance.Andersen at oracle.com


More information about the jdbc-spec-discuss mailing list