Hello all,
I'm trying to get the following simple program to run just to confirm a connection to the database:
//PostgresqlClient.java
import java.sql.*;
public class PostgresqlClient{
public static void main(String[] arguments)
throws ClassNotFoundException, SQLException{
String driver = "org.postgresql.Driver";
String url ="localhost";
String user = "root";
String pwd = "password";
Class.forName(driver);
Connection con = DriverManager.getConnection(url, user, pwd);
System.err.println("Connection complete");
con.close();
}
}
I keep getting the folowing errors:
Exception in thread "main" java.lang.ClassNotFoundException: org.postgresql.Driver
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged (Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java :268)
at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName (Class.java:164)
at PostgresqlClient.main(PostgresqlClient.java:12)
Java Result: 1
BUILD SUCCESSFUL (total time: 0 seconds)
I have tried adding the postgresql.jar file to my CLASSPATH, and have also tried copying the postgresql.jar file to the same directory as the PostgresqlClient.java and PostgresqlClient.class directories. I have also tried running the following from the command line:
java -classpath postgresql.jar PostgresqlClient.class
I am using jdk1.5.0_09 and have tried using nearly all the available postgresql.jar files available.
Any advice would be most appreciated.
Cheers,
Greg Peters....
