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.