首页 文章

无法获得oracle数据库连接

提问于
浏览
-1

1.JAVA_HOME设置为IBM JAVA SDK . 2.无法获得oracle数据库连接 . 尝试在Oracle Java设置为JAVA_HOME的机器上运行相同的操作3.在AppServer / lib下放置ojdbc14.jar .

try {

  connection = DriverManager.getConnection(
      "jdbc:oracle:thin:@10.10.24.40:1521/konydb", "installer", "kony1234");

} catch (SQLException e) {

  System.out.println("Connection Failed! Check output console");
  e.printStackTrace();
  return;

}

if (connection != null) {
  System.out.println("You made it, take control your database now!");
} else {
  System.out.println("Failed to make connection!");
}

我需要做任何设置 . 下面是错误

Oracle JDBC驱动程序已注册!连接失败!检查输出控制台java.sql.SQLRecoverableException:IO错误:网络适配器无法在oracle.jdbc.driver.PhysicalConnection上的oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:517) Build 连接 . (PhysicalConnection.java :557)oracle.jdbc.driver.T4CConnection . (T4CConnection.java:233)at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:29)at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java) :556)java.sql.DriverManager.getConnection(DriverManager.java:583)at java.sql.DriverManager.getConnection(DriverManager.java:227)at OracleJDBCExample.main(OracleJDBCExample.java:29)引起:oracle.net .ns.NetException:网络适配器无法在oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:431)上的oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:389)上 Build 连接 . net.ns.NSProtocol.establishConnection(NSProtocol.java:882)at oracle.net.ns.NSProtocol.connect(NSProtocol . java:267)at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1625)at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:365)... 7更多引起:java.net . SocketTimeoutException:在Java.net上的java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:231)的java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:370)上的java.net.PlainSocketImpl.socketConnect(Native Method)连接超时 . java.net.SocksSocketImpl.connect(SocksSocketImpl.java:404)中的net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:213)位于oracle.net.nt.TcpNTAdapter的java.net.Socket.connect(Socket.java:643) .connect(TcpNTAdapter.java:147)oracle.net.nt.ConnOption.connect(ConnOption.java:130)at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:367)

谢谢,Kusuma

1 回答

  • 1

    这里有几件事需要检查:

    • 可以连接到10.10.24.40上的端口1521吗? (尝试telnet,netcat或类似的东西)

    • 听众是否接受连接?即sqlplus用户名/pw@10.10.24.40:1521 / konydb工作?

    • 是SID正确(konydb)?

    • 您是否尝试使用服务名称而不是SID进行连接: jdbc:oracle:thin:@//10.10.24.40:1521/<service name>

    另见Java JDBC - How to connect to Oracle using Service Name instead of SID

相关问题