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