auto-commit & stored procedures on oracle
843859Nov 5 2008 — edited Nov 20 2014If 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