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
