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