Re: from UNIX to postgresql in Linux

Hi Dave, thanks but i 'm sorry that was a typing error when i type this
email. On the program i type correctly. So it's still not working hehehe.

Thanks very much for your reply

Rudi

>From: Dave Cramer <Dave(at)micro-automation(dot)net>
>To: Rudianto Sugiyarto <rudi2610(at)hotmail(dot)com>
>CC: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
>Subject: Re: [JDBC] from UNIX to postgresql in Linux
>Date: 22 Aug 2002 00:06:41 -0400
>
>Rudianto,
>
>change org.postgresql.driver to org.postgresql.Driver
>
>Dave
>On Wed, 2002-08-21 at 23:55, Rudianto Sugiyarto wrote:
> > 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
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> > http://archives.postgresql.org
> >
> >
>
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>message can get through to the mailing list cleanly

_________________________________________________________________
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx