用java连接的oracle库,执行一段时间:大约两个半小时后,就报这个错误。猜想是连接时间过长,数据库连接断开。请问,如果处理这样的情况。具体是怎么回事?
谢谢!java.sql.SQLException: Listener refused the connection with the following error:ORA-12519, TNS:no appropriate service handler found
The Connection descriptor used by the client was:
192.168.1.7:1521:orcl at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:111)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:260)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:386)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:
440)
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 java.sql.DriverManager.getConnection(DriverManager.java:579)
at java.sql.DriverManager.getConnection(DriverManager.java:221)
at com.base.OracleDb.Link(OracleDb.java:27)
at com.opration.CalculateEx.Cal(CalculateEx.java:95)
at com.opration.RunCal.RunCalDot(RunCal.java:48)
at RunEx.main(RunEx.java:25)
谢谢!java.sql.SQLException: Listener refused the connection with the following error:ORA-12519, TNS:no appropriate service handler found
The Connection descriptor used by the client was:
192.168.1.7:1521:orcl at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:111)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:260)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:386)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:
440)
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 java.sql.DriverManager.getConnection(DriverManager.java:579)
at java.sql.DriverManager.getConnection(DriverManager.java:221)
at com.base.OracleDb.Link(OracleDb.java:27)
at com.opration.CalculateEx.Cal(CalculateEx.java:95)
at com.opration.RunCal.RunCalDot(RunCal.java:48)
at RunEx.main(RunEx.java:25)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货