日期:2014-05-18  浏览次数:20824 次

ssh2+c3p0 出现 THE NETwork adapter could not establish the connection
java.sql.SQLException: Io 异常: The Network Adapter could not establish the conn
ection
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:111)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:145)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:254)
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:386)
        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:
413)
        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:164)
        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtensio
n.java:34)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:752)
        at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManag
erDataSource.java:68)
        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:87)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireResource(C
3P0PooledConnectionPool.java:83)
        at com.mchange.v2.resourcepool.BasicResourcePool.assimilateResource(Basi
cResourcePool.java:884)
        at com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(BasicResou
rcePool.java:601)
        at com.mchange.v2.resourcepool.BasicResourcePool.access$400(BasicResourc
ePool.java:31)
        at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicRe
sourcePool.java:1079)
        at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(Thre
adPoolAsynchronousRunner.java:354)


一台服务器上部署了两个项目,每个项目都用的c3p0连接池,而调用存储过程则使用的connection配置文件新建连接。    有时候出现c3p0可以使用,但是存储过程不能调用。 报错信息也是 java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection。   今天出现上面这个错误,是连接池不能用。  没有重新,现在又可以用了。