Io 异常: The Network Adapter could not establish the

最新推荐文章于 2024-10-17 11:40:24 发布

原创最新推荐文章于 2024-10-17 11:40:24 发布 · 235 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#Oracle #JDBC #Java #SQL #thread

本文介绍了一个使用Java连接Oracle数据库时遇到的The Network Adapter could not establish the connection异常，并提供了完整的错误堆栈跟踪信息。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

package org.jinjiabao.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;


public class TestConnection {
	public static void main(String[] args) throws ClassNotFoundException, SQLException{
		String user = "lisi";
		String password = "lisi";
//String url = "jdbc:oracle:thin:@localhost:1521:ORCL";
		String url = "jdbc:oracle:thin:@192.168.1.100:1521:ORCL";
		String driver = "oracle.jdbc.driver.OracleDriver";
		Class.forName(driver);
		
		Connection conn = DriverManager.getConnection(url, user, password);
		
		System.out.println("Connection: " + conn);
	}
}

出现的异常：

Exception in thread "main" java.sql.SQLRecoverableException: Io 异常: The Network Adapter could not establish the connection
	at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:101)
	at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:229)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:458)
	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:411)
	at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:490)
	at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:202)
	at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:465)
	at java.sql.DriverManager.getConnection(DriverManager.java:582)
	at java.sql.DriverManager.getConnection(DriverManager.java:185)
	at org.jinjiabao.jdbc.TestConnection.main(TestConnection.java:21)