Skip site navigation (1) Skip section navigation (2)

Re: Failed to load jdbc driver

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Mamoon Rashid <mamoon(at)imtech(dot)res(dot)in>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Failed to load jdbc driver
Date: 2007-06-07 11:28:02
Message-ID: C3241F34-4F0B-40F4-AFFC-46E3C98D709B@fastcrypt.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
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


In response to

pgsql-jdbc by date

Next:From: Loredana CurugiuDate: 2007-06-07 14:08:49
Subject: Query with tables from 2 different databases in Java
Previous:From: Heikki LinnakangasDate: 2007-06-07 09:50:45
Subject: Re: Failed to load jdbc driver

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group