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(at)checkforte(dot)com(dot)br>
CheckForte