Thread: 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)
atjava.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
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)
atjava.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
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
Peter Mount <petermount@it.maidstone.gov.uk> writes: > 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. > Couldn't it also be that he hasn't told the system about the jdbc driver ? You have to supply the driver as a -Djdbc.drivers argument or load it from your Java code. regards, Gunnar
That's true, I forgot that one ;-) Peter -- Peter Mount Enterprise Support Maidstone Borough Council Any views stated are my own, and not those of Maidstone Borough Council. -----Original Message----- From: Gunnar R|nning [mailto:gunnar@candleweb.no] Sent: Tuesday, May 30, 2000 10:40 AM To: Peter Mount Cc: 'Sondaar, Roelof'; 'pgsql-interfaces@postgresql.org' Subject: Re: [INTERFACES] JDBC on HP-UX Peter Mount <petermount@it.maidstone.gov.uk> writes: > 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. > Couldn't it also be that he hasn't told the system about the jdbc driver ? You have to supply the driver as a -Djdbc.drivers argument or load it from your Java code. regards, Gunnar