Too many Connection Problem Plz Help

[shuvra_pan]

I am getting Too Many Connection error in Tomcat5.5 and mysql Database while i am simultenously browsing my web application.


plz help me out...

[Steve11235]

Apparently, you are opening a new database connection every time you access your servlet, and then you leave the connection open.

One option is to simply close the connection in the servlet. However, opening a connection is *very* slow, so you will probably notice it in your response time.

The second option is to pool your connections. This is not terribly hard to do, but it does require thinking through synchronization issues and making sure that all servlets release the connections after requesting them.

[shuvra_pan]

thanz for reply...

1st thing is that i am not using any servlet i am using only jsp pages..

plz give me the sample ,how can i messure the time that how long the connection is open.

And plz give me an example of connection pooling..........

plz plz reply soon...

[Steve11235]

First, JSP pages are compiled by the Web Application Server into servlets.

I don't know of a connection method that tells when it was opened.

Pooling is a somewhat advanced topic, but it is essential in a Web application server environment.

Java provides connection pooling support through JNDI (Java Naming & Directory Interface). Here's a link.