Re: pg73jdbc3.jar ClassNotFoundException - Mailing list pgsql-jdbc

_________________________________

Manish Agrawal

Asstt. Prof., Dept. of ISDS, Univ. of South Florida

4202 E. Fowler Ave., CIS 1040, Tampa, Fl 33620 - 7800

(813)-974-6716 (W) 974-6749 (FAX)

magrawal@coba.usf.edu

______________________________________

My default office suite is Openoffice, the simple-to-use, opensource Office Suite for Windows, Linux and Macs. http://www.openoffice.org

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