-
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
-
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.
-
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
