Re Connection pooling

[kwame Iwegbue]

  
 
Context initCtx = new InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
DataSource ds = (DataSource)
  envCtx.lookup("jdbc/EmployeeDB");
 
Connection conn = ds.getConnection();
... use this connection to access the database ...
conn.close();
  

I know conn.close() returns the Connection to the pool, but does ds.getConnection() get a new Connection or simply get one from the pool. If so, at what point is a new Connection made?

[stu derby]

The pool decides whether to reuse an existing connection or create a new one. It does so based on the way the pooling code was written, and the way you configure it.

[kwame Iwegbue]

Thanks stu..

the code above doesn't seem to be working for me though!

 
Context initCtx = new InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
DataSource ds = (DataSource)
  envCtx.lookup("jdbc/EmployeeDB");

initCtx cannot be resolved

I'm using the code below in Tomcat 5.5

 
 
<Context>
  <Resource name="jdbc/EmployeeDB" auth="Container"
            type="javax.sql.DataSource" username="admin" password="pass"
            driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost/db"
            maxActive="8" maxIdle="4"/>
</Context>   

I tried placing <Context> in /META-INF/context.xml, then i tried placing it CATALINA_HOME/conf/server.xml and niether is working??

My web.xml has this (I'm using Servlet 2.4/ J2SE 1.5)

<resource-ref>
  <res-ref-name>
    jdbc/DB
  </res-ref-name>
  <res-type>
    javax.sql.DataSource
  </res-type>
  <res-auth>
    Container
  </res-auth>
</resource-ref>  

[ June 09, 2006: Message edited by: kwame Iwegbue ]

[ June 09, 2006: Message edited by: kwame Iwegbue ]
[ June 09, 2006: Message edited by: kwame Iwegbue ]

[Martin Simons]

Should not your resource ref be jdbc/EmployeeDB and not jdbc/DB ?