Java Mailing List Archive

http://www.junlu.com/

Home » Home (12/2007) » Tomcat Users »

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

Monica Ferrero

2003-08-11

Replies:

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: tomcat-user-unsubscribe@(protected)
For additional commands, e-mail: tomcat-user-help@(protected)


©2008 junlu.com - Jax Systems, LLC, U.S.A.