frequently facing error 'max_user_connections' active connections"

[rajiv.birari]

Hello Friends,

I am frequently facing error 'max_user_connections' active connections"
In my Java application with Mysql DB. I got error message on my tomcat server screen
as below -
javax.servlet.ServletException: User amit0208_root has already more than 'max_user_connections' active connections
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:858)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
org.apache.jsp.m.Default_jsp._jspService(Default_jsp.java:1210)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)


Please send me solution for this problem.
and try to help

[chazzy]

it means that you've created too many connections without closing them. you should use connection pooling or jndi connection lookup.