RE: JDBC on HP-UX

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