Oracle: Disconnection problem
I have a java client and an oracle server. How can I restore disconnected oracle-session, when internet connection uncoupled, and then established again. Or at least how to close that dead session?
When I create a new instance of java.sql.Connection (after disconnection) then oracle serever generetes a new session for my application. It is not very appropriate way for me, becasue there are very strong limitations on opened sessions and with these dead sessions my application can quicly exceed the limit.
Thanks in advance.