Can't get JDBC to compile. Please help.

From: IronSheikh <kazisiddiqui(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Can't get JDBC to compile. Please help.
Date: 2009-04-12 18:48:37
Message-ID: 23013717.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2009-04-13 15:34:47 Re: Can't get JDBC to compile. Please help.
Previous Message Raghavendra b 2009-04-12 03:14:07 Reminder: Please Respond to Raghavendra's Invitation