Strange behaviour of Apps. server
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Strange behaviour of Apps. server

  1. #1
    Join Date
    Jun 2001
    Posts
    150
    We are using JBOSS as our application server and it has a pool of connections for the clients. if a client do an update on a table through the application server in the database and if the client kills its connection by typing control c then it should rollback the transaction but that application server force it to be commited which should be rollback.
    so is there anyway to change the behaviour of the oracle to rollback when the any client kills its session instead of exit it.

    Thanks
    UKDBA

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    That sounds like more of a configuration issue with the app server and not oracle. Oracle will rollback any uncommitted transactions when it terminates a session.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Jun 2001
    Posts
    150
    I think you are right but i know that there is one way of doing it by writing a trigger which can do the job but i think there should be some other thing at session level .
    someone has any idea.
    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