postgresql JDBC driver question

From: Murad Nayal <murad(at)godel(dot)bioc(dot)columbia(dot)edu>
To: pgsql-interfaces(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
Subject: postgresql JDBC driver question
Date: 1998-10-27 03:34:24
Message-ID: 36353F3F.AFDDD2F2@godel.bioc.columbia.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-interfaces

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

Browse pgsql-admin by date

  From Date Subject
Next Message Laurent Gaches 1998-10-27 22:21:30 (no subject)
Previous Message Doug Smith 1998-10-26 18:11:13 LEFT,RIGHT,SUBSTR

Browse pgsql-interfaces by date

  From Date Subject
Next Message Andrea Antibo 1998-10-27 06:21:02 Re: [INTERFACES] applet don't go
Previous Message Brenda Butler 1998-10-27 02:19:47