ssh2 + c3p0 appear THE NETwork adapter could not establish the connection

java.sql.SQLException: Io exception: 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. (PhysicalConnection.java:
413)
at oracle.jdbc.driver.T4CConnection. (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)


deployed on a single server, two projects, each project with the c3p0 connection pool, and call a stored procedure using the connection profile New Connection. Sometimes appear c3p0 can be used, but you can not call a stored procedure. Error message is java.sql.SQLException: Io exception: The Network Adapter could not establish the connection. Today, the above error occurs, the connection pool is not used. No re, and now can be used.

------ Solution ------------------------------------ --------
your url using localhost or 127.0.0.1
------ Solution ------------------ --------------------------
link does not seem to be on the
------ Solution ------ --------------------------------------
you look can not ping, then connect to the database using a client if there are problems, there is no question that the project configuration
------ For reference only ---------------- -----------------------


I use the LAN address, 192.168.0.253, server address is 252, the database address is 253, I configured the data source which is 253, tnsnames.ora is configured in 253. ; first of all, should not the network configuration issues now. It is not a problem when it starts, but appears after running for some time. I originally thought that the connection pool is available, common stored procedure with parameters new way to build a connection problem occurs because no available connections, but an investigation found that a total of just over seventy database session, did not exceed a total of 150 , strange.
------ For reference only -------------------------------- -------
claims are a lot of online tnsnames.ora configuration and data source-url-ip, host name setting is wrong. This issue should not even start are started up, and my problem is that the project can start, the beginning of everything is normal; running for some time after the emergence of this problem; connection pool can be used, but not by creating a new connection to a stored procedure build parameters. This is used before hibernate when, yesterday I replaced the connection pool c3p0; results of the morning to the company after the issue.
------ For reference only ---------------------------------- -----

  The reply deleted by an administrator at 2013-07-19 14:38:24
------ For reference only ---------------------------------- -----
ping possible to ping, this error every time I go to the server point of view, on the merits. Do not know whether the server network instability.