[JDBC] Still having trouble getting JDBC working

[Corey Mosher]

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]