运行java代码测试连接oracle数据库时报如下错误:
java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection
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:333)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:404)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:468)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at com.hb.util.DBHelper.getConn(DBHelper.java:20)
at com.hb.util.DBHelper.main(DBHelper.java:41)
原因已经找到,因为安装oracle时配置了一个固定IP地址,所以必须讲url里面的localhost改成那个固定的IP地址。如图所示:
改了以后就可以了: