Received: from godel.bioc.columbia.edu (godel.bioc.columbia.edu
	[156.111.96.29]) by hub.org (8.9.1/8.9.1) with SMTP id WAA23046;
	Mon, 26 Oct 1998 22:33:34 -0500 (EST)
	(envelope-from murad@godel.bioc.columbia.edu)
Received: from godel.bioc.columbia.edu (localhost [127.0.0.1]) by
	godel.bioc.columbia.edu (950413.SGI.8.6.12/950213.SGI.AUTOCF)
	via ESMTP id WAA01610; Mon, 26 Oct 1998 22:34:25 -0500
Sender: murad@godel.bioc.columbia.edu
Message-ID: <36353F3F.AFDDD2F2@godel.bioc.columbia.edu>
Date: Mon, 26 Oct 1998 22:34:24 -0500
From: Murad Nayal <murad@godel.bioc.columbia.edu>
Reply-To: murad@godel.bioc.columbia.edu
Organization: Columbia University
X-Mailer: Mozilla 4.04 [en] (X11; I; IRIX 6.3 IP32)
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org, pgsql-admin@postgresql.org
Subject: postgresql JDBC driver question
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit



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