Corey, This looks like it should work. The only thing I can think of is that you need to export the classpath so that it is visible outside of the .cshrc file? what to you get when you execute echo $CLASSPATH The only other possibility is that you are using a real old version of the driver. At one time the driver was in a package postgresql.Driver try looking at the contents of the postgres char jar -tvf postgresql.jar should list the contents. Other than that your code looks like it should execute Regards, Dave ----- Original Message ----- From: "Corey Mosher" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 19, 2001 2:56 PM Subject: [JDBC] Still having trouble getting JDBC working > Hi > Can anyone help me with this problem? I have jdk1.2.2 installed on > a freeBSD system. My class path in .cshrc is as follows: > > set CLASSPATH = (/usr/local/lib/postgresql.jar) > > I get this error: > > Exception caught. > java.lang.ClassNotFoundException: org.postgresql.Driver > Exception caught. > java.sql.SQLException: No suitable driver > Ok > > When running the following code (I replaced all the connection stuff with x's for privacy reasons): > > import java.io.*; > import java.sql.*; > import java.util.*; > > public class test{ > > public static void main(String args[]){ > Connection conn; // holds database connection > Properties prop = new Properties(); > prop.put("jdbc.drivers", "org.postgresql.Driver"); > System.setProperties(prop); > try { > Class.forName("org.postgresql.Driver"); // load database interface > } catch(Exception exc){ > System.err.println("Exception caught.\n" + exc); > } > try { > conn = DriverManager.getConnection("jdbc:postgresql://xxxxxxxx:5432/xxxxx", "xxxxx", "xxxxxx"); > } catch(Exception exc){ > System.err.println("Exception caught.\n" + exc); > } > System.out.println("Ok"); > //conn.close(); > } } > > Does the postgresql.jar file need any special permissions? Right now I have: > > -rw-r--r-- 1 root wheel 153145 Apr 16 08:53 /usr/local/lib/postgresql.jar > > Any ideas? > > Thanks. > > Corey Mosher > > ----------------------------- > Hub.Org Networking Services > 251 Main St. > Wolfville, NS > Canada > B0P 1X0 > Email: [EMAIL PROTECTED] > Phone: (902) 542-3657 > ----------------------------- > PostgreSQL, Inc. > 251 Main St. > Wolfville, NS > Canada > B0P 1X0 > Email: [EMAIL PROTECTED] > Phone: (902) 542-0713 > ----------------------------- > Fax: (902) 542-5386 > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] > > ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])