Sergio Muscat (sergio@onvol.net) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
Maximun number of connections
Long Description
What is the maximum number of connections that postgresql can support? I am writing a connection pool using jdbc/tomcat
andwhen the number of connections exceeds about 30 items, an exception is raised saying 'sorry too many clients
already'.Is this normal? See below for a dump of the exception.
Regards,
Sergio
Sample Code
Something unusual has occured to cause the driver to fail. Please report this exception: java.sql.SQLException: Sorry,
toomany clients already
at org.postgresql.Driver.connect(Driver.java:125)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:177)
at odrs.db.DBConnectionPool.<init>(DBConnectionPool.java:54)
at odrs.db.DBConnectionPool.getDBConnection(DBConnectionPool.java:74)
at odrs.sql.ClientLoginBean.<init>(ClientLoginBean.java:29)
at java.lang.Class.newInstance0(Native Method)
at java.lang.Class.newInstance(Class.java:237)
at java.beans.Beans.instantiate(Beans.java:207)
at java.beans.Beans.instantiate(Beans.java:51)
at
jsp._0002fjsp_0002fmainPage_0002ejspmainPage_jsp_0._jspService(_0002fjsp_0002fmainPage_0002ejspmainPage_jsp_0.java:75)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:177)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:318)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:391)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404)
at org.apache.tomcat.core.Handler.service(Handler.java:286)
at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:210)
at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498)
at java.lang.Thread.run(Thread.java:484)
No file was uploaded with this report
