The following code is called upon the initialization of my Web Application:
System.out.println("Loading underlying JDBC driver.");
try {
Class.forName("org.gjt.mm.mysql.Driver");
Class.forName("org.apache.commons.dbcp.PoolingDriver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
System.out.println("Done.");
System.setProperty("org.xml.sax.driver", "org.apache.xerces.parsers.SAXParser");
In a web app you should use a JNDI lookup for the DataSoure. Furthermore, see copy of related message below: ==> Frank: I had a similar problem, first you have to change your resource param = to use the org.apache.commons.dbcp.BasicDataSourceFactory. If you do not = use org.apache.commons.dbcp.BasicDataSourceFactory, you will get stuck = with the default, which did not seem to work well for me. Use this as an = example, and of course check you code for leaks, and race conditions. -Jerry
<!-- JNDI Name for the DataSource -->
<Resource name="jdbc/SOMENAME" auth="Container" =
type="javax.sql.DataSource" /> <ResourceParams name="jdbc/SOMENAME">
<parameter>
<name>factory</name> =
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>=09
=20
<parameter>
<name>username</name> <value>88888</value>
</parameter> <parameter>
<name>password</name> <value>888888</value>
</parameter> <parameter>
<name>driverClassName</name> <value>com.sybase.jdbc2.jdbc.SybDriver</value>
</parameter>
=20
<parameter>
<name>testOnBorrow</name> <value>true</value>
</parameter>
=20
<parameter>
<name>testOnReturn</name> <value>false</value>
</parameter>
=20
=20
<parameter>
<name>validationQuery</name> <value>SELECT count(*) FROM MYTABLE</value>
</parameter>=09
=20
<parameter>
<name>url</name>
<value>url</value>
</parameter>
=20
<!-- Maximum number of dB connections in pool. Make
sure you
configure your DB max connections large enough to
handle
all of your db connections. Set to 0 for no limit.
-->
<parameter>
<name>maxActive</name> <value>40</value>
</parameter>
<!-- Maximum number of idle dB connections to retain
in pool.
Set to 0 for no limit.=20
-->
<parameter>
<name>maxIdle</name> <value>5</value>
</parameter>
=20
<!-- Maximum time to wait for a dB connection to =
become available
in ms, in this example 10 seconds. An Exception is
thrown =
if
this timeout is exceeded. Set to -1 to wait =
indefinitely.=20
-->
<parameter>
<name>maxWait</name>
<value>-1</value>
</parameter>
=20
</ResourceParams>-----Original Message----- From: Frank Stolze [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 11:28 AM To: [EMAIL PROTECTED] Subject: [DBCP] Deadlock problem?
Hi,
I have been having some problems with Tomcat + DBCP for some time now. I made every effort to find the problem myself and also look through the mailing list archives, but it seems that I'm at a dead end now. Here is my problem:
Tomcat 4.1.27 Commons-Pool 1.1 Commons-DBCP 1.1 PostgreSQL 7.3.3
While everything works beautifully for a while, at some (seemingly) random point in time getting a db connection from the pool fails. Database connections are available, both idle and not yet established.
Configuration:
<Resource auth="Container" name="jdbc/Public"
scope="Shareable" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/Public">
<parameter>
<name>password</name>
<value>xxxx</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:postgresql://localhost:5432/bfth_db</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>org.postgresql.Driver</value>
</parameter>
<parameter>
<name>username</name>
<value>xxxx</value>
</parameter>
</ResourceParams>Here are two representative thread dumps:
=== Full thread dump Java HotSpot(TM) Server VM (1.4.2-b28 mixed mode):
"MonitorRunnable" daemon prio=1 tid=0x08669ad0 nid=0x722c in
Object.wait() [4f7a2000..4f7a28b8]
at java.lang.Object.wait(Native Method)
- waiting on <0x464199f0> (a
org.apache.tomcat.util.threads.ThreadPool$MonitorRunnable)
at
org.apache.tomcat.util.threads.ThreadPool$MonitorRunnable.run(ThreadPool.=
java:503)
- locked <0x464199f0> (a
org.apache.tomcat.util.threads.ThreadPool$MonitorRunnable)
at java.lang.Thread.run(Thread.java:534)"Thread-10" daemon prio=1 tid=0x0857f988 nid=0x722b runnable
[4f721000..4f7218b8]
at java.net.PlainSocketImpl.socketAccept(Native Method)
at java.net.PlainSocketImpl.accept(PlainSocketImpl.java:353)
- locked <0x46419a70> (a java.net.PlainSocketImpl)
at java.net.ServerSocket.implAccept(ServerSocket.java:448)
at java.net.ServerSocket.accept(ServerSocket.java:419)
at org.apache.jk.common.ChannelSocket.accept(ChannelSocket.java:268)
at
org.apache.jk.common.ChannelSocket.acceptConnections(ChannelSocket.java:5=
31)
at org.apache.jk.common.SocketAcceptor.runIt(ChannelSocket.java:660)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.=
java:619)
at java.lang.Thread.run(Thread.java:534)"Thread-9" daemon prio=1 tid=0x087342c0 nid=0x722a in =
Object.wait()
[4f6a0000..4f6a08b8]
at java.lang.Object.wait(Native Method)
- waiting on <0x46419c68> (a
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable)
at java.lang.Object.wait(Object.java:429)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.=
java:595)
- locked <0x46419c68> (a
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable)
at java.lang.Thread.run(Thread.java:534)"Thread-8" daemon prio=1 tid=0x08734008 nid=0x7229 in =
Object.wait()
[4f61f000..4f61f8b8]
at java.lang.Object.wait(Native Method)
- waiting on <0x46419ce0> (a
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable)
at java.lang.Object.wait(Object.java:429)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.=
java:595)
- locked <0x46419ce0> (a
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable)
at java.lang.Thread.run(Thread.java:534)"Thread-7" daemon prio=1 tid=0x0857ffe0 nid=0x7228 in =
Object.wait()
[4f59e000..4f59e8b8]
at java.lang.Object.wait(Native Method)
- waiting on <0x46419d58> (a
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable)
at java.lang.Object.wait(Object.java:429)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.=
java:595)
- locked <0x46419d58> (a
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable)
at java.lang.Thread.run(Thread.java:534)"MonitorRunnable" daemon prio=1 tid=0x4e4f8818 nid=0x7227 in
Object.wait() [4f51d000..4f51d8b8]
at java.lang.Object.wait(Native Method)
- waiting on <0x466dd8> (a
org.apache.tomcat.util.threads.ThreadPool$MonitorRunnable)
at
org.apache.tomcat.util.threads.ThreadPool$MonitorRunnable.run(ThreadPool.=
java:503)
- locked <0x466dd8> (a
org.apache.tomcat.util.threads.ThreadPool$MonitorRunnable)
at java.lang.Thread.run(Thread.java:534)"Thread-5" daemon prio=1 tid=0x4e2b60c8 nid=0x7226 in =
Object.wait()
[4f49b000..4f49c8b8]
at java.lang.Object.wait(Native Method)
- waiting on <0x46514830> (a
org.apache.commons.pool.impl.GenericObjectPool)
at java.lang.Object.wait(Object.java:429)
at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObject=
Pool.java:793)
- locked <0x46514830> (a
org.apache.commons.pool.impl.GenericObjectPool)
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource=
.java:140)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.jav=
a:518)
at com.bfth.util.DBBean.getTotalProductCount(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java=
:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI=
mpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.apache.taglibs.standard.lang.jstl.ArraySuffix.evaluate(ArraySuffix.ja=
va:317)
at
org.apache.taglibs.standard.lang.jstl.ComplexValue.evaluate(ComplexValue.=
java:146)
at
org.apache.taglibs.standard.lang.jstl.ELEvaluator.evaluate(ELEvaluator.ja=
va:242)
at
org.apache.taglibs.standard.lang.jstl.ELEvaluator.evaluate(ELEvaluator.ja=
va:201)
at
org.apache.taglibs.standard.lang.jstl.Evaluator.evaluate(Evaluator.java:1=
38)
at
org.apache.taglibs.standard.lang.jstl.Evaluator.evaluate(Evaluator.java:1=
66)
at
org.apache.taglibs.standard.lang.support.ExpressionEvaluatorManager.evalu=
ate(ExpressionEvaluatorManager.java:112)
at
org.apache.taglibs.standard.tag.el.core.ExpressionUtil.evalNotNull(Expres=
sionUtil.java:85)
at
org.apache.taglibs.standard.tag.el.core.OutTag.evaluateExpressions(OutTag=
.java:137)
at
org.apache.taglibs.standard.tag.el.core.OutTag.doStartTag(OutTag.java:95)= at
org.apache.jsp.products_jsp._jspx_meth_c_out_0(products_jsp.java:336)
at org.apache.jsp.products_jsp._jspService(products_jsp.java:147)
at org.apache.jasper.runtime.HttpJspBase.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServletWrapper.service(Unknown Source)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(Unknown Source)
at org.apache.jasper.servlet.JspServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
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.in=
vokeNext(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.in=
vokeNext(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.in=
vokeNext(Unknown Source)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(Unknown
Source)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.in=
vokeNext(Unknown Source)
at org.apache.catalina.valves.ErrorReportValve.invoke(Unknown Source)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.in=
vokeNext(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.in=
vokeNext(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.coyote.http11.Http11Processor.process(Http11Processor.java:601=
)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processCo=
nnection(Http11Protocol.java:392)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565=
)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.=
java:619)
at java.lang.Thread.run(Thread.java:534)"Thread-4" daemon prio=1 tid=0x4e24b3e8 nid=0x7225 runnable
[4f41b000..4f41b8b8]
at java.net.PlainSocketImpl.socketAccept(Native Method)
at java.net.PlainSocketImpl.accept(PlainSocketImpl.java:353)
- locked <0x462d5758> (a java.net.PlainSocketImpl)
at java.net.ServerSocket.implAccept(ServerSocket.java:448)
at java.net.ServerSocket.accept(ServerSocket.java:419)
at
org.apache.tomcat.util.net.DefaultServerSocketFactory.acceptSocket(Defaul=
tServerSocketFactory.java:107)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.acceptSocket(PoolTcpEndpoint.j=
ava:356)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:529=
)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.=
java:619)
at java.lang.Thread.run(Thread.java:534)"Thread-3" daemon prio=1 tid=0x4e24b288 nid=0x7224 in =
Object.wait()
[4f399000..4f39a8b8]
at java.lang.Object.wait(Native Method)
- waiting on <0x46514830> (a
org.apache.commons.pool.impl.GenericObjectPool)
at java.lang.Object.wait(Object.java:429)
at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObject=
Pool.java:793)
- locked <0x46514830> (a
org.apache.commons.pool.impl.GenericObjectPool)
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource=
.java:140)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.jav=
a:518)
at com.bfth.export.CSVGenerator.prepare(Unknown Source)
at
com.bfth.export.DataFileGeneratorFactory.getDataFileGenerator(Unknown
Source)
at com.bfth.export.DataFileGeneratorServlet.doGet(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
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.in=
vokeNext(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.in=
vokeNext(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.in=
vokeNext(Unknown Source)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(Unknown
Source)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.in=
vokeNext(Unknown Source)
at org.apache.catalina.valves.ErrorReportValve.invoke(Unknown Source)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.in=
vokeNext(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.in=
vokeNext(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.coyote.http11.Http11Processor.process(Http11Processor.java:601=
)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processCo=
nnection(Http11Protocol.java:392)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565=
)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.=
java:619)
at java.lang.Thread.run(Thread.java:534)"Thread-2" daemon prio=1 tid=0x4e24b068 nid=0x7223 in =
Object.wait()
[4f319000..4f3198b8]
at java.lang.Object.wait(Native Method)
- waiting on <0x466ff0> (a
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable)
at java.lang.Object.wait(Object.java:429)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.=
java:595)
- locked <0x466ff0> (a
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable)
at java.lang.Thread.run(Thread.java:534)"HostConfig[localhost]" daemon prio=1 tid=0x4e24ae18 nid=0x7222 =
waiting
on condition [4f298000..4f2988b8]
at java.lang.Thread.sleep(Native Method)
at org.apache.catalina.startup.HostConfig.threadSleep(Unknown Source)
at org.apache.catalina.startup.HostConfig.run(Unknown Source)
at java.lang.Thread.run(Thread.java:534)"StandardManager[/manager]" daemon prio=1 tid=0x4e266450 =
nid=0x7221
waiting on condition [4f217000..4f2178b8]
at java.lang.Thread.sleep(Native Method)
at org.apache.catalina.session.StandardManager.threadSleep(Unknown
Source)
at org.apache.catalina.session.StandardManager.run(Unknown Source)
at java.lang.Thread.run(Thread.java:534)"StandardManager[/prodmgr]" daemon prio=1 tid=0x4e200748 =
nid=0x7220
waiting on condition [4e3ff000..4e3ff8b8]
at java.lang.Thread.sleep(Native Method)
at org.apache.catalina.session.StandardManager.threadSleep(Unknown
Source)
at org.apache.catalina.session.StandardManager.run(Unknown Source)
at java.lang.Thread.run(Thread.java:534)"WebappLoader[/prodmgr]" daemon prio=1 tid=0x4e276518 nid=0x721f =
waiting
on condition [4f117000..4f1178b8]
at java.lang.Thread.sleep(Native Method)
at org.apache.catalina.loader.WebappLoader.threadSleep(Unknown Source)
at org.apache.catalina.loader.WebappLoader.run(Unknown Source)
at java.lang.Thread.run(Thread.java:534)"Signal Dispatcher" daemon prio=1 tid=0x080bc0d8 nid=0x7218 = waiting on condition [0..0]
"Finalizer" daemon prio=1 tid=0x080b7710 nid=0x7216 in =
Object.wait()
[4107c000..4107c8b8]
at java.lang.Object.wait(Native Method)
- waiting on <0x461e83e8> (a java.lang.ref.ReferenceQueue$Lock)
at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:111)
- locked <0x461e83e8> (a java.lang.ref.ReferenceQueue$Lock)
at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:127)
at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:159)"Reference Handler" daemon prio=1 tid=0x080b7358 nid=0x7215 in
Object.wait() [40ffb000..40ffb8b8]
at java.lang.Object.wait(Native Method)
- waiting on <0x461e8450> (a java.lang.ref.Reference$Lock)
at java.lang.Object.wait(Object.java:429)
at java.lang.ref.Reference$ReferenceHandler.run(Reference.java:115)
- locked <0x461e8450> (a java.lang.ref.Reference$Lock)"main" prio=1 tid=0x08052500 nid=0x7210 runnable =
[bfffc000..bfffcf78]
at java.net.PlainSocketImpl.socketAccept(Native Method)
at java.net.PlainSocketImpl.accept(PlainSocketImpl.java:353)
- locked <0x46419e40> (a java.net.PlainSocketImpl)
at java.net.ServerSocket.implAccept(ServerSocket.java:448)
at java.net.ServerSocket.accept(ServerSocket.java:419)
at org.apache.catalina.core.StandardServer.await(Unknown Source)
at org.apache.catalina.startup.Catalina.start(Unknown Source)
at org.apache.catalina.startup.Catalina.execute(Unknown Source)
at org.apache.catalina.startup.Catalina.process(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java=
:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI=
mpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.catalina.startup.Bootstrap.main(Unknown Source)"VM Thread" prio=1 tid=0x080b48e0 nid=0x7214 runnable=20
"VM Periodic Task Thread" prio=1 tid=0x080c0420 nid=0x721c waiting = on condition=20 "Suspend Checker Thread" prio=1 tid=0x080bb780 nid=0x7217 runnable =
===
And another one:
==== Full thread dump Java HotSpot(TM) Server VM (1.4.2-b28 mixed mode):
"MonitorRunnable" daemon prio=1 tid=0x0809afc0 nid=0x668c in
Object.wait() [4f418000..4f4188b8]
at java.lang.Object.wait(Native Method)
- waiting on <0x46417918> (a
org.apache.tomcat.util.threads.ThreadPool$MonitorRunnable)
at
org.apache.tomcat.util.threads.ThreadPool$MonitorRunnable.run(ThreadPool.=
java:503)
- locked <0x46417918> (a
org.apache.tomcat.util.threads.ThreadPool$MonitorRunnable)
at java.lang.Thread.run(Thread.java:534)"Thread-10" daemon prio=1 tid=0x08348538 nid=0x668b runnable
[4f397000..4f3978b8]
at java.net.PlainSocketImpl.socketAccept(Native Method)
at java.net.PlainSocketImpl.accept(PlainSocketImpl.java:353)
- locked <0x46417998> (a java.net.PlainSocketImpl)
at java.net.ServerSocket.implAccept(ServerSocket.java:448)
at java.net.ServerSocket.accept(ServerSocket.java:419)
at org.apache.jk.common.ChannelSocket.accept(ChannelSocket.java:268)
at
org.apache.jk.common.ChannelSocket.acceptConnections(ChannelSocket.java:5=
31)
at org.apache.jk.common.SocketAcceptor.runIt(ChannelSocket.java:660)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.=
java:619)
at java.lang.Thread.run(Thread.java:534)"Thread-9" daemon prio=1 tid=0x083479f0 nid=0x668a in =
Object.wait()
[4f316000..4f3168b8]
at java.lang.Object.wait(Native Method)
- waiting on <0x46417b90> (a
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable)
at java.lang.Object.wait(Object.java:429)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.=
java:595)
- locked <0x46417b90> (a
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable)
at java.lang.Thread.run(Thread.java:534)"Thread-8" daemon prio=1 tid=0x08347008 nid=0x6689 in =
Object.wait()
[4f295000..4f2958b8]
at java.lang.Object.wait(Native Method)
- waiting on <0x46417c08> (a
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable)
at java.lang.Object.wait(Object.java:429)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.=
java:595)
- locked <0x46417c08> (a
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable)
at java.lang.Thread.run(Thread.java:534)"Thread-7" daemon prio=1 tid=0x08348958 nid=0x6688 in =
Object.wait()
[4f214000..4f2148b8]
at java.lang.Object.wait(Native Method)
- waiting on <0x46417c80> (a
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable)
at java.lang.Object.wait(Object.java:429)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.=
java:595)
- locked <0x46417c80> (a
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable)
at java.lang.Thread.run(Thread.java:534)"MonitorRunnable" daemon prio=1 tid=0x08349060 nid=0x6687 in
Object.wait() [4f193000..4f1938b8]
at java.lang.Object.wait(Native Method)
- waiting on <0x465740> (a
org.apache.tomcat.util.threads.ThreadPool$MonitorRunnable)
at
org.apache.tomcat.util.threads.ThreadPool$MonitorRunnable.run(ThreadPool.=
java:503)
- locked <0x465740> (a
org.apache.tomcat.util.threads.ThreadPool$MonitorRunnable)
at java.lang.Thread.run(Thread.java:534)"Thread-5" daemon prio=1 tid=0x08345cd8 nid=0x6686 runnable
[4f112000..4f1128b8]
at java.net.PlainSocketImpl.socketAccept(Native Method)
at java.net.PlainSocketImpl.accept(PlainSocketImpl.java:353)
- locked <0x462d5798> (a java.net.PlainSocketImpl)
at java.net.ServerSocket.implAccept(ServerSocket.java:448)
at java.net.ServerSocket.accept(ServerSocket.java:419)
at
org.apache.tomcat.util.net.DefaultServerSocketFactory.acceptSocket(Defaul=
tServerSocketFactory.java:107)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.acceptSocket(PoolTcpEndpoint.j=
ava:356)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:529=
)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.=
java:619)
at java.lang.Thread.run(Thread.java:534)"Thread-4" daemon prio=1 tid=0x085158b8 nid=0x6685 in =
Object.wait()
[4f090000..4f0918b8]
at java.lang.Object.wait(Native Method)
- waiting on <0x4656cad8> (a
org.apache.commons.pool.impl.GenericObjectPool)
at java.lang.Object.wait(Object.java:429)
at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObject=
Pool.java:793)
- locked <0x4656cad8> (a
org.apache.commons.pool.impl.GenericObjectPool)
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource=
.java:140)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.jav=
a:518)
at com.bfth.util.DBBean.getSiteCategories(Unknown Source)
at com.bfth.export.CSVGenerator.generate(Unknown Source)
at com.bfth.export.DataFileGeneratorServlet.doGet(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
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.in=
vokeNext(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.in=
vokeNext(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.in=
vokeNext(Unknown Source)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(Unknown
Source)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.in=
vokeNext(Unknown Source)
at org.apache.catalina.valves.ErrorReportValve.invoke(Unknown Source)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.in=
vokeNext(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.in=
vokeNext(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.coyote.http11.Http11Processor.process(Http11Processor.java:601=
)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processCo=
nnection(Http11Protocol.java:392)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565=
)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.=
java:619)
at java.lang.Thread.run(Thread.java:534)"Thread-3" daemon prio=1 tid=0x081c63e0 nid=0x6684 in =
Object.wait()
[4f00f000..4f0108b8]
at java.lang.Object.wait(Native Method)
- waiting on <0x4656cad8> (a
org.apache.commons.pool.impl.GenericObjectPool)
at java.lang.Object.wait(Object.java:429)
at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObject=
Pool.java:793)
- locked <0x4656cad8> (a
org.apache.commons.pool.impl.GenericObjectPool)
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource=
.java:140)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.jav=
a:518)
at com.bfth.util.DBBean.getTotalProductCount(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java=
:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI=
mpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.apache.taglibs.standard.lang.jstl.ArraySuffix.evaluate(ArraySuffix.ja=
va:317)
at
org.apache.taglibs.standard.lang.jstl.ComplexValue.evaluate(ComplexValue.=
java:146)
at
org.apache.taglibs.standard.lang.jstl.ELEvaluator.evaluate(ELEvaluator.ja=
va:242)
at
org.apache.taglibs.standard.lang.jstl.ELEvaluator.evaluate(ELEvaluator.ja=
va:201)
at
org.apache.taglibs.standard.lang.jstl.Evaluator.evaluate(Evaluator.java:1=
38)
at
org.apache.taglibs.standard.lang.jstl.Evaluator.evaluate(Evaluator.java:1=
66)
at
org.apache.taglibs.standard.lang.support.ExpressionEvaluatorManager.evalu=
ate(ExpressionEvaluatorManager.java:112)
at
org.apache.taglibs.standard.tag.el.core.ExpressionUtil.evalNotNull(Expres=
sionUtil.java:85)
at
org.apache.taglibs.standard.tag.el.core.OutTag.evaluateExpressions(OutTag=
.java:137)
at
org.apache.taglibs.standard.tag.el.core.OutTag.doStartTag(OutTag.java:95)= at
org.apache.jsp.products_jsp._jspx_meth_c_out_0(products_jsp.java:336)
at org.apache.jsp.products_jsp._jspService(products_jsp.java:147)
at org.apache.jasper.runtime.HttpJspBase.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServletWrapper.service(Unknown Source)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(Unknown Source)
at org.apache.jasper.servlet.JspServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
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.in=
vokeNext(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.in=
vokeNext(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.in=
vokeNext(Unknown Source)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(Unknown
Source)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.in=
vokeNext(Unknown Source)
at org.apache.catalina.valves.ErrorReportValve.invoke(Unknown Source)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.in=
vokeNext(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.in=
vokeNext(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.coyote.http11.Http11Processor.process(Http11Processor.java:601=
)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processCo=
nnection(Http11Protocol.java:392)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565=
)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.=
java:619)
at java.lang.Thread.run(Thread.java:534)"Thread-2" daemon prio=1 tid=0x081c5df8 nid=0x6683 in =
Object.wait()
[4ef8f000..4ef8f8b8]
at java.lang.Object.wait(Native Method)
- waiting on <0x465958> (a
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable)
at java.lang.Object.wait(Object.java:429)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.=
java:595)
- locked <0x465958> (a
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable)
at java.lang.Thread.run(Thread.java:534)"HostConfig[localhost]" daemon prio=1 tid=0x08343658 nid=0x6682 =
waiting
on condition [4ef0e000..4ef0e8b8]
at java.lang.Thread.sleep(Native Method)
at org.apache.catalina.startup.HostConfig.threadSleep(Unknown Source)
at org.apache.catalina.startup.HostConfig.run(Unknown Source)
at java.lang.Thread.run(Thread.java:534)"StandardManager[/manager]" daemon prio=1 tid=0x083433e0 =
nid=0x6681
waiting on condition [4ee8d000..4ee8d8b8]
at java.lang.Thread.sleep(Native Method)
at org.apache.catalina.session.StandardManager.threadSleep(Unknown
Source)
at org.apache.catalina.session.StandardManager.run(Unknown Source)
at java.lang.Thread.run(Thread.java:534)"StandardManager[/prodmgr]" daemon prio=1 tid=0x08091f98 =
nid=0x6680
waiting on condition [4ee0c000..4ee0c8b8]
at java.lang.Thread.sleep(Native Method)
at org.apache.catalina.session.StandardManager.threadSleep(Unknown
Source)
at org.apache.catalina.session.StandardManager.run(Unknown Source)
at java.lang.Thread.run(Thread.java:534)"WebappLoader[/prodmgr]" daemon prio=1 tid=0x4e70ddd0 nid=0x667f =
waiting
on condition [4ed0c000..4ed0c8b8]
at java.lang.Thread.sleep(Native Method)
at org.apache.catalina.loader.WebappLoader.threadSleep(Unknown Source)
at org.apache.catalina.loader.WebappLoader.run(Unknown Source)
at java.lang.Thread.run(Thread.java:534)"Signal Dispatcher" daemon prio=1 tid=0x080bc0d0 nid=0x664f = waiting on condition [0..0]
"Finalizer" daemon prio=1 tid=0x080b7710 nid=0x664d in =
Object.wait()
[4107c000..4107c8b8]
at java.lang.Object.wait(Native Method)
- waiting on <0x461e83e8> (a java.lang.ref.ReferenceQueue$Lock)
at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:111)
- locked <0x461e83e8> (a java.lang.ref.ReferenceQueue$Lock)
at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:127)
at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:159)"Reference Handler" daemon prio=1 tid=0x080b7358 nid=0x664c in
Object.wait() [40ffb000..40ffb8b8]
at java.lang.Object.wait(Native Method)
- waiting on <0x461e8450> (a java.lang.ref.Reference$Lock)
at java.lang.Object.wait(Object.java:429)
at java.lang.ref.Reference$ReferenceHandler.run(Reference.java:115)
- locked <0x461e8450> (a java.lang.ref.Reference$Lock)"main" prio=1 tid=0x08052500 nid=0x6641 runnable =
[bfffd000..bfffd8d8]
at java.net.PlainSocketImpl.socketAccept(Native Method)
at java.net.PlainSocketImpl.accept(PlainSocketImpl.java:353)
- locked <0x46417cb0> (a java.net.PlainSocketImpl)
at java.net.ServerSocket.implAccept(ServerSocket.java:448)
at java.net.ServerSocket.accept(ServerSocket.java:419)
at org.apache.catalina.core.StandardServer.await(Unknown Source)
at org.apache.catalina.startup.Catalina.start(Unknown Source)
at org.apache.catalina.startup.Catalina.execute(Unknown Source)
at org.apache.catalina.startup.Catalina.process(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java=
:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI=
mpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.catalina.startup.Bootstrap.main(Unknown Source)"VM Thread" prio=1 tid=0x080b48e0 nid=0x664b runnable=20
"VM Periodic Task Thread" prio=1 tid=0x080c0418 nid=0x6653 waiting = on condition=20 "Suspend Checker Thread" prio=1 tid=0x080bb778 nid=0x664e runnable =
===
Any advice would be appreciated!
Frank ==>
-- John Zoetebier Web site: http://www.transparent.co.nz
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
