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!

auto-commit & stored procedures on oracle

843859Nov 5 2008 — edited Nov 20 2014
If all my application calls are stored procedures and functions on my oracle database, no embdedded PL/SQL exists in my Java code at all, and all of these functions and stored procedures contain their own commits, is it ok for me to turn off auto-commit completely and just close my connections once I'm done using them to make a call to the stored proc/function?

It seems Oracle automatically commits upon closing a connection normally anyway, so is by me currently leaving auto-commit to true, my code is technically doing two commits, one the default java behavior exhibits and the one the default oracle interpretation of JDBC commit when I close the connection?

What are other people out there doing with JDBC against an Oracle db?

Thanks, rlb
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 3 2008
Added on Nov 5 2008
5 comments
1,796 views