DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Strange behaviour of Apps. server

  1. 06-22-2001, 11:05 AM #1
    UKDBA
    UKDBA is offline Member
    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
    Reply With Quote Reply With Quote
  2. 06-22-2001, 11:19 AM #2
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    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
    Reply With Quote Reply With Quote
  3. 06-22-2001, 11:34 AM #3
    UKDBA
    UKDBA is offline Member
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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