RE: a simple question about JDBC

From: Peter Mount <petermount(at)it(dot)maidstone(dot)gov(dot)uk>
To: "'Oscar Serrano'" <oserra(at)fondos(dot)net>, "pgsql-interfaces(at)postgreSQL(dot)org" <pgsql-interfaces(at)postgresql(dot)org>
Subject: RE: a simple question about JDBC
Date: 2000-04-06 10:29:23
Message-ID: 1B3D5E532D18D311861A00600865478C70C419@exchange1.nt.maidstone.gov.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Unfortunately, unless you can get the postgresql.jar file into the
browser's internal class path (which is probably unlikely), it has to be
downloaded with the applet. This is a problem with JDBC in general (not
just us).

There are ways around this, like using a servlet on the web server. Your
applet talks to it, and it then uses JDBC. You could use RMI or your own
protocol to do this.

Another method is to strip postgresql.jar of all but the critical
classes you need. Most of the time you don't need everything in there
(like the largeobject & fastpath api's). This is tricky, but it can and
has been done. (hint: Run appletviewer with class loading tracing
enabled in the vm, and note which classes are loaded).

Peter

--
Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council.

-----Original Message-----
From: Oscar Serrano [mailto:oserra(at)fondos(dot)net]
Sent: Thursday, April 06, 2000 9:50 AM
To: pgsql-interfaces(at)postgreSQL(dot)org
Subject: [INTERFACES] a simple question about JDBC

I use Borland Jbuilder 3 Standard to create an applet that connects to a
postgress database via ODBC.
In the Jbuilder I have to configure where the postgresql.jar file is
located.

But is it really necesary to put the parameter ARCHIVE=postgresql.jar in
the
APPLET definition?
I mean, to make run the applet I've done, I must put this in the html
file:

<applet code="gijdbc.class" width=630 height=400
archive="postgresql.jar">

But that means, that every body must download the postgresql.jar file
before
the .class file. And it is 130kbs :-O

Is there any way to integrate the postgresql.jar into the .class or
something so?

Thank you very much.

Browse pgsql-interfaces by date

  From Date Subject
Next Message Moray McConnachie 2000-04-06 11:09:11 Re: a trigger that sends an email + returning multiple records
Previous Message Oscar Serrano 2000-04-06 08:50:20 a trigger that sends an email