0 Replies Latest reply on Mar 25, 2002 11:56 AM by Walter Collazzo

    jboss 2.4.4 connection pool problem

    Walter Collazzo Newbie

      Hi,
      I have this problem: i haw a servlet application that is connected with an
      oracle database:

      my jboss.jcml configuration is:


      oracle.jdbc.driver.OracleDriver



      tradePool
      org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl

      jdbc:oracle:thin:@10.78.0.13:1521:dtrade
      1200000
      xxx
      xxx
      false
      false
      false
      true
      120000
      1800000
      false
      true
      1.0
      0



      ibankPool
      org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl

      jdbc:oracle:thin:@10.78.0.13:1521:dibank
      1200000
      xxx
      xxx
      false
      false
      false
      true
      120000
      1800000
      false
      false
      1.0
      0



      my Servlet init() method:

      ic = new InitialContext();
      dsibank = (DataSource)ic.lookup("java:/ibankPool");
      dstrade = (DataSource)ic.lookup("java:/tradePool");
      Connection conDATA = dsibank.getConnection();
      Connection conTITO = dsibank.getConnection();
      ...

      this section work fine


      if the connection shutdown I restore it in the service() method:

      if (conDATA == null )
      conDATA = dsibank.getConnection();
      ...
      if (conTITO == null )
      conTITO = dstrade.getConnection();
      ...

      when I create a Statement on the conDATA all work ok;
      when I create a Statement on the conTITO I receive an
      SQLExcepion connection reset by peer.

      The only difference between the conDATA and conTITO is that conTITO have
      a setAutoCommit(true).

      Can anybody help me??


      Walter.