spring+JPA(hibernate)+c3p0+oracle抛出异常A ResourcePool could not acquire a resource from its prim

2013-10-03 20:50:22,300 ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate:(SchemaUpdate.java:175) - could not get database metadatajava.sql.SQLException: Connections could not be acquired from the underlying database![Cause: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source. at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1319) at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557) at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525) at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128) at org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSourceConnectionProvider.java:46) at org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepare(SuppliedConnectionProviderConnectionHelper.java:51)。。。。。
<tx:annotation-driven transaction-manager="txManager"/>

添加了classes12.jar和c3p0-0.9.1.jar、ojdbc14.jar
driverClass=oracle.jdbc.driver.OracleDriverjdbcUrl=jdbc:oracle:thin:@127.0.0.1:1521:orcluser=rootpassword=123
求高手解答。看了网上很多帖子,没有解决。所以把我的情况粘贴进来。求高手大神们,帮帮我啊。如有不详细的地方,可以留言。不胜感激!真诚致谢!
启动时虽然报错,但是数据库中创建了对应的表。用junit测试成功。

第1个回答  2013-10-05
我猜哦!密码过期不可能,是不是最大连接数超过oracle的限制了啊?你尝试把连接池的maxpoolsize改小点,如果5左右试试!300有点大啊本回答被提问者采纳
相似回答