By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,086 Members | 1,919 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,086 IT Pros & Developers. It's quick & easy.

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

P: n/a
Hi!

I'm not sure if this is the most adequate mySQL list for this post. If not,
please indicat me which one I should use...

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.cr eateConnection
(DriverConnectionFactory.java:85)
at org.apache.commons.dbcp.PoolableConnectionFactory. makeObject
(PoolableConnectionFactory.java:184)
at org.apache.commons.pool.impl.GenericObjectPool.bor rowObject
(GenericObjectPool.java)
at org.apache.commons.dbcp.AbandonedObjectPool.borrow Object
(AbandonedObjectPool.java:117)
at org.apache.commons.dbcp.PoolingDataSource.getConne ction
(PoolingDataSource.java:110)
at org.apache.commons.dbcp.BasicDataSource.getConnect ion
(BasicDataSource.java:312)
at com.ah.auk.db.DBUtil.getDBConnection(DBUtil.java:5 4)
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.getHotelsPerCoun ty
(CountyHelper.java:100)
at com.ah.auk.box.CountyListBox.getCounties(CountyLis tBox.java:118)
at com.ah.auk.box.CountyListBox.configure(CountyListB ox.java:63)
at com.ah.auk.core.BoxManager.configureBoxes(BoxManag er.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.in ternalDoFilter
(Unknown Source)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(Unknown
Source)
at com.ah.auk.context.ContextFilter.doFilter(ContextF ilter.java:158)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter
(Unknown Source)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(Unknown
Source)
at org.apache.catalina.core.StandardWrapperValve.invo ke(Unknown
Source)
at
org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invok
eNext(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invoke(U nknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unkn own Source)
at org.apache.catalina.core.StandardContextValve.invo ke(Unknown
Source)
at
org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invok
eNext(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invoke(U nknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unkn own Source)
at org.apache.catalina.core.StandardContext.invoke(Un known Source)
at org.apache.catalina.core.StandardHostValve.invoke( Unknown Source)
at
org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invok
eNext(Unknown Source)
at org.apache.catalina.valves.ErrorDispatcherValve.in voke(Unknown
Source)
at
org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invok
eNext(Unknown Source)
at org.apache.catalina.valves.ErrorReportValve.invoke (Unknown
Source)
at
org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invok
eNext(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invoke(U nknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unkn own Source)
at org.apache.catalina.core.StandardEngineValve.invok e(Unknown
Source)
at
org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invok
eNext(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invoke(U nknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unkn own 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(ChannelS ocket.java:604)
at org.apache.jk.common.ChannelSocket.processConnecti on
(ChannelSocket.java:562)
at org.apache.jk.common.SocketConnection.runIt
(ChannelSocket.java:679)
at org.apache.tomcat.util.threads.ThreadPool$ControlR unnable.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(Unk nown Source)
at com.mysql.jdbc.Driver.connect(Unknown Source)
at org.apache.commons.dbcp.DriverConnectionFactory.cr eateConnection
(DriverConnectionFactory.java:83)
.... 49 more
SERVER.XML:
----------

<Server port="8005" shutdown="SHUTDOWN" debug="0">
<Listener className="org.apache.catalina.mbeans.ServerLifecy cleListener"
debug="0"/>
<Listener
className="org.apache.catalina.mbeans.GlobalResour cesLifecycleListener"
debug="0"/>

<GlobalNamingResources/>

<Service name="Tomcat-Standalone">

<!-- Define a Coyote/JK2 AJP 1.3 Connector on port 8009 -->
<Connector className="org.apache.coyote.tomcat4.CoyoteConnect or"
port="8009" minProcessors="5" maxProcessors="75"
enableLookups="true" redirectPort="8443"
acceptCount="10" debug="0" connectionTimeout="0"
useURIValidationHack="false"

protocolHandlerClassName="org.apache.jk.server.JkC oyoteHandler"/>

<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.BasicDataSourceFact ory</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>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw

Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.