Re: pg73jdbc3.jar ClassNotFoundException

Thank you all for your help.
I tried the pg72jdbc2.jar instead, and the Driver can be found.
Take Care
Shannon

----- Original Message -----
From: Agrawal, Manish
To: 'Shannon Scott' ; pgsql-jdbc(at)postgresql(dot)org
Sent: Tuesday, February 18, 2003 4:46 PM
Subject: RE: [JDBC] pg73jdbc3.jar ClassNotFoundException

I am not sure if it applies to you but I had a similar problem in using pgsql and jdbc on windows. I found that the solution (in windows at least) is to save the jar file in <jdkhome>/jre/lib/ext

After placing the file correctly, I didn't have to worry about classpath.

Manish

_________________________________

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(at)coba(dot)usf(dot)edu

______________________________________

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

-----Original Message-----
From: Shannon Scott [mailto:sscott(at)gwi(dot)net]
Sent: Tuesday, February 18, 2003 3:46 PM
To: pgsql-jdbc(at)postgresql(dot)org
Subject: [JDBC] pg73jdbc3.jar ClassNotFoundException

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