From: | "Chandra ASGI Tech" <chandraasgi(at)gmail(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | JDBC driver not found error: Windows XP / JDK1.6.06 / PG8.2.9 |
Date: | 2008-07-01 13:28:55 |
Message-ID: | fbf9dcc60807010628m51d7ede2lb3b4ac0732593726@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
I have PostgreSQL 8.2.9 on Windows XP, with JDK 1.6.0_06. Have got the
postgresql-8.2-508.jdbc4.jar jdbc driver in /lib/ext of the Java folder.
HAve set both the PATH and CLASSPATH aporpriately
My Java code for testing is:
import java.sql.*;
class postgreSQLTest
{
public static void main (java.lang.String[] args) throws Exception {
try{
Class.forName("org.postgresql.Driver");
Connection con =
DriverManager.getConnection("jdbc:Postgresql://localhost:5432/postgres","postgres","1234");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("select * from country");
while(rs.next())
{
System.out.println(rs.getString(1)+"<br>");
}
}catch(Exception e){
System.out.println(e);
}
}
}
But I get the error
Exception in thread "main" java.lang.NoClassDefFoundError: postgreSQLTest
Any help? Thanks in advance.
- ChandraASGI
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2008-07-01 14:33:08 | Re: JDBC driver not found error: Windows XP / JDK1.6.06 / PG8.2.9 |
Previous Message | cap20 | 2008-06-30 20:17:00 | Re: insert data into partitioned tables via Java application |