forName finds Driver but getConnection doesn't

From: Dennis King <d_r_king(at)yahoo(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: forName finds Driver but getConnection doesn't
Date: 2002-11-19 23:46:40
Message-ID: 20021119234640.45378.qmail@web40411.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi All. I can't get to my carefully set-up database through java with
a simple test program. I think I've hit most of the required set-up
points:

* I've got all the postgresql packages installed (checked with rpm
-qa | grep -i postgres; they're there, including the jdbc one).
* I set tcpip_socket = true in /var/lib/pgsql/data/postgresql.conf.
* I also updated /etc/rc.d/init.d/ so that postmaster gets -o "-i";
this means that the "pg_ctl -D /var/lib/pgsql/data status" command
shows the -i flag was passed in.
* I have the right driver in the classpath (I pass in -classpath
/usr/share/pgsql/pgjdbc2.jar when compiling and running; for some
reason, copying the jar to /jre/lib/ext doesn't work with any jars
for me).
* I added the lines "host all 127.0.0.1 255.255.255.255 trust" and
"host all 192.168.0.0 255.255.0.0 trust" to
/var/lib/pgsql/data/pg_hba.conf
* I created a new database, "webdb"
* I added the user "xxx" with the password "yyy" to the database, and
verified by logging into psql with -U xxx (had pg_hba.conf set to
password so was challenged and succeeded)

With all of this, my java program has these lines:

Connection dbConnection = null;
try{
Class.forName("org.postgresql.Driver");
dbConnection = DriverManager.getConnection("jdbc:postgresql:webdb",
"xxx", "yyy");
}

I get the error "java.sql.SQLException: Driver not found for URL:
jdbc:postgresql:webdb". (Note it's finding the driver with the
forName() method call).

I've tried using jdbc:postgresql://localhost/webdb.

I have, of course, restarted the box several times.

Any pointers you have would be extremely gratefully received.

Best,

Dennis

__________________________________________________
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site
http://webhosting.yahoo.com

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Jeff Hodd 2002-11-20 00:07:28 Missing javarc file
Previous Message Stuart Robinson 2002-11-19 23:44:11 Re: default values