Hello,
I have the same issue with c3p0 0.9.1.2. Even if i put the mysql-connector
inside the webapp (instead of CATALINA_HOME/lib), the issue appears.
I also tried to put both c3p0 and mysql-connector in CATALINA_HOME/lib but
the same problem occurs. There is no issue when using tomcat 6.0.33.
I notice that using JNDI is a best practice, but it's a little bit of work
to do it now (lots of projects). Do you have any idea, why it doesn't work
anylonger ?
--- stackTrace ---
8 févr. 2012 15:58:37
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector run
ATTENTION:
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@c77d0d6
-- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending
tasks!
8 févr. 2012 15:58:37
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector run
ATTENTION:
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@c77d0d6
-- APPARENT DEADLOCK!!! Complete Status:
Managed Threads: 3
Active Threads: 3
Active Tasks:
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@7423c7f5
(com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0)
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@591ce164
(com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2)
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@771199f0
(com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1)
Pending Tasks:
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@249198a2
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@52bbc66f
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@25e0cbd8
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@4966e555
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@25a5519
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@7888dd83
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@61870147
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@66650e56
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@7490649e
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@33bdfcdb
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@7e23a866
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@5705013c
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@99436c6
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@61980613
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@43b6fb73
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@22365dc0
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1f44f9cc
Pool thread stack traces:
Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0,5,main]
java.lang.Thread.sleep(Native Method)
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1805)
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2,5,main]
java.lang.Thread.sleep(Native Method)
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1805)
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1,5,main]
java.lang.Thread.sleep(Native Method)
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1805)
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
8 févr. 2012 15:58:46
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask run
ATTENTION:
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@7423c7f5 --
Acquisition Attempt Failed!!! Clearing pending acquires. While trying to
acquire a needed new resource, we failed to succeed more than the maximum
number of allowed acquisition attempts (30). Last acquisition attempt
exception:
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getDriver(DriverManager.java:264)
at
com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:223)
at
com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
at
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
at
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
at
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
at
com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
at
com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
at
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
at
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
--
View this message in context:
http://tomcat.10.n6.nabble.com/java-sql-SQLException-No-suitable-driver-found-for-in-tomcat-6-0-35-is-the-class-loading-changed-tp2111551p4376238.html
Sent from the Tomcat - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
