Failed to load jdbc driver

From: Mamoon Rashid <mamoon(at)imtech(dot)res(dot)in>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Failed to load jdbc driver
Date: 2007-06-07 08:21:54
Message-ID: 46984.59.160.112.41.1181204514.squirrel@imtech.res.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

hi all,
background Info-
1.OS: EL4 linux
2. postgresql 8.2.4
3. postgresql-8.2-505.jdbc4.jar
4. JDK1.6
5. Apache2.0.59
6. PHP as cgi processor
When i try to execute my JDBC program through browser the error in the
httpd error_log file look like-
[Thu Jun 07 13:28:35 2007] [error] [client 127.0.0.1] Failed to load
driver., referer: http://127.0.0.1/search.html
[Thu Jun 07 13:28:35 2007] [error] [client 127.0.0.1] , referer:
http://127.0.0.1/search.html

Although i am able to execute this from terminal.The following are the
syntax to load the driver and connect to the database server in JDBC
progm-
String sDriver = "org.postgresql.Driver";
String sURL = "jdbc:postgresql://127.0.0.1:5432/infodb";
//instead of 127.0.0.1 , [::1] also works
String sUSER = "nobody";//user of the database
String sPASSWD = "";

try //try to load the jdbc driver
{
Class.forName ("org.postgresql.Driver");
}
catch (Exception e)//error
{
System.err.println("Failed to load driver.");
return;
}//end catch

try //try to connect to database server
{
con = DriverManager.getConnection (sURL, sUSER, sPASSWD);
stmt = con.createStatement();
}
catch (Exception e)
{
System.err.println ("Problem connecting to" + sURL + ":");
System.err.println (e.getMessage());
if(con != null){
try{con.close();}
catch(Exception e2){};
}
return;
}//catch ends

The Host based authentication (pg_hba.config) of the database are as follows
-
# TYPE DATABASE USER CIDR-ADDRESS METHOD

# "local" is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
host all all 127.0.0.1/32 trust
# IPv6 local connections:
host all all ::1/128 trust

******************************************************
can anyone suggest where i m missing. Really urgent.i hope the info i hv
given is sufficient.

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Heikki Linnakangas 2007-06-07 08:41:35 Re: Failed to load jdbc driver
Previous Message Janning Vygen 2007-06-05 20:09:49 Re: bug with prepared statements and sql comments in 8.1-408.jdbc3