|
안녕하세요? JDBC드라이버를 설치하고.. classpath잡고..
컴파일은 되는데요.. 실행이 않됩니다.
아래가 소스코드 이구요..
import java.io.*;
import java.sql.*;
public class TestDB {
public static void main(String [] argc) throws Exception {
try {
//Class.forName("org.postgresql.Driver");
DriverManager.registerDriver(new org.postgresql.Driver());
} catch (Exception e) {
System.out.println("1");
}
Connection conn = DriverManager.getConnection("localhost","test","test");
Statement stmt = conn.createStatement();
ResultSet rset = stmt.executeQuery("SELECT id,name,age from exercise_table");
while(rset.next()) {
System.out.println(rset.getString(1));
System.out.println(rset.getString(2));
System.out.println(rset.getInt(3));
}
conn.close();
}
}
아래가 실행시에 뜨는 에러 입니다.
어디가 문제인지요?
java.lang.NullPointerException
at org.postgresql.Connection.openConnection(Unknown Source)
at org.postgresql.Driver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:177)
at TestDB.main(TestDB.java:14)
End of Stack Trace
at org.postgresql.Driver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:177)
at TestDB.main(TestDB.java:14)
답변부탁드립니다.
|
