Hi,
I need some help on how to execute some SQL commands using a java program
run in a UNIX server to update postgresql database installed on a Linux
workstation. This server and workstation are connected through LAN.
I have installed the postgresql with java support (JDBC). I have also define
the CLASSPATH variable.
$ echo $CLASSPATH
/usr/lib/jdk-1.1.6/lib/classes.zip:/usr/local/lib/finder.jar:/usr/local/pgsql/sh
are/java/postgresql.jar:.:/opt/IBMJava2-13/javasrc.jar:.:/home/rudy
I anc run the program in the Linux workstation but when I try to run it in
the UNIX server (HP-UX) there is error :
java.lang.ClassNotFoundException: org.postgresql.Driver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at db.main(db.java:15)
part of the program :
String url="jdbc:postgresql://"+linuxIPAddress+"/"+databaseName;
Class.forName("org.postgresql.driver"); // <- this is the line 15
Connection db=DriverManager.getConnection(url, "user", "password");
Statement a=db.createStatement();
ResultSet rs=a.executeQuery("SELECT * FROM "+tableName);
I have installed the database and create the table
OK that's all thanks for your help
Rudi
_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com