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

[Monica Ferrero]

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.comm ons.dbcp.DbcpEx ception:
java.sql.SQLExc eption: 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>logAbando ned</name>
<value>true</value>
</parameter>
<parameter>
<name>removeAba ndoned</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 StandardWrapper Valve[StructureServle t]: Servlet.service
() for servlet StructureServle t threw exception
org.apache.comm ons.dbcp.DbcpEx ception: java.sql.SQLExc eption: Server
configuration denies access to data source
at org.apache.comm ons.dbcp.Driver ConnectionFacto ry.createConnec tion
(DriverConnecti onFactory.java: 85)
at org.apache.comm ons.dbcp.Poolab leConnectionFac tory.makeObject
(PoolableConnec tionFactory.jav a:184)
at org.apache.comm ons.pool.impl.G enericObjectPoo l.borrowObject
(GenericObjectP ool.java)
at org.apache.comm ons.dbcp.Abando nedObjectPool.b orrowObject
(AbandonedObjec tPool.java:117)
at org.apache.comm ons.dbcp.Poolin gDataSource.get Connection
(PoolingDataSou rce.java:110)
at org.apache.comm ons.dbcp.BasicD ataSource.getCo nnection
(BasicDataSourc e.java:312)
at com.ah.auk.db.D BUtil.getDBConn ection(DBUtil.j ava:54)
at com.ah.auk.db.D B.checkDBCon(DB .java:34)
at com.ah.auk.db.H otelDBReader.ge tHotelsInGeoEnt ry
(HotelDBReader. java:64)
at com.ah.auk.dele gates.CountyHel per.getHotelsPe rCounty
(CountyHelper.j ava:100)
at com.ah.auk.box. CountyListBox.g etCounties(Coun tyListBox.java: 118)
at com.ah.auk.box. CountyListBox.c onfigure(County ListBox.java:63 )
at com.ah.auk.core .BoxManager.con figureBoxes(Box Manager.java:41 )
at com.ah.auk.stru cture.Structure Servlet.doGet
(StructureServl et.java:74)
at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java)
at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java)
at org.apache.cata lina.core.Appli cationFilterCha in.internalDoFi lter
(Unknown Source)
at org.apache.cata lina.core.Appli cationFilterCha in.doFilter(Unk nown
Source)
at com.ah.auk.cont ext.ContextFilt er.doFilter(Con textFilter.java :158)
at org.apache.cata lina.core.Appli cationFilterCha in.internalDoFi lter
(Unknown Source)
at org.apache.cata lina.core.Appli cationFilterCha in.doFilter(Unk nown
Source)
at org.apache.cata lina.core.Stand ardWrapperValve .invoke(Unknown
Source)
at
org.apache.cata lina.core.Stand ardPipeline$Sta ndardPipelineVa lveContext.invo k
eNext(Unknown Source)
at org.apache.cata lina.core.Stand ardPipeline.inv oke(Unknown Source)
at org.apache.cata lina.core.Conta inerBase.invoke (Unknown Source)
at org.apache.cata lina.core.Stand ardContextValve .invoke(Unknown
Source)
at
org.apache.cata lina.core.Stand ardPipeline$Sta ndardPipelineVa lveContext.invo k
eNext(Unknown Source)
at org.apache.cata lina.core.Stand ardPipeline.inv oke(Unknown Source)
at org.apache.cata lina.core.Conta inerBase.invoke (Unknown Source)
at org.apache.cata lina.core.Stand ardContext.invo ke(Unknown Source)
at org.apache.cata lina.core.Stand ardHostValve.in voke(Unknown Source)
at
org.apache.cata lina.core.Stand ardPipeline$Sta ndardPipelineVa lveContext.invo k
eNext(Unknown Source)
at org.apache.cata lina.valves.Err orDispatcherVal ve.invoke(Unkno wn
Source)
at
org.apache.cata lina.core.Stand ardPipeline$Sta ndardPipelineVa lveContext.invo k
eNext(Unknown Source)
at org.apache.cata lina.valves.Err orReportValve.i nvoke(Unknown
Source)
at
org.apache.cata lina.core.Stand ardPipeline$Sta ndardPipelineVa lveContext.invo k
eNext(Unknown Source)
at org.apache.cata lina.core.Stand ardPipeline.inv oke(Unknown Source)
at org.apache.cata lina.core.Conta inerBase.invoke (Unknown Source)
at org.apache.cata lina.core.Stand ardEngineValve. invoke(Unknown
Source)
at
org.apache.cata lina.core.Stand ardPipeline$Sta ndardPipelineVa lveContext.invo k
eNext(Unknown Source)
at org.apache.cata lina.core.Stand ardPipeline.inv oke(Unknown Source)
at org.apache.cata lina.core.Conta inerBase.invoke (Unknown Source)
at org.apache.coyo te.tomcat4.Coyo teAdapter.servi ce
(CoyoteAdapter. java:223)
at org.apache.jk.s erver.JkCoyoteH andler.invoke
(JkCoyoteHandle r.java:261)
at org.apache.jk.c ommon.HandlerRe quest.invoke
(HandlerRequest .java:360)
at org.apache.jk.c ommon.ChannelSo cket.invoke(Cha nnelSocket.java :604)
at org.apache.jk.c ommon.ChannelSo cket.processCon nection
(ChannelSocket. java:562)
at org.apache.jk.c ommon.SocketCon nection.runIt
(ChannelSocket. java:679)
at org.apache.tomc at.util.threads .ThreadPool$Con trolRunnable.ru n
(ThreadPool.jav a:619)
at java.lang.Threa d.run(Thread.ja va:534)
Caused by: java.sql.SQLExc eption: Server configuration denies access to
data source
at com.mysql.jdbc. MysqlIO.init(Un known Source)
at com.mysql.jdbc. Connection.conn ectionInit(Unkn own Source)
at com.mysql.jdbc. jdbc2.Connectio n.connectionIni t(Unknown Source)
at com.mysql.jdbc. Driver.connect( Unknown Source)
at org.apache.comm ons.dbcp.Driver ConnectionFacto ry.createConnec tion
(DriverConnecti onFactory.java: 83)
.... 49 more
SERVER.XML:
----------

<Server port="8005" shutdown="SHUTD OWN" debug="0">
<Listener className="org. apache.catalina .mbeans.ServerL ifecycleListene r"
debug="0"/>
<Listener
className="org. apache.catalina .mbeans.GlobalR esourcesLifecyc leListener"
debug="0"/>

<GlobalNamingRe sources/>

<Service name="Tomcat-Standalone">

<!-- Define a Coyote/JK2 AJP 1.3 Connector on port 8009 -->
<Connector className="org. apache.coyote.t omcat4.CoyoteCo nnector"
port="8009" minProcessors=" 5" maxProcessors=" 75"
enableLookups=" true" redirectPort="8 443"
acceptCount="10 " debug="0" connectionTimeo ut="0"
useURIValidatio nHack="false"

protocolHandler ClassName="org. apache.jk.serve r.JkCoyoteHandl er"/>

<Engine name="Standalon e" defaultHost="lo calhost" debug="0">

<Logger className="org. apache.catalina .logger.FileLog ger"
prefix="catalin a_log." suffix=".txt"
timestamp="true "/>

<Host name="localhost " debug="0" appBase="webapp s"
unpackWARs="tru e" autoDeploy="fal se">
<Logger className="org. apache.catalina .logger.FileLog ger"
directory="logs " prefix="localho st_log." suffix=".txt"
timestamp="true "/>
<Context path="" docBase="/home/user/auk" debug="0"
reloadable="fal se" crossContext="f alse">
<Resource name="jdbc/allukmasterDB"
auth="Container "
type="javax.sql .DataSource"/>

<ResourcePara ms name="jdbc/allukmasterDB">
<parameter>
<name>factory </name>
<value>org.apac he.commons.dbcp .BasicDataSourc eFactory</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>usernam e</name>
<value>****** </value>
</parameter>
<parameter>
<name>passwor d</name>
<value>****** *</value>
</parameter>
<parameter>
<name>driverCla ssName</name>
<value>org.gjt. mm.mysql.Driver </value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:mys ql://localhost:3306/auk?autoReconne ct=true</value>
</parameter>
<parameter>
<name>logAbando ned</name>
<value>true</value>
</parameter>
<parameter>
<name>removeAba ndoned</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