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