Re: Rollback and autocommit with Oracle

Oracle does not have an autocommit. A driver can impliment an autocommit (bad idea) by issueing a commit after every statement. I believe that if a statement raises an error just the statement is rolled back. You would have to issue a rollback (to roll everything back to the last commit) or a commit or do some other processing the commit or rollback. If your connection is lost then all uncommitted work is rolled back.

Jim
"David Havrda" <havrda_at_fracta.com> wrote in message news:844fce3c.0107251409.36e1382a_at_posting.google.com...
> I am using Oracle 8.1.7 on Windows 2000 communicating through java
> with objects mapped with Toplink using the weblogic connection pool.
> The problem I am having is that I am creating rows in several tables
> within a single transaction. The only problem is when an error occurs
> all of my data is not rolled back. Is there a problem with
> autocommit? Can I set the default commit status somewhere in the
> oracle init.ora file?
>
> Thanks,
> Dave
Received on Thu Jul 26 2001 - 04:15:36 CEST