오라클을 사용하고 있는데 oci에서는 잘 돌아가는 군요 그런데 thin으로 하니까 에러가 생기네요. 아시는 분은 좀 가르쳐 주세요
java.sql.SQLException: IO 예외 상황: The Network Adapter could not establish the connection
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java)
at java.sql.DriverManager.getConnection(DriverManager.java:83)
at java.sql.DriverManager.getConnection(DriverManager.java:126)
at JDBC.main(JDBC.java:9)
소스는 이렇습니다.
import java.sql.*;
import java.math.*;
public class JDBC {
public static void main (String[] args) throws SQLException {
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection conn = DriverManager.getConnection ( "jdbc:oracle:thin:@xxx.xxx.x.xx:1521:ORA8","system","manager");
Statement stat = conn.createStatement();
ResultSet rs = stat.executeQuery("select * from all_users");
while(rs.next()) {
System.out.print(rs.getString(1));
System.out.print( " " + rs.getInt(2));
System.out.println(" " + rs.getString(3));
}
stat.close();
conn.close();
}
}
|