Re: 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 <http://coba.usf.edu/departments/isds/faculty/agrawal/index.html>
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 <mailto:magrawal(at)coba(dot)usf(dot)edu>

______________________________________

My default office suite is Openoffice <http://www.openoffice.org> , the
simple-to-use, opensource Office Suite for Windows, Linux and Macs.
http://www.openoffice.org <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