Re: Turning autocommit off
Date: Wed, 20 Mar 2002 15:02:42 GMT
Message-ID: <mw1m8.77960$702.20514_at_sccrnsc02>
The database end does not have an autocommit option. There isn't any option
in Oracle to turn autocommit on. The driver is issuing commit statements
after each statement. This is bad and lazy programming practice; One of
the mmain features of a database is to have transactions! They have just
gotten rid of that capability effectively.
Jim
"Julian" <dushy_at_onebox.com> wrote in message
news:796c985.0203200653.3ae90db4_at_posting.google.com...
> I am trying to turn autocommit off for my application which queries
> (through embedded SQL) Oracle via JDBC.
> I am not allowed to use Connection.setAutoCommit(false) in my code
> (because it would negatively impact other applications).
>
> Is there any way for the Oracle DBA to turn this off from his end ?
>
> Any suggestions to solve this problem would be greately appreciated.
>
> Thank you,
> Julian.
Received on Wed Mar 20 2002 - 16:02:42 CET