2 Replies Latest reply: Sep 23, 2013 5:36 PM by rp0428 RSS

    Wait seconds before close connection

    12ee68ed-a2db-4561-8e55-452bdeb258b7

      Hello, Is possible, get a jdbc connection, that in case of a down problem, for example because a wifi connection, it disconnect, but reconnect and give the previous session ?

        • 1. Re: Wait seconds before close connection
          Joe Weinstein-Oracle

          Hi, for the most part, the answer is no. Once the DBMS detects the client/net has disconnected, the

          DBMS closes out the session and rolls back everything left uncommitted on that session. With some

          very special setup, and involving only the latest Oracle DBMS and Oracle driver, there is a possible

          replay service where the driver will try to reconnect internally when it discovers a disconnect, and if

          things have been set up by you correctly, including some special code to tell the driver what your

          replay boundaries are, it will try to replay everything you'd done so far and to transparently get you

          to where you thought you were, but with a new session. Other limitations may apply.

          • 2. Re: Wait seconds before close connection
            rp0428
            Hello, Is possible, get a jdbc connection, that in case of a down problem, for example because a wifi connection, it disconnect, but reconnect and give the previous session ?

            If you need help with a problem or issue you are having then post ALL of the relevant information about the problem.

             

            We can't see you monitor or what code you are running and have no idea what database  or version you are using, what Java version you are using or what JDBC jar file and version you are using.