Re: pg73jdbc3.jar ClassNotFoundException

Daniel,
Thank you for responding.
I compiled it into a class:
javac TestConn.java

Then tried to run it:
java TestConn

Do you know what I am doing wrong?
Thanks Again.
Shannon


----- Original Message -----
From: "Daniel Serodio" <daniel@checkforte.com.br>
To: "Shannon Scott" <sscott@gwi.net>
Cc: "PostgreSQL JDBC List" <pgsql-jdbc@postgresql.org>
Sent: Tuesday, February 18, 2003 3:59 PM
Subject: Re: [JDBC] pg73jdbc3.jar ClassNotFoundException


> How are you invoking this sample app? If this is packed within a jar,
> you need to pass -classpath as the CLASSPATH env var is ignored.
>
> []'s
> Daniel Serodio
>
> On Tue, 2003-02-18 at 17:45, Shannon Scott wrote:
> > Hello,
> > My apologies if this is a repeat question... I could not find my
> > answer in the archives.
> > I am trying to connect to PostGreSQL through a JDBC connection.
> > I have set my classpath ( returned from set ):
> >
CLASSPATH=/usr/java/j2sdk1.4.0/lib/tools.jar:.:/usr/java/j2sdk1.4.0/dt.jar:/
usr/java/local/lib/pg73jdbc3.jar
> >
> > but when I run my sample:
> >
> > import java.sql.*;
> >
> > public class TestConn
> > {
> >   public static void main( String argv[] ) throws
> >     java.sql.SQLException, java.lang.ClassNotFoundException
> >   {
> >     Class.forName( "org.postgresql.Driver" );
> >     String url = "jdbc:postgresql://test:5432/test";
> >     Connection conn = DriverManager.getConnection( url, "test",
> > "testpass" );
> >   }
> > }
> >
> > It throws the ClassNotFoundException.
> > I am using:
> > Redhat 8.0
> > PostGreSQL 7.2
> > J2SDK  1.4.0
> >
> > I thought this ( pg73jdbc3.jar )  was the right version to use.
> > I'm sure I've missed something simple... any help is greatly
> > appreciated.
> > I have successfully set up JDBC connections for Oracle and MySQL in
> > the past without problems.
> > Thank You for any Help.
> > Shannon
> >
> >
> >
> --
> Daniel Serodio <daniel@checkforte.com.br>
> CheckForte
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>