Re: pg73jdbc3.jar ClassNotFoundException

----- Original Message -----

From: Agrawal, Manish

To: 'Shannon Scott' ; pgsql-jdbc@postgresql.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@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

 

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