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" <corey@pgsql.com>
To: <pgsql-jdbc@postgresql.org>
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: corey@hub.org
> Phone: (902) 542-3657
> -----------------------------
> PostgreSQL, Inc.
> 251 Main St.
> Wolfville, NS
> Canada
> B0P 1X0
> Email: corey@pgsql.com
> Phone: (902) 542-0713
> -----------------------------
> Fax: (902) 542-5386
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>
