Re: 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