Re: JDBC for PostgreSql - Mailing list pgsql-jdbc

From Liam Stewart
Subject Re: JDBC for PostgreSql
Date
Msg-id 20020507105531.D8827@redhat.com
Whole thread Raw
List pgsql-jdbc
I'm not too sure about what's going on either. What version of Java do
you have and how are you running the program? Perhaps the driver jar
file is corrupted: does

  $ jar -tf /usr/java/jdk/jre/lib/ext/jdbc7.1-1.2.jar

produce a list of files or nothing?

Liam

On Mon, May 06, 2002 at 03:53:17PM -0400, Patricio Muñoz wrote:
> Hi,
> when run the sample application, the show message is:
> "ClassNotFoundException: org/postgresql/Driver"
> I don´t understand what's up
>
> the enviroment
> $CLASSPATH=/usr/java/jdk:/usr/java/jdk/lib:/home/pmunoz/java/:/usr/java/jdk/
> jre/lib/ext/jdbc7.1-1.2.jar.
> the driver installed in /usr/java/jdk/jre/lib/ext/jdbc7.1-1.2.jar
>
> O.S. RedHat 7.2
> PostgeSQL 7.1.3
>
> sample:
> import java.sql.*;
>
> class PostgreSQLTest
> {
>   public static void main (String[] args)
>   {
>     try
>       {
>       Class.forName("org.postgresql.Driver");
>
>       String     url = "jdbc:postgresql:webcam";
>       Connection con = DriverManager.getConnection(url, "postgres",
> "postgres");
>       Statement  stm = con.createStatement();
>
>       stm.setQueryTimeout(10);
>       ResultSet  rs  = stm.executeQuery("select login from cliente");
>
>       rs.next();
>
>       System.out.println(rs.getString("login"));
>
>       }
>
>      catch(java.lang.ClassNotFoundException e)
>         {
>         System.err.print("ClassNotFoundException: ");
>         System.err.println(e.getMessage());
>         }
>
>      catch (SQLException e)
>       {
>       System.out.println("Exception!");
>       System.out.println(e.toString());
>       }
>    }
> }
>
> Regards,
>
> Patricio Muñoz M.
> Depto. Desarrollo de Aplicaciones.
> Mail: pmunoz@cmet.net
> Fono: (56)(2) 2513333
> Anexo: 413
>
> CMET S.A.C.I.

--
Liam Stewart :: Red Hat Canada, Ltd. :: liams@redhat.com

pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Looking for PostGres jdbc bindings
Next
From: Barry Lind
Date:
Subject: Re: Problems with "order by clause"