jdbc连接不上oracle，myeclipse却可以连上，不知道是哪的问题，高手进
java.sql.SQLException: Connections could not be acquired from the underlying database!
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:529)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
at sunyard.bpo.cps.accdb.DBAccess.open(DBAccess.java:40)
at sunyard.bpo.cps.util.DBOperUtil.gSkillInfo(DBOperUtil.java:214)
at sunyard.bpo.cps.para.G_Var.init_data(G_Var.java:26)
at sunyard.bpo.cps.start.ServiceStartUpEntry.runServer(ServiceStartUpEntry.java:100)
at sunyard.bpo.cps.start.ServiceStartUpEntry.main(ServiceStartUpEntry.java:56)
Caused by: 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)
... 6 more
10 10:51:49.671 ERROR: [TD_BUSS_REL] 查询版式代码与业务小类关联关系异常
java.sql.SQLException: An SQLException was provoked by the following failure: com.mchange.v2.resourcepool.ResourcePoolException: A ResourcePool cannot acquire a new resource -- the factory or source appears to be down.
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:65)
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:62)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:531)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
at sunyard.bpo.cps.accdb.DBAccess.open(DBAccess.java:40)
at sunyard.bpo.cps.util.DBOperUtil.formatCodeMap(DBOperUtil.java:161)
at sunyard.bpo.cps.para.G_Var.init_data(G_Var.java:27)
at sunyard.bpo.cps.start.ServiceStartUpEntry.runServer(ServiceStartUpEntry.java:100)
at sunyard.bpo.cps.start.ServiceStartUpEntry.main(ServiceStartUpEntry.java:56)
Caused by: com.mchange.v2.resourcepool.ResourcePoolException: A ResourcePool cannot acquire a new resource -- the factory or source appears to be down.
at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1279)
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)
... 6 more
10 10:52:09.656 ERROR: [TD_CHECK_RULE] 获取类型为 [1]的表达式异常
java.sql.SQLException: Connections could not be acquired from the underlying database!
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:529)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
at sunyard.bpo.cps.accdb.DBAccess.open(DBAccess.java:40)
at sunyard.bpo.cps.util.DBOperUtil.getExpressionList(DBOperUtil.java:514)
at sunyard.bpo.cps.para.G_Var.init_data(G_Var.java:28)
at sunyard.bpo.cps.start.ServiceStartUpEntry.runServer(ServiceStartUpEntry.java:100)
at sunyard.bpo.cps.start.ServiceStartUpEntry.main(ServiceStartUpEntry.java:56)
Caused by: 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)
... 6 more
10 10:52:09.656 ERROR: [TD_CHECK_RULE] 获取类型为 [0]的表达式异常
java.sql.SQLException: An SQLException was provoked by the following failure: com.mchange.v2.resourcepool.ResourcePoolException: A ResourcePool cannot acquire a new resource -- the factory or source appears to be down.
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:65)
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:62)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:531)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
at sunyard.bpo.cps.accdb.DBAccess.open(DBAccess.java:40)
at sunyard.bpo.cps.util.DBOperUtil.getExpressionList(DBOperUtil.java:514)
at sunyard.bpo.cps.para.G_Var.init_data(G_Var.java:29)
at sunyard.bpo.cps.start.ServiceStartUpEntry.runServer(ServiceStartUpEntry.java:100)
at sunyard.bpo.cps.start.ServiceStartUpEntry.main(ServiceStartUpEntry.java:56)
Caused by: com.mchange.v2.resourcepool.ResourcePoolException: A ResourcePool cannot acquire a new resource -- the factory or source appears to be down.
at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1279)
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)
... 6 more
10 10:52:38.656 ERROR: [TD_CHECK_RULE] 获取类型为(2,3)的表达式异常
java.sql.SQLException: Connections could not be acquired from the underlying database!
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:529)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
at sunyard.bpo.cps.accdb.DBAccess.open(DBAccess.java:40)
at sunyard.bpo.cps.util.DBOperUtil.getExpressionList(DBOperUtil.java:537)
at sunyard.bpo.cps.para.G_Var.init_data(G_Var.java:30)
at sunyard.bpo.cps.start.ServiceStartUpEntry.runServer(ServiceStartUpEntry.java:100)
at sunyard.bpo.cps.start.ServiceStartUpEntry.main(ServiceStartUpEntry.java:56)
Caused by: 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)
[解决办法]
我感觉是连接数过大了 就连接不上了
[解决办法]
Connections could not be acquired from the underlying database
连接无法获得的底层数据库
楼主可以试试用hibernate 或 spring连接数据库
