Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 3.0.3

Mapping documents:

Code between sessionFactory.openSession() and session.close():
A bunch of regular java.sql.Statement.executeQuery() statements

Full stack trace of any exception that occurs:
22:46:03,781 WARN JDBCContext: afterTransactionCompletion() was never called
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@133eac6 -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@17a7b1d -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@8dd541 -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@d702e0 -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@194e825 -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@28e512 -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@114d6f9 -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@11d5c2a -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@12d8873 -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@1fdccdd -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@597532 -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@d702e0 -- APPARENT DEADLOCK!!! Complete Status: [num_managed_threads: 3, num_active: 3; activeTasks: com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@14c87ea (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2), com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@a201ed (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0), com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@b304ce (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1); pendingTasks: com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@5c9369, com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@1d202e5]
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@133eac6 -- APPARENT DEADLOCK!!! Complete Status: [num_managed_threads: 3, num_active: 3; activeTasks: com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@2566ab (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1), com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@1776ddb (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0), com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@1cd70b3 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2); pendingTasks: com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@47de70, com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@df5657]
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@17a7b1d -- APPARENT DEADLOCK!!! Complete Status: [num_managed_threads: 3, num_active: 3; activeTasks: com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@1aba2ca (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0), com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@a0fad2 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2), com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@10079f9 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1); pendingTasks: com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@bc1080, com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@1c1bf5a]
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@8dd541 -- APPARENT DEADLOCK!!! Complete Status: [num_managed_threads: 3, num_active: 3; activeTasks: com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@16f165d (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2), com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@2c7930 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1), com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@1c84ab6 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0); pendingTasks: com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@47de70, com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@9d85e6, com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@f9e1e7, com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@15e0e6c, com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@4ff36, com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@f551d, com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@9cf569, com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@b3f72d, com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@128e008, com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@8c466e, com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@1641a82]
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@28e512 -- APPARENT DEADLOCK!!! Complete Status: [num_managed_threads: 3, num_active: 3; activeTasks: com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@170602f (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0), com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@2a6e2d (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1), com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@2c91db (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2); pendingTasks: com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@add248]
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@194e825 -- APPARENT DEADLOCK!!! Complete Status: [num_managed_threads: 3, num_active: 3; activeTasks: com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@1be9fc (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0), com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@9eaed5 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2), com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@1e84004 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1); pendingTasks: com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@18f1cd4, com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@1cf5e8d]
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@11d5c2a -- APPARENT DEADLOCK!!! Complete Status: [num_managed_threads: 3, num_active: 3; activeTasks: com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@c2caaa (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2), com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@876fb3 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0), com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@1b67c20 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1); pendingTasks: com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@1eb7645, com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@304b0b]
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@114d6f9 -- APPARENT DEADLOCK!!! Complete Status: [num_managed_threads: 3, num_active: 3; activeTasks: com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@bab69a (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0), com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@1a76a30 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1), com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@1c8a587 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2); pendingTasks: com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@148b039, com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@1fd2f70]
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@597532 -- APPARENT DEADLOCK!!! Complete Status: [num_managed_threads: 3, num_active: 3; activeTasks: com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@8edbfe (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1), com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@10d3759 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0), com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@acd987 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2); pendingTasks: com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@319150, com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@3b1f63]
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@12d8873 -- APPARENT DEADLOCK!!! Complete Status: [num_managed_threads: 3, num_active: 3; activeTasks: com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@1a1d91b (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0), com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@b48de3 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2), com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@1c1eb13 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1); pendingTasks: com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@135737e, com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@189d51e]
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@1fdccdd -- APPARENT DEADLOCK!!! Complete Status: [num_managed_threads: 3, num_active: 3; activeTasks: com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@1299f0e (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0), com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@1895f17 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2), com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@15ac509 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1); pendingTasks: com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@150b21b, com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@dd47cf]
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@114d6f9 -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@597532 -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@34dade -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@16d2b49 -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@17a7b1d -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@d44ba -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@11d5c2a -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@597532 -- APPARENT DEADLOCK!!! Complete Status: [num_managed_threads: 3, num_active: 3; activeTasks: com.mchange.v2.resourcepool.BasicResourcePool$5@11b0f5c (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2), com.mchange.v2.resourcepool.BasicResourcePool$5@7eee1e (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1), com.mchange.v2.resourcepool.BasicResourcePool$5@142fd0e (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0); pendingTasks: com.mchange.v2.resourcepool.BasicResourcePool$5@44fad7, com.mchange.v2.resourcepool.BasicResourcePool$5@1fa3fa2, com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@10d92cb]
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@114d6f9 -- APPARENT DEADLOCK!!! Complete Status: [num_managed_threads: 3, num_active: 3; activeTasks: com.mchange.v2.resourcepool.BasicResourcePool$5@6c403f (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0), com.mchange.v2.resourcepool.BasicResourcePool$5@f3c8bc (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1), com.mchange.v2.resourcepool.BasicResourcePool$5@a24e12 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2); pendingTasks: com.mchange.v2.resourcepool.BasicResourcePool$5@6b0cd5, com.mchange.v2.resourcepool.BasicResourcePool$5@207a13, com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@5eb21]
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@34dade -- APPARENT DEADLOCK!!! Complete Status: [num_managed_threads: 3, num_active: 3; activeTasks: com.mchange.v2.resourcepool.BasicResourcePool$5@18d95e6 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0), com.mchange.v2.resourcepool.BasicResourcePool$5@1ae2610 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2), com.mchange.v2.resourcepool.BasicResourcePool$5@b05516 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1); pendingTasks: com.mchange.v2.resourcepool.BasicResourcePool$5@67cba6, com.mchange.v2.resourcepool.BasicResourcePool$5@6ce480, com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@8fe149]
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@16d2b49 -- APPARENT DEADLOCK!!! Complete Status: [num_managed_threads: 3, num_active: 3; activeTasks: com.mchange.v2.resourcepool.BasicResourcePool$5@ee146c (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1), com.mchange.v2.resourcepool.BasicResourcePool$5@ffbc76 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2), com.mchange.v2.resourcepool.BasicResourcePool$5@1b3b047 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0); pendingTasks: com.mchange.v2.resourcepool.BasicResourcePool$5@177e6c, com.mchange.v2.resourcepool.BasicResourcePool$5@2e943b, com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@fae12]
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@17a7b1d -- APPARENT DEADLOCK!!! Complete Status: [num_managed_threads: 3, num_active: 3; activeTasks: com.mchange.v2.resourcepool.BasicResourcePool$5@16d2e22 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1), com.mchange.v2.resourcepool.BasicResourcePool$5@efdfd7 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0), com.mchange.v2.resourcepool.BasicResourcePool$5@50ac1f (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2); pendingTasks: com.mchange.v2.resourcepool.BasicResourcePool$5@5432ab, com.mchange.v2.resourcepool.BasicResourcePool$5@f8ff78, com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@516cc3]
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@11d5c2a -- APPARENT DEADLOCK!!! Complete Status: [num_managed_threads: 3, num_active: 3; activeTasks: com.mchange.v2.resourcepool.BasicResourcePool$5@1ca7dd9 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0), com.mchange.v2.resourcepool.BasicResourcePool$5@10c40d6 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1), com.mchange.v2.resourcepool.BasicResourcePool$5@174cf46 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2); pendingTasks: com.mchange.v2.resourcepool.BasicResourcePool$5@135b5cb, com.mchange.v2.resourcepool.BasicResourcePool$5@1322c47, com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@14c5626]
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@d44ba -- APPARENT DEADLOCK!!! Complete Status: [num_managed_threads: 3, num_active: 3; activeTasks: com.mchange.v2.resourcepool.BasicResourcePool$5@1d4170e (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2), com.mchange.v2.resourcepool.BasicResourcePool$5@abd974 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1), com.mchange.v2.resourcepool.BasicResourcePool$5@1bbabb6 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0); pendingTasks: com.mchange.v2.resourcepool.BasicResourcePool$5@65756, com.mchange.v2.resourcepool.BasicResourcePool$5@1a46c41, com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1bf4739]
com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.io.EOFException

STACKTRACE:

java.io.EOFException
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1845)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2292)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2788)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:753)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3562)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1154)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1702)
at com.mysql.jdbc.Connection.<init>(Connection.java:405)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:68)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:87)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireResource(C3P0PooledConnectionPool.java:83)
at com.mchange.v2.resourcepool.BasicResourcePool.assimilateResource(BasicResourcePool.java:884)
at com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(BasicResourcePool.java:601)
at com.mchange.v2.resourcepool.BasicResourcePool.access$400(BasicResourcePool.java:31)
at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1079)
at java.lang.Thread.run(Thread.java:595)


** END NESTED EXCEPTION **


at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2504)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2788)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:753)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3562)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1154)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1702)
at com.mysql.jdbc.Connection.<init>(Connection.java:405)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:68)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:87)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireResource(C3P0PooledConnectionPool.java:83)
at com.mchange.v2.resourcepool.BasicResourcePool.assimilateResource(BasicResourcePool.java:884)
at com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(BasicResourcePool.java:601)
at com.mchange.v2.resourcepool.BasicResourcePool.access$400(BasicResourcePool.java:31)
at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1079)
at java.lang.Thread.run(Thread.java:595)
com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:


Name and version of the database you are using:
MySql 4.1 with com.mysql.jdbc.Driver

The generated SQL (show_sql=true):


Debug level Hibernate log excerpt:



I'm fairly new to hibernate so I'll try to provide as much info as I can to be helpful.
I'm using the standard
I'm also using the c3p0 libraries. I was using 8.5.2 and saw the deadlocks. Then I upgraded to the newest 9.0 version, but I still get the deadlocks.

My app runs on very large datasets. It works fine when the datasets are relatively small. But when it gets larger, it runs into OutOfMemoryErrors like below:
00:43:38,151 WARN JDBCContext: afterTransactionCompletion() was never called
Exception in thread "main" java.lang.OutOfMemoryError: Java heap space
05:46:32,421 WARN ThreadPoolAsynchronousRunner: com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@14c1444 -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
05:46:32,421 WARN ThreadPoolAsynchronousRunner: com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@437a34 -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
05:46:38,327 WARN ThreadPoolAsynchronousRunner: com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@14c1444 -- APPARENT DEADLOCK!!! Complete Status: [num_managed_threads: 3, num_active: 3; activeTasks: com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@56c20e (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2), com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@8b6fb1 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0), com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@643b38 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1); pendingTasks: com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@afcf0d, com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@429f75, com.mchange.v2.resourcepool.BasicResourcePool$5@d86e99, com.mchange.v2.resourcepool.BasicResourcePool$5@1b6123a, com.mchange.v2.resourcepool.BasicResourcePool$5@158b36f, com.mchange.v2.resourcepool.BasicResourcePool$5@1db42ea, com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@100681b]
05:46:38,390 WARN ThreadPoolAsynchronousRunner: com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@437a34 -- APPARENT DEADLOCK!!! Complete Status: [num_managed_threads: 3, num_active: 3; activeTasks: com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@1de319d (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1), com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@51e44f (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0), com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@6c184e (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2); pendingTasks: com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@1f2df63, com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@27e3bc, com.mchange.v2.resourcepool.BasicResourcePool$5@1450a86, com.mchange.v2.resourcepool.BasicResourcePool$5@66a6eb, com.mchange.v2.resourcepool.BasicResourcePool$5@6c630e, com.mchange.v2.resourcepool.BasicResourcePool$5@6523a, com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1b2daab]


I've seen others post this Deadlock issue in regards to Oracle, but I'm not using Oracle. And supposedly, the bug was fixed for oracle in version 9.0 of c3p0, which I have upgraded to.

I'm also afraid that I have failed to close all my sessions. Could that be the problem? If so, can anyone recommend a tool that can help me detect and identify where I'm missing a session.close() statement? I've tried to use p6spy but it seems like it's a defunct project (all the open source tools built on top of it are gone (www.irongrid.com)), and it's P6Outage functionality doesn't seem to be working either.

Thanks in advance,
Kane