5 Replies Latest reply on Apr 2, 2003 12:20 AM by David Jencks

    Reconnecting after RDBMS failure

    Denis Demichev Newbie

      Hi.
      Currently using JBoss 3.0.2 and Oracle 8.1.7 on Suse 7.3 as RDBMS .
      I've configured connection pool using the example from docs/examples/jca/oracle-service.xml Everything goes well until the RDBMS failure (Oracle has memory leaks in jdbc requests handling). I restarted the database without shutdowning JBoss. I couldn't execute any SQL statement after that. Here's SQLException I've got:
      Connection reset by peer: socket write error.
      The following abstract shows how do I get Connection from the pool before sql statement execution:
      InitialContect ic = new InitialContext();
      DataSource ds = (DataSource)ic.lookup(jndiName);
      Connection conn = ds.getConnection();

      After getting SQLException:
      conn.close();

      Abstract from oracle-service.xml:

      0
      50
      5000
      15
      ByContainer