Hello Peter,
Thank you for your quick response.
You are absolutely right, I had the url wrong.
Thanks again,
Roelof
> -----Original Message-----
> From: Peter Mount [SMTP:petermount@it.maidstone.gov.uk]
> Sent: Tuesday, 30 May, 2000 11:34
> To: 'Sondaar, Roelof'; 'pgsql-interfaces@postgresql.org'
> Subject: RE: [INTERFACES] 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.sondaar@scania.com]
> Sent: Tuesday, May 30, 2000 10:10 AM
> To: 'pgsql-interfaces@postgresql.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/p
> os
> tgresql/jdbc6_5-1_1.jar).
>
> Perhaps someone can shed some light on this.
>
> Best regards,
> Roelof