Can't get JDBC to compile. Please help.

Поиск
Список
Период
Сортировка
От IronSheikh
Тема Can't get JDBC to compile. Please help.
Дата
Msg-id 23013717.post@talk.nabble.com
обсуждение исходный текст
Ответы Re: Can't get JDBC to compile. Please help.  (Dave Cramer <pg@fastcrypt.com>)
Re: Can't get JDBC to compile. Please help.  (Guy Rouillier <guyr-ml1@burntmail.com>)
Список pgsql-jdbc
I'm a beginner. I installed PostGRESQL 8.3 with edb_pgjdbc.exe on Windows XP
SP2.

The following test code won't compile:
package javaapplication1;
import java.sql.*;

public class Main {

    public static void main(String[] args) {
     try
     {
       helloPostgresql();
     }
     catch (Exception ex)
     {
       System.out.println("***Exception:\n"+ex);
       ex.printStackTrace();
     }
    }

    public static void helloPostgresql()
            throws ClassNotFoundException, SQLException
    {
     Class.forName("org.postgresql.Driver");
     Connection db = DriverManager.getConnection("jdbc:postgresql:pathos",
"postgres", "cuy4867z");

     PreparedStatement st = db.prepareStatement("INSERT INTO test VALUES
(?,?,?)");
     st.setInt(1, 5);
     st.setString(2, "'$10.00'");
     st.setString(3, "'full checkup'");
     st.executeUpdate();
     st.close();

     db.close();
    }

}

NetBeans says:
***Exception:
java.lang.ClassNotFoundException: org.postgresql.Driver
java.lang.ClassNotFoundException: org.postgresql.Driver
        at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:252)
        at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:169)
        at javaapplication1.Main.helloPostgresql(Main.java:36)
        at javaapplication1.Main.main(Main.java:24)
BUILD SUCCESSFUL (total time: 0 seconds)

I've tried adding "E:\Program Files\PostgreSQL\pgJDBC" to the CLASSPATH. Any
suggestions?
--
View this message in context: http://www.nabble.com/Can%27t-get-JDBC-to-compile.-Please-help.-tp23013717p23013717.html
Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.


В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Raghavendra b
Дата:
Сообщение: Reminder: Please Respond to Raghavendra's Invitation
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: Can't get JDBC to compile. Please help.