You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@commons.apache.org by Monica Ferrero <mo...@activehotels.com> on 2003/08/11 17:22:40 UTC

[DBCP]: 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>
          <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>

Re: [DBCP]: Tomcat+MySQL. Intermitent DbcpException: Server configuration denies access to data source

Posted by Anton Tagunov <at...@mail.cnt.ru>.

Hello Monica!

MF>         <parameter>
MF>           <name>removeAbandoned</name>
MF>           <value>true</value>
MF>         </parameter>

Not an expert on this at all but as there's utter silence on the list
I would dare to say that the remove Abondoned implementation has been
declared buggy. There have been hot discussions on this feature at all
and it looks like it's being deprecated in general. However,
independent of these discussions, the current implementation has
been declared buggy. Stay away from it.

Don't know about the logAbondoned feature - does your project
feel better if you remove that too? Just to be on the safe side :)

-Anton