Hi all experts,

I am using the Tomcat server to deploy my web application. My web application accesses the MySQL database on the server.

I faced the problem of "Too many Connections" and went through a few websites regarding the error.

Finally, I found the solution and successfully implemented the Commons DBCP.

Now I want to know a few things :

DBCP creates a pool of connections. Connections r served on demand from this pool.

But still, in the code that I use in my JSP/Servlet, I have to explicitly close the connection....con.close().

Is it necessary to do that ?

What possible errors could I get if I don't do that ?

Could any1 please elaborate ?


Regards,
Sherbir

__________________
Regards,
Sherbir

Hello Sherbir,

In case an expert doesnt materialise...

Havent got round to connection pooling yet, but have started to look into it.

My understanding is that pooling should not close connections, the whole point is to avoid this, or more specifically the overhead of opening/closing the connections.

You must use JNDI to make use of connection pooling which is done in by editing both server.xml and web.xml.

Once this is done you can use the JNDI reference from jsp pages.

If using servlets or beans you also need to change code to use JNDI, in short you do NOT use JDBC directly in your code.

The code I tested with did not close the connection.

The best intro to this I have found is actually in the Tomcat documentation, section 9, JDBC data sources.