0 Replies Latest reply on Dec 19, 2001 10:03 AM by eddy

    DB Pooling

    eddy Newbie

      Hi Guys,
      I am experiencing a db pooling issue. I use Jbss 2.4.4 with Tomcat 3.2.3. I use SQL Server 2000. I made connection in the EJB(bmp). It is working fine.
      I can connection to database and retrive data. However, if I kill the process in the SQL Server, the Jboss can not reconnect to database unless I have to restart the Jboss.

      Do you guys have the same problem before?
      How to solve this kind of problem.
      If you have any idea, please let me know

      Thanks in advanced.

      Eddy


      PE: Here is my code
      ================================
      InitialContext ctx = new InitialContext();
      DataSource ds = (DataSource)ctx.lookup("java:/SQLServerPool");

      Connection conn = ds.getConnection();