oracle中的java无法_Java无法连接oracle
有個(gè)服務(wù)器上,perl/sqlplus 連接都沒(méi)有問(wèn)題,就是jdbc連接有問(wèn)題,每次都是連三四次后,就會(huì)卡住,然后報(bào)錯(cuò),connection reset。 同網(wǎng)段的其他服務(wù)器都沒(méi)有問(wèn)題。
寫(xiě)了一個(gè)非常簡(jiǎn)單的測(cè)試代碼。
import java.sql.*;
public class V{
public static void main(String args[]) throws Exception{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection(args[0],args[1],args[2]);
System.out.println("connect over");
con.close();
System.out.println("close over");
}
}
結(jié)果就是多次連接后,再連接就卡住,一兩分鐘后報(bào)錯(cuò)。正常我們肯定有幾十上百個(gè)連接。
Exception in thread “main” java.sql.SQLRecoverableException: IO Error:
Connection reset
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:428)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:536)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:228)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
at java.sql.DriverManager.getConnection(DriverManager.java:571)
at java.sql.DriverManager.getConnection(DriverManager.java:215)
at V.main(V.java:9) Caused by: java.net.SocketException: Connection reset
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:118)
at java.net.SocketOutputStream.write(SocketOutputStream.java:159)
at oracle.net.ns.DataPacket.send(DataPacket.java:199)
at oracle.net.ns.NetOutputStream.flush(NetOutputStream.java:211)
at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:227)
at oracle.net.ns.NetInputStream.read(NetInputStream.java:175)
at oracle.net.ns.NetInputStream.read(NetInputStream.java:100)
at oracle.net.ns.NetInputStream.read(NetInputStream.java:85)
at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:123)
at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:79)
at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1122)
at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1099)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:288)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:366)
at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:752)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:366)
... 7 more
后來(lái)實(shí)在沒(méi)轍重裝系統(tǒng)了,還是有問(wèn)題。
請(qǐng)問(wèn)有人遇到過(guò)這個(gè)問(wèn)題嗎。。。
http://zhidao.baidu.com/question/2859557… 希望這個(gè)鏈接對(duì)你有幫助
總結(jié)
以上是生活随笔為你收集整理的oracle中的java无法_Java无法连接oracle的全部?jī)?nèi)容,希望文章能夠幫你解決所遇到的問(wèn)題。
- 上一篇: 把java当爱好_(观点)如果把爱好做成
- 下一篇: python多列填充缺点_在Python