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
>
>
>