Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

executeBatch commits despite autocommit(false)

843854Nov 19 2001 — edited Nov 19 2001
Hello !

Can someone explain the jdbc-spec to me ?
Should executeBatch commit the transcations if no excpetion was
thrown ?
It seems that the oracle-driver does commit after executeBatch.
I don't think this is right (according to the jdbc-spec) and for us it
is really annoying since we wanted to use a temporary table
with "on commit delete rows". which has the effect, that the table
is empty after inserting with executeBatch (very clever).
The temporary table with "on commit preserve rows" works fine.

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 17 2001
Added on Nov 19 2001
1 comment
344 views