Rollback and autocommit with Oracle

From: David Havrda <havrda_at_fracta.com>
Date: 25 Jul 2001 15:09:08 -0700
Message-ID: <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 - 00:09:08 CEST

This message: [ Message body ]
Next message: Jim Kennedy: "Re: Rollback and autocommit with Oracle"
Previous message: dbahelp: "Re: Optimizing fetch of big result set - HELP!"
Next in thread: Jim Kennedy: "Re: Rollback and autocommit with Oracle"
Reply: Jim Kennedy: "Re: Rollback and autocommit with Oracle"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message