RE: JDBC on HP-UX

There's two things that could go wrong here. The first one is the CLASSPATH,
but you have the jar file in there correctly, but did you export CLASSPATH?
If not, the shell won't pass it on to any child processes including java.

The other is the jdbc url. It should begin: jdbc:postgresql: If the url
doesn't match, then thr driver won't recognise it, and you'll get the same
error.

Peter

--
Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council.

-----Original Message-----
From: Sondaar, Roelof [mailto:roelof(dot)sondaar(at)scania(dot)com]
Sent: Tuesday, May 30, 2000 10:10 AM
To: 'pgsql-interfaces(at)postgresql(dot)org'
Subject: [INTERFACES] JDBC on HP-UX

Hello Everybody,

If I am in the wrong list, please let me know.

I have a problem to get JDBC running.

I get the following messages:
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:103)
at java.sql.DriverManager.getConnection(DriverManager.java:126)
at DBqueryWindow.openDB(DBqueryWindow.java:554)
at DBqueryWindow.actionPerformed(DBqueryWindow.java:260)
at java.awt.Button.processActionEvent(Button.java:256)
at java.awt.Button.processEvent(Button.java:229)
at java.awt.Component.dispatchEventImpl(Compiled Code)
at java.awt.Component.dispatchEvent(Compiled Code)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:79)

I downloaded the JDBC drivers from retep.. jdbc6_5-1_1.jar.
I am running PostgreSQL 6.5.3 on hpux10.20.
The CLASSPATH seems OK
(CLASSPATH=.:/opt/java:/home/snlsor/java:/home/snlsor/bin:/opt/java/jdbc/pos
tgresql/jdbc6_5-1_1.jar).

Perhaps someone can shed some light on this.

Best regards,
Roelof