-
Is there anyway to set the behaviour of sqlplus to rollback on exit instead of commit. i have set the autocommit off.
UKDBA
-
Good Question
Hi, 23rd June 2001 13:50 hrs chennai
DDL statements , exiting or even DISCONNECT from SQL*Plus causes an IMPLICIT COMMIT.
One way is simply closing the session without EXIT or QUIT in SQLPLUS wont commit the transaction.
Transaction Control Commands manage changes made by Data Manipulation Language commands. A transaction (or logical unit of work) is a sequence of SQL statements that ORACLE treats as a single unit. A transaction ends with a commit, rollback , exit, or any DDL statement which issues an implicit commit. In most cases transactions are implicitly controlled.
if you want to work your way of exit still there is a option as said in this link.
http://www.arsdigita.com/free-tools/oracle-driver.html
Auto commit how to work out with example scripts
http://misdb.bpa.arizona.edu/~mis696...t/demosql.html
An interesting finding
http://groups.yahoo.com/group/dbi-users/message/13727
Any more info on Autocommit from others welcome
Cheers
Padmam.
Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it
-
More info
Hi, 23rd June 2001 15:08 hrs chennai
Setting Auto commit on or off means as explained here.
http://kachina.kennesaw.edu/~jwarren/modbsql2.html
Cheers
Padmam
Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it
-
But i have the problem that when application server is commiting the updates even though the transaction is aborted in the client session or you can say that the client session died due to some reason.so now we want to rollback the transaction but the case is that it commited half of the transaction which is bizarre. It is really difficult to do any thing on the application server becasue this means to rewrite the kernel of the application server.
so we need to change the default behaviour of the sqlplus that it commits only when the user types commit.
ukdba
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|