0 Replies Latest reply on Dec 6, 2002 8:30 AM by Markus Härnvi

    Surviving Oracle restarts

    Markus Härnvi Newbie

      Hi!

      I have an EJB using a DAO to store stuff in Oracle 9.
      The DAO gets a new Connection for every method (calls DataSource.getConnection()), and closes it before returning.

      This works until someone restarts the Oracle server. Then I get a lot of "socket closed" exceptions until I restart JBoss. It seems like the connection pool still return broken connections to the DAO.

      How can I tell JBoss to automatically reconnect to the Oracle server when it's back online?