5 Replies Latest reply on Sep 20, 2004 6:57 AM by Kabir Khan

    Connection Pooling

    devloch Newbie

      I need some help with connection pooling for MS SQLSERVER2000. These are the steps I have followed:

      1) I have copied the mssql-db.xml file to the server/default/deploy folder.

      2) All drivers(jar files) are copied to the lib folder.

      3) This is the code I am using to use the connection pool.
      InitialContext ctx = new InitialContext();
      DataSource ds = (DataSource) ctx.lookup("java:comp/env/MSSQLDS");
      Connection conn = null;
      Statement stmt = null;

      try {
      conn = ds.getConnection();
      stmt = conn.createStatement();

      I get the following error : org.apache.jasper.JasperException: MSSQLDS not bound

      Please Help........