2024年5月31日发(作者：)

在

在Spring+hebernate中 Cannot get a connection, pool error

Timeout waiting for idle object异常的解决办法

最近写了个留言板，tomcat+Spring+hibernate+MyEclipse

使用jdbc连接数据库所有功能都没问题，发布到tomcat中也没

问题，可是如果使用tomcat的数据源，来连接数据库，开始很正常，

但是刷新几次就会出现这个异常……2008-04-26 22:35:40,812

WARN [ceptionReporter] - SQL Error: 0,

SQLState: null

2008-04-26 22:35:40,812 ERROR

[ceptionReporter] - Cannot get a

connection, pool error Timeout waiting for idle object

2008-04-26

SQLState: null

2008-04-26 22:35:40,812 ERROR

[ceptionReporter] - Cannot get a

connection, pool error Timeout waiting for idle object

2008-04-26 22:35:40,812 ERROR [eDAO] -

find all failed

gorizedSQLException:

Hibernate operation: Cannot open connection; uncategorized

SQLException for SQL []; SQL state [null]; error code [0];

Cannot get a connection, pool error Timeout waiting for idle

object; nested exception is

tedException: Cannot get

a connection, pool error Timeout waiting for idle object

Caused by:

tedException: Cannot

22:35:40,812 WARN

[ceptionReporter] - SQL Error: 0,

get a connection, pool error Timeout waiting for idle object

at

nectio

n(PoolingDataSource.ｊａｖａ:104)

at

nection(B

asicDataSource.ｊａｖａ:880)

at

ataSourceConnectio

nection (LocalDataSourceConnectionProvider.

ｊａｖａ:81)

at

nnection(Conne

ctionManager.ｊａｖａ:417)

at

nection(Connecti

onManager.ｊａｖａ:144)

at

eQueryStatement(Abs

tractBatcher.ｊａｖａ:105)

at

eQueryStatement(Loader.ｊａ

ｖａ:1561)

at y(Loader.ｊａｖａ:661)

at

yAndInitializeNonLazyCollec

tions(Loader.ｊａｖａ:224)

at (Loader.ｊａｖａ:2145)

at noreQueryCache(Loader.

ｊａｖａ:2029)