请问出现Io 异常: Bad packet type怎么解决

Question

java.sql.SQLException: Io 异常: Bad packet type
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334)
at oracle.jdbc.ttc7.TTC7Protocol.handleIOException(TTC7Protocol.java:3668)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:353)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:371)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:551)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:351)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at Test.main(Test.java:31)

Answer 1

查看你的OracleUrl是不是正确的????
看端口是否正确....

Answer 2

用的是10g 链接代码如下：
String sDBDriver = "oracle.jdbc.driver.OracleDriver"; 
String sConnStr = "jdbc:oracle:thin:@localhost:5500:JNDB"; 

Connection conn = null; 
ResultSet rs = null; 
Statement stmt = null; 
try {
//Class.forName( "oracle.jdbc.driver.OracleDriver" );
///Connection cn = DriverManager.getConnection("jdbc:oracle:thin:@zkj:1521:hzgis","gasys","gasys85814");
//System.out.println("**");
try{
Class.forName(sDBDriver).newInstance(); 
}catch(Exception e){
System.out.println("ssssssss");
}
conn = DriverManager.getConnection(sConnStr,"gasys","gasys2009"); 
stmt = conn.createStatement(); 
rs = stmt.executeQuery("select * from pkiuser"); 
rs.close();
conn.close();

} catch (Exception e) {
e.printStackTrace();
}

Answer 3

谢谢已经解决了谢谢YY_MM_DD也谢谢回帖的。

Answer 4

[INFO] Connecting to database at: jdbc:oracle:thin:@127.0.0.1:1521:orcl
[ERROR] Couldn't connect to JDBC source: jdbc:oracle:thin:@127.0.0.1:1521:orcl
java.sql.SQLException: Io 异常: Bad packet type