JNDI datasource

[greygirl]

Help!!
I am using JNDI datasource for connectionpooling with oracle 9i and Tomcat as appserver. Everything works well. My question is when I am done with all the database activities, don't I have to close the pool somewhere....??? I am closing the connection, the resultset, statement and all that. But how about the pool itself??
Suraj

 

[sedj]

The point of a connection pool, is that the client (ie Tomcat in this case) maintains a number of constant connections to the database - thus eliminating the time to make IO net conns to the db server. So, the pool should never be "shut down" unless your client (Tomcat) shuts down. Closing the db related objects is good enough, and you should not concern yourself with the pool.