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 по дате отправления:

Предыдущее
От: Janning Vygen
Дата:
Сообщение: Re: bug with prepared statements and sql comments in 8.1-408.jdbc3
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Failed to load jdbc driver