Failed to load jdbc driver
От | Mamoon Rashid |
---|---|
Тема | Failed to load jdbc driver |
Дата | |
Msg-id | 46984.59.160.112.41.1181204514.squirrel@imtech.res.in обсуждение исходный текст |
Ответы |
Re: Failed to load jdbc driver
Re: Failed to load jdbc driver |
Список | 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.
В списке pgsql-jdbc по дате отправления: