這是我換了數(shù)據(jù)庫(kù)以后報(bào)的錯(cuò)誤:

INFO 23:09:16,296 ConnectionProviderFactory:72 - Initializing connection provider: org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider

WARN 23:09:36,375 ThreadPoolAsynchronousRunner:608 - com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@13cb6cf -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!

WARN 23:09:36,390 ThreadPoolAsynchronousRunner:624 - com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@13cb6cf -- APPARENT DEADLOCK!!! Complete Status: 

Managed Threads: 3

Active Threads: 3

Active Tasks: 

com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1b65d47 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1)

com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1a61582 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2)

com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@ce4625 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0)

Pending Tasks: 

com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@5f5deb

com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@10ef5a5

Pool thread stack traces:

Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1,5,main]

java.net.PlainSocketImpl.socketConnect(Native Method)

java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)

java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)

java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)

java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)

java.net.Socket.connect(Socket.java:519)

java.net.Socket.connect(Socket.java:469)

java.net.Socket.<init>(Socket.java:366)

java.net.Socket.<init>(Socket.java:180)

oracle.net.nt.TcpNTAdapter.connect(Unknown Source)

oracle.net.nt.ConnOption.connect(Unknown Source)

oracle.net.nt.ConnStrategy.execute(Unknown Source)

oracle.net.resolver.AddrResolution.resolveAndExecute(Unknown Source)

oracle.net.ns.NSProtocol.establishConnection(Unknown Source)

oracle.net.ns.NSProtocol.connect(Unknown Source)

oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:844)

oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:268)

oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:414)

oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)

oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)

oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)

com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)

com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)

com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)

com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)

com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)

com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)

com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)

com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)

Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2,5,main]

java.net.PlainSocketImpl.socketConnect(Native Method)

java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)

java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)

java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)

java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)

java.net.Socket.connect(Socket.java:519)

java.net.Socket.connect(Socket.java:469)

java.net.Socket.<init>(Socket.java:366)

java.net.Socket.<init>(Socket.java:180)

oracle.net.nt.TcpNTAdapter.connect(Unknown Source)

oracle.net.nt.ConnOption.connect(Unknown Source)

oracle.net.nt.ConnStrategy.execute(Unknown Source)

oracle.net.resolver.AddrResolution.resolveAndExecute(Unknown Source)

oracle.net.ns.NSProtocol.establishConnection(Unknown Source)

oracle.net.ns.NSProtocol.connect(Unknown Source)

oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:844)

oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:268)

oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:414)

oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)

oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)

oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)

com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)

com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)

com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)

com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)

com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)

com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)

com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)

com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)

Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0,5,main]

java.net.PlainSocketImpl.socketConnect(Native Method)

java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)

java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)

java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)

java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)

java.net.Socket.connect(Socket.java:519)

java.net.Socket.connect(Socket.java:469)

java.net.Socket.<init>(Socket.java:366)

java.net.Socket.<init>(Socket.java:180)

oracle.net.nt.TcpNTAdapter.connect(Unknown Source)

oracle.net.nt.ConnOption.connect(Unknown Source)

oracle.net.nt.ConnStrategy.execute(Unknown Source)

oracle.net.resolver.AddrResolution.resolveAndExecute(Unknown Source)

oracle.net.ns.NSProtocol.establishConnection(Unknown Source)

oracle.net.ns.NSProtocol.connect(Unknown Source)

oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:844)

oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:268)

oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:414)

oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)

oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)

oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)

com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)

com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)

com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)

com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)

com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)

com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)

com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)

com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)

原因:網(wǎng)上多是說c3p0 bug引起的

我的數(shù)據(jù)庫(kù)oracle 10.2.0.1,oracle14.jar也是10.2.0.1版本，我做了兩個(gè)修改這個(gè)錯(cuò)誤就沒有了，具體原因還不明，先解決了再說。

一.修改數(shù)據(jù)庫(kù)方言為oracle.jdbc.driver.OracleDriver(原來為oracle.jdbc.OracleDriver 在linux上也可以使用的)

二.修改數(shù)據(jù)庫(kù)的最大連接數(shù)，見:http://www.tkk7.com/zhip/archive/2008/05/16/200769.html