Re: Failed to load jdbc driver

Hi,

Are you trying to use the driver in an applet ? If so you have to add
it to the resources of the applet.

Dave
On 7-Jun-07, at 4:21 AM, Mamoon Rashid wrote:

> 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.
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
> http://www.postgresql.org/about/donate