From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
---|---|
To: | Chandra ASGI Tech <chandraasgi(at)gmail(dot)com> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: JDBC driver not found error: Windows XP / JDK1.6.06 / PG8.2.9 |
Date: | 2008-07-01 14:33:08 |
Message-ID: | 982688B8-EB05-4C8B-BD78-ED3C304B24DD@fastcrypt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
You have used a capital P in the url jdbc:Postgresql://localhost:5432/
postgres","postgres","1234");
Dave
On 1-Jul-08, at 9:28 AM, Chandra ASGI Tech wrote:
> 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 | Oliver Jowett | 2008-07-01 15:21:42 | Re: JDBC driver not found error: Windows XP / JDK1.6.06 / PG8.2.9 |
Previous Message | Chandra ASGI Tech | 2008-07-01 13:28:55 | JDBC driver not found error: Windows XP / JDK1.6.06 / PG8.2.9 |