Thread: RV: [ADMIN] postgresql JDBC driver question

RV: [ADMIN] postgresql JDBC driver question

From
"Adrian Camero"
Date:
Hy Murad:
                    the variable "con" will be Connection type

                          Class.forName("postgresql.Driver");
  >>>>>>>>>   Connection  con = DriverManager.getConnection(url, usr, pwd);
                          stmt = con.createStatement();


-----Mensaje original-----
De: Murad Nayal <murad@godel.bioc.columbia.edu>
Para: pgsql-interfaces@postgreSQL.org <pgsql-interfaces@postgreSQL.org>;
pgsql-admin@postgreSQL.org <pgsql-admin@postgreSQL.org>
Fecha: Martes 27 de Octubre de 1998 00:43
Asunto: [ADMIN] postgresql JDBC driver question


>
>
>I am baffled:
>
>I wrote a small java program to test postgresql jdbc driver. the applet
>runs fine locally using applet viewer. indicating that the driver is
>recognizing the url and responding to it correctly. however I get the
>message "NO suitable Driver" when the applet is run from a remote
>browser. the Class.forName("postgresql.Driver"); does not produce an
>exception leading me to believe that the Driver is found but it is not
>accepting the url (same one that worked locally)?
>
>code
>
>  String url =
>"jdbc:postgresql://godel.bioc.columbia.edu:1212/stockprices";
>  String usr = "murad";
>  String pwd = "*******";
>
>    try {
>
>      Class.forName("postgresql.Driver");
>      con = DriverManager.getConnection(url, usr, pwd); // <- this
>generates the problem
>      stmt = con.createStatement();
>
>    } catch (Exception e) {
>
>part of the html file:
><body>
>
>Enter one of the following company symbols:
>SGI, CCI, CMB. A bit of a small database I know.
>
><Applet code="JDBCtest.class" archive=postgresql.jar width=300
>height=300> </Applet>
>
>
>Thanks for the help
>
>--
>Murad Nayal M.D. Ph.D.
>Department of Biochemistry and Molecular Biophysics
>College of Physicians and Surgeons of Columbia University
>630 West 168th Street. New York, NY 10032
>Tel: 212-305-6884       Fax: 212-305-6926
>
>
>