Hi, I read you problem in digest version. So I can't reply directly.

I think the major problem is that you haven't download the JDBC driver
to the client side!
So the browser try to load the driver from the server side. However, the
server try to find and load the driver from the server classpath.

convert your html and load the postgresql JDBC driver to the client
<applet code="sppform5.class" archive="postgresql.jar,spp5.jar"
width=800 height=400>

^^^^^^^^^^

And there is one limitation. It is the connection URL.
For example:
On the browser, your URL is http://localhost/~bennett/sppform5.html
you can only connect your database with
jdbc:postgresql://localhost/testdb
or
On the browser, your URL is
http://192.XXX.XXX.XXX/~bennett/sppform5.html
you can only connect your database with
jdbc:postgresql://192.XXX.XXX.XXX/testdb

This mean your web server and database server must be running on the
same machine!

If you want to separate the two server on two machine, you can't have
JDBC connection directly with the database server over LAN/Internet.
(especially via firewall)

If I were you, I will use Applet-Servlet communication. I now use it for
my final year project and it works fine.
The Applet can use ObjectInputStream/ObjectOutputStream to receive/send
pure java objects with the Servlet. And the Servlet communicate with the
database server which is located on the same network. Therefore, most of
the network problem can be solved. And also the
postgresql.jar(jdbc6_4.jar) is very large(over 100KB) for Internet
client. Using Applet-Servlet communication for your work, your clients
don't need to download the JDBC driver.

I use Linux as the server and every os which have Java Plug-in 1.2 as
the client in my final year project.(cos I am using Swing. It make my
applet more beautiful)

Bennett.

begin:vcard 
n:Yip;Bennett
x-mozilla-html:FALSE
adr:;;;;;;
version:2.1
email;internet:[EMAIL PROTECTED]
x-mozilla-cpt:;19904
fn:Bennett Yip
end:vcard

Reply via email to