수다닷컴

import java.sql.*;

public class ch02Sample01
{
public static void main(String[] args) throws Exception
{
String url = jdbc:oracle:thin:@127.0.0.1:1521:orcl;
String user = test;
String password = test123;

Class.forName(oracle.jdbc.driver.OracleDriver);
Connection con = DriverManager.getConnection(url,user,password);
Statement stmt = con.createStatement();
ResultSet rset = stmt.executeQuery(SELECT DEPTNO, DNAME, LOC FROM DEPT2);

System.out.println( 번호 이름 위치 );
System.out.println(-------------------------------);

while(rset.next())
{
System.out.print(rset.getInt(1)+ \t);
System.out.print(rset.getString(2)+ \t);
System.out.print(rset.getString(3));
}

if(rset != null)
rset.close();
if(stmt != null)
stmt.close();
if(con != null)
con.close();

}
}에러메세지는...

---------- RunTime ----------
java.sql.SQLException: IO 예외 상황: The Network Adapter could not establish the connection
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
at oracle.jdbc.driver.PhysicalConnection.init(PhysicalConnection.java:414)
at oracle.jdbc.driver.T4CConnection.init(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at ch02Sample01.main(ch02Sample01.java:12)
Exception in thread main
출력 완료 (2초 경과) - 정상 종료
환경 : winxp sp2, oracle 10g, jdk1.4.2_10

ojdbc.jar 파일은 C:\j2sdk1.4.2\jre\lib\ext\ojdbc14.jar 위치해 있습니다.

classpath 안잡았다가 혹시나 싶어서 다시 잡고해도 마찬가지입니다.
어떤부분이 잘못되었는지 한번 봐주세요. 감사합니다.
덧붙임... okjsp에 질문을 올렸는데;;; 아직 답변이 없어서 이곳에도 올립니다. 딱 막혀서 답답하네요... ^^;;;

신청하기