Still having trouble getting JDBC working

From: Corey Mosher <corey(at)pgsql(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Still having trouble getting JDBC working
Date: 2001-04-19 18:56:53
Message-ID: Pine.BSF.4.21.0104191550160.4991-100000@wired.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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(at)hub(dot)org
Phone: (902) 542-3657
-----------------------------
PostgreSQL, Inc.
251 Main St.
Wolfville, NS
Canada
B0P 1X0
Email: corey(at)pgsql(dot)com
Phone: (902) 542-0713
-----------------------------
Fax: (902) 542-5386

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Hunter Hillegas 2001-04-19 22:45:37 A Bug Fix - Is this a real bug? Has this already been fixed?
Previous Message Lamar Owen 2001-04-19 18:24:02 Re: 7.1 RPM has old JDBC driver - SQL statement too long