Re: Tomcat+MySQL. Intermitent DbcpException: Server configuration denies access to data source - Now pool exhausted
Hello! I got an answer in the mySQL list, that pointed out that my number of connections 500, was a lot more than the normal value of 100. Changing that solved the problem of the Server configuration error, but I've gone back to getting java.sql.SQLException: DBCP could not obtain an idle db connection, pool exhausted (whole exception follows). I thought the configuration parameter namelogAbandoned/name valuetrue/value /parameter parameter nameremoveAbandoned/name valuetrue/value /parameter would free and log abandoned connections, but it doesn't seem to do it. Anyway, I have checked over all my result sets, statements and connections and I think they are all closed properly... So I'm still a bit stuck here... Some other person in the Commons list, suggested that there might be some problems with the DBCP, could it be so? Any other suggestions? Any help really appreciated. Monica Hi! I'm using Tomcat 4.1.24 with Apache 2 and MySQL 4.0.13. I have the mysql- connector-java-2.0.14-bin.jar in commons/lib. The application runs normally, and usually about once or twice a day I get this exception org.apache.commons.dbcp.DbcpException: java.sql.SQLException: Server configuration denies access to data source. Once the exception occurs, it happens for every request and Tomcat needs restarting. Before getting this exception, I used to run out of connections, and therefore I added to the server.xml parameter namelogAbandoned/name valuetrue/value /parameter parameter nameremoveAbandoned/name valuetrue/value /parameter I guess it could be related... I include the exception and my server.xml file. Any help appreciated. Monica 2003-08-07 15:55:02 StandardWrapperValve[StructureServlet]: Servlet.service () for servlet StructureServlet threw exception org.apache.commons.dbcp.DbcpException: java.sql.SQLException: Server configuration denies access to data source at org.apache.commons.dbcp.DriverConnectionFactory.createConnection (DriverConnectionFactory.java:85) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject (PoolableConnectionFactory.java:184) at org.apache.commons.pool.impl.GenericObjectPool.borrowObject (GenericObjectPool.java) at org.apache.commons.dbcp.AbandonedObjectPool.borrowObject (AbandonedObjectPool.java:117) at org.apache.commons.dbcp.PoolingDataSource.getConnection (PoolingDataSource.java:110) at org.apache.commons.dbcp.BasicDataSource.getConnection (BasicDataSource.java:312) at com.ah.auk.db.DBUtil.getDBConnection(DBUtil.java:54) at com.ah.auk.db.DB.checkDBCon(DB.java:34) at com.ah.auk.db.HotelDBReader.getHotelsInGeoEntry (HotelDBReader.java:64) at com.ah.auk.delegates.CountyHelper.getHotelsPerCounty (CountyHelper.java:100) at com.ah.auk.box.CountyListBox.getCounties(CountyListBox.java:118) at com.ah.auk.box.CountyListBox.configure(CountyListBox.java:63) at com.ah.auk.core.BoxManager.configureBoxes(BoxManager.java:41) at com.ah.auk.structure.StructureServlet.doGet (StructureServlet.java:74) at javax.servlet.http.HttpServlet.service(HttpServlet.java) at javax.servlet.http.HttpServlet.service(HttpServlet.java) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source) at com.ah.auk.context.ContextFilter.doFilter(ContextFilter.java:158) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source) at org.apache.catalina.core.StandardWrapperValve.invoke(Unknown Source) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(Unknown Source) at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source) at org.apache.catalina.core.ContainerBase.invoke(Unknown Source) at org.apache.catalina.core.StandardContextValve.invoke(Unknown Source) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(Unknown Source) at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source) at org.apache.catalina.core.ContainerBase.invoke(Unknown Source) at org.apache.catalina.core.StandardContext.invoke(Unknown Source) at org.apache.catalina.core.StandardHostValve.invoke(Unknown Source) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(Unknown Source) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(Unknown Source) at
Tomcat+MySQL. Intermitent DbcpException: Server configuration denies access to data source
Hi! I'm using Tomcat 4.1.24 with Apache 2 and MySQL 4.0.13. I have the mysql- connector-java-2.0.14-bin.jar in commons/lib. The application runs normally, and usually about once or twice a day I get this exception org.apache.commons.dbcp.DbcpException: java.sql.SQLException: Server configuration denies access to data source. Once the exception occurs, it happens for every request and Tomcat needs restarting. Before getting this exception, I used to run out of connections, and therefore I added to the server.xml parameter namelogAbandoned/name valuetrue/value /parameter parameter nameremoveAbandoned/name valuetrue/value /parameter I guess it could be related... I include the exception and my server.xml file. Any help appreciated. Monica 2003-08-07 15:55:02 StandardWrapperValve[StructureServlet]: Servlet.service () for servlet StructureServlet threw exception org.apache.commons.dbcp.DbcpException: java.sql.SQLException: Server configuration denies access to data source at org.apache.commons.dbcp.DriverConnectionFactory.createConnection (DriverConnectionFactory.java:85) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject (PoolableConnectionFactory.java:184) at org.apache.commons.pool.impl.GenericObjectPool.borrowObject (GenericObjectPool.java) at org.apache.commons.dbcp.AbandonedObjectPool.borrowObject (AbandonedObjectPool.java:117) at org.apache.commons.dbcp.PoolingDataSource.getConnection (PoolingDataSource.java:110) at org.apache.commons.dbcp.BasicDataSource.getConnection (BasicDataSource.java:312) at com.ah.auk.db.DBUtil.getDBConnection(DBUtil.java:54) at com.ah.auk.db.DB.checkDBCon(DB.java:34) at com.ah.auk.db.HotelDBReader.getHotelsInGeoEntry (HotelDBReader.java:64) at com.ah.auk.delegates.CountyHelper.getHotelsPerCounty (CountyHelper.java:100) at com.ah.auk.box.CountyListBox.getCounties(CountyListBox.java:118) at com.ah.auk.box.CountyListBox.configure(CountyListBox.java:63) at com.ah.auk.core.BoxManager.configureBoxes(BoxManager.java:41) at com.ah.auk.structure.StructureServlet.doGet (StructureServlet.java:74) at javax.servlet.http.HttpServlet.service(HttpServlet.java) at javax.servlet.http.HttpServlet.service(HttpServlet.java) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source) at com.ah.auk.context.ContextFilter.doFilter(ContextFilter.java:158) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source) at org.apache.catalina.core.StandardWrapperValve.invoke(Unknown Source) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(Unknown Source) at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source) at org.apache.catalina.core.ContainerBase.invoke(Unknown Source) at org.apache.catalina.core.StandardContextValve.invoke(Unknown Source) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(Unknown Source) at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source) at org.apache.catalina.core.ContainerBase.invoke(Unknown Source) at org.apache.catalina.core.StandardContext.invoke(Unknown Source) at org.apache.catalina.core.StandardHostValve.invoke(Unknown Source) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(Unknown Source) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(Unknown Source) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(Unknown Source) at org.apache.catalina.valves.ErrorReportValve.invoke(Unknown Source) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(Unknown Source) at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source) at org.apache.catalina.core.ContainerBase.invoke(Unknown Source) at org.apache.catalina.core.StandardEngineValve.invoke(Unknown Source) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(Unknown Source) at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source) at org.apache.catalina.core.ContainerBase.invoke(Unknown Source) at org.apache.coyote.tomcat4.CoyoteAdapter.service (CoyoteAdapter.java:223) at org.apache.jk.server.JkCoyoteHandler.invoke (JkCoyoteHandler.java:261) at org.apache.jk.common.HandlerRequest.invoke (HandlerRequest.java:360) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:604) at
[RePost] Tomcat+MySQL. Intermitent DbcpException: Server configuration denies access to data source
Hi! I haven't got any answers to my question and I'm really stuck with it. Please, could anybody give me some ideas or do you need any other information? Thansk a lot. Monica Hi! I'm using Tomcat 4.1.24 with Apache 2 and MySQL 4.0.13. I have the mysql- connector-java-2.0.14-bin.jar in commons/lib. The application runs normally, and usually about once or twice a day I get this exception org.apache.commons.dbcp.DbcpException: java.sql.SQLException: Server configuration denies access to data source. Once the exception occurs, it happens for every request and Tomcat needs restarting. Before getting this exception, I used to run out of connections, and therefore I added to the server.xml parameter namelogAbandoned/name valuetrue/value /parameter parameter nameremoveAbandoned/name valuetrue/value /parameter I guess it could be related... I include the exception and my server.xml file. Any help appreciated. Monica 2003-08-07 15:55:02 StandardWrapperValve[StructureServlet]: Servlet.service () for servlet StructureServlet threw exception org.apache.commons.dbcp.DbcpException: java.sql.SQLException: Server configuration denies access to data source at org.apache.commons.dbcp.DriverConnectionFactory.createConnection (DriverConnectionFactory.java:85) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject (PoolableConnectionFactory.java:184) at org.apache.commons.pool.impl.GenericObjectPool.borrowObject (GenericObjectPool.java) at org.apache.commons.dbcp.AbandonedObjectPool.borrowObject (AbandonedObjectPool.java:117) at org.apache.commons.dbcp.PoolingDataSource.getConnection (PoolingDataSource.java:110) at org.apache.commons.dbcp.BasicDataSource.getConnection (BasicDataSource.java:312) at com.ah.auk.db.DBUtil.getDBConnection(DBUtil.java:54) at com.ah.auk.db.DB.checkDBCon(DB.java:34) at com.ah.auk.db.HotelDBReader.getHotelsInGeoEntry (HotelDBReader.java:64) at com.ah.auk.delegates.CountyHelper.getHotelsPerCounty (CountyHelper.java:100) at com.ah.auk.box.CountyListBox.getCounties(CountyListBox.java:118) at com.ah.auk.box.CountyListBox.configure(CountyListBox.java:63) at com.ah.auk.core.BoxManager.configureBoxes(BoxManager.java:41) at com.ah.auk.structure.StructureServlet.doGet (StructureServlet.java:74) at javax.servlet.http.HttpServlet.service(HttpServlet.java) at javax.servlet.http.HttpServlet.service(HttpServlet.java) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source) at com.ah.auk.context.ContextFilter.doFilter(ContextFilter.java:158) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source) at org.apache.catalina.core.StandardWrapperValve.invoke(Unknown Source) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(Unknown Source) at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source) at org.apache.catalina.core.ContainerBase.invoke(Unknown Source) at org.apache.catalina.core.StandardContextValve.invoke(Unknown Source) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(Unknown Source) at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source) at org.apache.catalina.core.ContainerBase.invoke(Unknown Source) at org.apache.catalina.core.StandardContext.invoke(Unknown Source) at org.apache.catalina.core.StandardHostValve.invoke(Unknown Source) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(Unknown Source) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(Unknown Source) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(Unknown Source) at org.apache.catalina.valves.ErrorReportValve.invoke(Unknown Source) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(Unknown Source) at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source) at org.apache.catalina.core.ContainerBase.invoke(Unknown Source) at org.apache.catalina.core.StandardEngineValve.invoke(Unknown Source) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(Unknown Source) at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source) at org.apache.catalina.core.ContainerBase.invoke(Unknown Source) at org.apache.coyote.tomcat4.CoyoteAdapter.service
