1 Reply Latest reply on Jan 28, 2003 4:07 PM by tommyg

    Pooling in JBoss

    sudhindraks

      How do i implement pooling in JBoss? What do i have to specify in the Deployment Descriptor?

      Regards
      Sudhindra

        • 1. Re: Pooling in JBoss
          tommyg

          This is how i do it in JBoss with Sybase
          1. go to docs/examples/jca and put your db specific data in sybase-service.xml (e.g. driver, username, password)
          2. you drop sybase-service.xml in the deploy directory.
          3. locate the jndi name in the file
          SybaseDS
          4. In a session facade bean write:
          InitialContext ctx = new InitialContext();
          DataSource ds = (DataSource) ctx.lookup(java:/SybaseDS);
          5. call 'Connection conn = ds.getConnection();'
          6. and when your done call 'conn.close();' and the connection is released back into the pool.