rollback on exit
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: rollback on exit

  1. #1
    Join Date
    Jun 2001
    Posts
    150
    Is there anyway to set the behaviour of sqlplus to rollback on exit instead of commit. i have set the autocommit off.
    UKDBA

  2. #2
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    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

  3. #3
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    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

  4. #4
    Join Date
    Jun 2001
    Posts
    150
    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
  •  


Click Here to Expand Forum to Full Width