commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dirk Verbeeck <dirk.verbe...@pandora.be>
Subject Re: [DBCP]: Tomcat+MySQL. Intermitent DbcpException: Server configuration denies access to data source
Date Fri, 22 Aug 2003 12:32:58 GMT
Hi Monica

Did the solution you got on this list solve your problem ?
http://weblists.camelot.co.pt/10/10093.html?grp=

Or is there still something wrong?


Dirk




Monica Ferrero wrote:

>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: commons-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: commons-user-help@jakarta.apache.org
>
>
>
>
>  
>




Mime
View raw message