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@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
-----Original Message-----
From: Shannon Scott [mailto:sscott@gwi.net]
Sent: Tuesday, February 18, 2003 3:46 PM
To: pgsql-jdbc@postgresql.org
Subject: [JDBC] pg73jdbc3.jar ClassNotFoundException
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:
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 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.
