Sender: root@setserv.setech.com
Message-ID: <35A67102.A6B767BE@setech.com>
Date: Fri, 10 Jul 1998 15:52:34 -0400
From: Jeffrey Napolitano <jnapoli@setech.com>
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: JDBC drivers
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

I have two programs:

one which I run via : java JavaProgram
	which connects to the Postgresql database, and puts stuff in, etc.
one which I run via a webserver - an applet, which is called in an html
	document, and attempts to access a Postgresql database.

Both programs load the driver via "Class.forName("postgresql.Driver")",
and use DriverManager.getConnection - however, the first one, the
application, apparently finds the postgresql.Driver via its CLASSPATH.
The second one, the applet, does not HAVE a CLASSPATH because it is
invoked by the web server, and therefore returns "cannot find suitable
driver".

I have put postgresql.jar (the JDBC driver) in the directory that the
applet is being executed, but it is still not found.

There must be a way to use a JDBC driver with applets, right?
Unfortunately, I don't know how to which is environment variable
"independent"...anyone?

------------------ 
Jeffrey Napolitano
Lowly Intern
Software Emancipation Technology