From Bugzilla Helper:
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:0.9.2.1) Gecko/20010901

Description of problem:
Driver can't be created for sourceURL with the new installation.

I installed 8.0 clean with the server option, all packages. I set
/var/lib/pgsql/data/postgresql.conf's tcpip_sockets=true (and uncommented the
line). I also changed the /etc/rc.d/init.d/postgresql script to pass in the -i
parameter. I created a test database, with a best user, and confirmed that I
could get there with psql -U testuser -d testdb. I updated
/var/lib/pgsql/data/pg_hba.conf to allow connections all kinds of ways, one at a
time: localhost at 127.0.0.1 using password, using trust, localhost at
192.168.0.0 using password and trust, host using trust and password. I put the
.jar file in my classpath and compiled a sample script per the example online,
using Class.forName("org.postgresql.Driver") to register the class, which succeeded.

But Connection dbConnect = DriverManager.getConnection("jdbc:postgresql:testdb",
"testdb", "password") failed with an SQLException: can't find driver for URL
jdbc:postgresql:testdb. 

I've shown everything I did to the pgsql-jdbc mailing list at postgresql.org. No
one can find anything wrong after many suggestions.

I tried disabling the firewall through the security manager, but every time I
return to it, it is on the default High setting. I don't believe this should be
an issue since this is all on one machine.

Help! Thanks!

d_r_king

Version-Release number of selected component (if applicable):


How reproducible:
Always

Steps to Reproduce:
1. Configure postgres for tcp/ip in .conf file and init.d script
2. put distribution jar file into classpath
3. Compile this program (from memory here, excuse typos, they're not in the
original):

import java.sql.*;

public class HiDB {
 public static void main (String[] args) {
  try {
   Class.forName("org.postgresql.Driver");
   System.out.println("Got driver.");
  } catch (SQLException (e) {
   System.out.println("No registered driver.");
  Connection dbConnect=null;
  try {
   dbConnect = DriverManager.getConnection("jdbc:postgresql:testdb", "username",
"password");
  } catch SQLException (e) {
   System.out.println(e);
   System.out.printStackTrace(e);
  }
 }
}

4. Compile and run. You won't get a connection. libgcj.something is mentioned;
someone asked why that showed up, but that's deep in the internals. ???

Actual Results:  SQLException from Java program.

Expected Results:  Connection object returned by function call getConnection().

Additional info:

I have seen a few other notes on the archive of pgsql-jdbc at the postgresql
site from others having problems with Red Hat 8 and JDBC with postgresql. We
also can't compile from source to get around this problem.