pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
a simple question about JDBC
2+ messages / 2 participants
[nested] [flat]

* a simple question about JDBC
@ 2000-04-06 08:50  Oscar Serrano <oserra@fondos.net>
  0 siblings, 0 replies; 2+ messages in thread

From: Oscar Serrano @ 2000-04-06 08:50 UTC (permalink / raw)
  To: pgsql-interfaces

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.





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* RE: a simple question about JDBC
@ 2000-04-06 10:29  Peter Mount <petermount@it.maidstone.gov.uk>
  0 siblings, 0 replies; 2+ messages in thread

From: Peter Mount @ 2000-04-06 10:29 UTC (permalink / raw)
  To: 'Oscar Serrano' <oserra@fondos.net>; 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@fondos.net]
Sent: Thursday, April 06, 2000 9:50 AM
To: pgsql-interfaces@postgreSQL.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.




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2000-04-06 10:29 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-04-06 08:50 a simple question about JDBC Oscar Serrano <oserra@fondos.net>
2000-04-06 10:29 RE: a simple question about JDBC Peter Mount <petermount@it.maidstone.gov.uk>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox