pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Exception: java.sql.SQLException: No suitable driver
2+ messages / 2 participants
[nested] [flat]

* Exception: java.sql.SQLException: No suitable driver
@ 2000-02-18 17:34 Floyd Shackelford <FloydS@4peakstech.com>
  2000-02-18 22:32 ` Re: [INTERFACES] Exception: java.sql.SQLException: No suitable driver Ralf Lehmann <ralf@lehmann.cc>
  0 siblings, 1 reply; 2+ messages in thread

From: Floyd Shackelford @ 2000-02-18 17:34 UTC (permalink / raw)
  To: pgsql-interfaces


I am trying to write a jdbc application for the first time and I can't seem
to connect to the database. I think my code is write. I suspect that my
problem is in my run script. PrintJob is the name of the class I am running
which wants to access the database. Anyone have any suggestions?

I am using the jdbc6.5-1.1.jar downloaded from the postgresql jdbc web site.

here is the error I'm receiving:

Exception: java.sql.SQLException: No suitable driver
java.sql.SQLException: No suitable driver
        at java.sql.DriverManager.getConnection(DriverManager.java:111)
        at java.sql.DriverManager.getConnection(DriverManager.java:134)
        at PrintJob.ConnectDatabase(PrintJob.java:186)
        at PrintJob.main(PrintJob.java:496)


here is my run script:

#! /bin/bash

# NOTE
# The environment variable JDKTOP must be set to point
# to the top of the jdk directory before running this
# script

CLASSPATH=.:$JDKTOP/lib:../jar/jdbc6.5-1.1.jar

# the host name must be followed by a slash
DBURL=jdbc:postgresql://*.*.*.*/

DBUSER=******

# since the password is stored in this script, you want to insure
permissions
# are adequate to keep prying eyes away
DBPASSWD=*******

# set VERBOSE to blank if you want to turn the PrintJob server's verbose
mode off
VERBOSE=-verbose

cd ./class

java -Djdbc.drivers=postgresql.Driver PrintJob -dburl $DBURL -dbuser
$DBUSER -dbpasswd $DBPASSWD $VERBOSE

cd ..


Regards,
Floyd Shackelford
4 Peaks Technology Group, Inc.
http://www.4peakstech.com/
office: +1.888.398.4405
fax: +1.916.404.7125




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: [INTERFACES] Exception: java.sql.SQLException: No suitable driver
  2000-02-18 17:34 Exception: java.sql.SQLException: No suitable driver Floyd Shackelford <FloydS@4peakstech.com>
@ 2000-02-18 22:32 ` Ralf Lehmann <ralf@lehmann.cc>
  0 siblings, 0 replies; 2+ messages in thread

From: Ralf Lehmann @ 2000-02-18 22:32 UTC (permalink / raw)
  To: FloydS@4peakstech.com; +Cc: pgsql-interfaces



Floyd Shackelford schrieb:
> 
> I am trying to write a jdbc application for the first time and I can't seem
> to connect to the database. I think my code is write. I suspect that my
> problem is in my run script. PrintJob is the name of the class I am running
> which wants to access the database. Anyone have any suggestions?
> 
> I am using the jdbc6.5-1.1.jar downloaded from the postgresql jdbc web site.
> 
> here is the error I'm receiving:
> 
> Exception: java.sql.SQLException: No suitable driver
> java.sql.SQLException: No suitable driver
>         at java.sql.DriverManager.getConnection(DriverManager.java:111)
>         at java.sql.DriverManager.getConnection(DriverManager.java:134)
>         at PrintJob.ConnectDatabase(PrintJob.java:186)
>         at PrintJob.main(PrintJob.java:496)
> 
> here is my run script:
> 
> #! /bin/bash
> 
> # NOTE
> # The environment variable JDKTOP must be set to point
> # to the top of the jdk directory before running this
> # script
> 
> CLASSPATH=.:$JDKTOP/lib:../jar/jdbc6.5-1.1.jar
> 
> # the host name must be followed by a slash
> DBURL=jdbc:postgresql://*.*.*.*/
> 
> DBUSER=******
> 
> # since the password is stored in this script, you want to insure
> permissions
> # are adequate to keep prying eyes away
> DBPASSWD=*******
> 
> # set VERBOSE to blank if you want to turn the PrintJob server's verbose
> mode off
> VERBOSE=-verbose
> 
> cd ./class
> 
> java -Djdbc.drivers=postgresql.Driver PrintJob -dburl $DBURL -dbuser
> $DBUSER -dbpasswd $DBPASSWD $VERBOSE

youre script looks good !
but the error you get is typical a problem to find no driver(wrong
classpath or misplaced driver)
call java with -verbose flag and check if anything from jdbc6.5-1.1.jar
is loading.
if not check again your classpath there must a mistake
else
look in the jdbc.jar and check if postgresql.Driver.class is in it and
you have
a path like postgresql/jdbc2 or postgresql/jdbc1 eqvivalent to your jdk
i hope to solve your problem 


mfg
ralf lehmann



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2000-02-18 22:32 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-02-18 17:34 Exception: java.sql.SQLException: No suitable driver Floyd Shackelford <FloydS@4peakstech.com>
2000-02-18 22:32 ` Ralf Lehmann <ralf@lehmann.cc>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox