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> > <name>logAbandoned</name> > <value>true</value> > </parameter> > <parameter> > <name>removeAbandoned</name> > <value>true</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 org.apache.jk.common.ChannelSocket.processConnection > (ChannelSocket.java:562) > at org.apache.jk.common.SocketConnection.runIt > (ChannelSocket.java:679) > at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run > (ThreadPool.java:619) > at java.lang.Thread.run(Thread.java:534) > Caused by: java.sql.SQLException: Server configuration denies access to > data source > at com.mysql.jdbc.MysqlIO.init(Unknown Source) > at com.mysql.jdbc.Connection.connectionInit(Unknown Source) at > com.mysql.jdbc.jdbc2.Connection.connectionInit(Unknown Source) > at com.mysql.jdbc.Driver.connect(Unknown Source) > at > org.apache.commons.dbcp.DriverConnectionFactory.createConnection > (DriverConnectionFactory.java:83) > ... 49 more > > > SERVER.XML: > ---------- > > <Server port="8005" shutdown="SHUTDOWN" debug="0"> > <Listener > className="org.apache.catalina.mbeans.ServerLifecycleListener" > debug="0"/> > <Listener > className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener" > debug="0"/> > > <GlobalNamingResources/> > > <Service name="Tomcat-Standalone"> > > <!-- Define a Coyote/JK2 AJP 1.3 Connector on port 8009 --> > <Connector className="org.apache.coyote.tomcat4.CoyoteConnector" > port="8009" minProcessors="5" maxProcessors="75" > enableLookups="true" redirectPort="8443" > acceptCount="10" debug="0" connectionTimeout="0" > useURIValidationHack="false" > > protocolHandlerClassName="org.apache.jk.server.JkCoyoteHandler"/> > > <Engine name="Standalone" defaultHost="localhost" debug="0"> > > <Logger className="org.apache.catalina.logger.FileLogger" > prefix="catalina_log." suffix=".txt" > timestamp="true"/> > > <Host name="localhost" debug="0" appBase="webapps" > unpackWARs="true" autoDeploy="false"> > <Logger className="org.apache.catalina.logger.FileLogger" > directory="logs" prefix="localhost_log." suffix=".txt" > timestamp="true"/> > <Context path="" docBase="/home/user/auk" debug="0" > reloadable="false" crossContext="false"> > <Resource name="jdbc/allukmasterDB" > auth="Container" > type="javax.sql.DataSource"/> > > <ResourceParams name="jdbc/allukmasterDB"> > <parameter> > <name>factory</name> > <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> > </parameter> > <parameter> > <name>maxActive</name> > <value>500</value> > </parameter> > <parameter> > <name>maxIdle</name> > <value>30</value> > </parameter> > <parameter> > <name>maxWait</name> > <value>10000</value> > </parameter> > <parameter> > <name>username</name> > <value>******</value> > </parameter> > <parameter> > <name>password</name> > <value>*******</value> > </parameter> > <parameter> > <name>driverClassName</name> > <value>org.gjt.mm.mysql.Driver</value> > </parameter> > <parameter> > <name>url</name> > <value>jdbc:mysql://localhost:3306/auk?autoReconnect=true</value> > </parameter> > <parameter> > <name>logAbandoned</name> > <value>true</value> > </parameter> > <parameter> > <name>removeAbandoned</name> > <value>true</value> > </parameter> > </ResourceParams> > </Context> > > </Host> > </Engine> > </Service> > </Server> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
