From: Floyd Shackelford <FloydS@4peakstech.com>
To: pgsql-interfaces@postgresql.org
Subject: No suitable driver
Date: Fri, 18 Feb 2000 10:08:55 -0700
Message-ID: <000301bf7a32$d68bc1a0$9701a8c0@azoffice.4peakstech.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: FloydS@4peakstech.com
Subject: Re: No suitable driver
In-Reply-To: <000301bf7a32$d68bc1a0$9701a8c0@azoffice.4peakstech.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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