|
-- 사이버 님이 쓰신 글:
>> Postgresql에서 직접 디비 생성하고..쿼리 던지면..제대로 되는지요...???
>> 만약 제대로 된다면....
>>
>> 음...제 생각하기에는...
>> 드라이버가 잘못된것 같은데..
>>
>> 에러 내용으로 봐서는...
>> 디비를 커넥션 할수 없다는거 같튼데요...
>>
>> 음..저도 자바에다가 포스트를 쓰는데..별 문제는 없거든요..
>> 될건데~~~????
>> 이상타..
>>
>> 하여간 에러로 봐서는...
>> 드라이버 로딩 쪽에서 나는거 같습니다..
>> 수고...
>> 수고..
>>
>> -- 김훈 님이 쓰신 글:
>> >> 안녕하세요? 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)
>> >>
>> >> 답변부탁드립니다.
|
