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

* JDBC & Netscape
@ 2000-01-06 11:03 Erkki Seppala <flux@inside.org>
  0 siblings, 0 replies; 6+ messages in thread

From: Erkki Seppala @ 2000-01-06 11:03 UTC (permalink / raw)
  To: pgsql-interfaces

Is it possible to run postgresql's jdbc-module under netscape? I managed
to create a simple local application (non-applet) that dumps a part of 
table, but doing the same in the applet doesn't seem to work. It can't
find the class "postgresql.Driver". 

I used 'codebase=".:postgresql.jar"' in the html, and as "postgresql.jar:."
works just as fine (it still can find the original .class) compared to just
plain "postgresql.jar", I assume this is the correct syntax.

(btw, the search engine for mailing lists at www.postgresql.org is broken)
-- 
  _____________________________________________________________________
     / __// /__ ____  __                              Erkki Seppälä\   \
    / /_ / // // /\ \/ /                       Inside Informatics ry\  /
   /_/  /_/ \___/ /_/\_\@inside.org        http://www.inside.org/~flux/



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

* RE: [INTERFACES] JDBC & Netscape
@ 2000-01-06 11:27 Peter Mount <petermount@it.maidstone.gov.uk>
  2000-01-06 11:58 ` Re: [INTERFACES] JDBC & Netscape Erkki Seppala <flux@inside.org>
  0 siblings, 1 reply; 6+ messages in thread

From: Peter Mount @ 2000-01-06 11:27 UTC (permalink / raw)
  To: 'Erkki Seppala' <flux@inside.org>; pgsql-interfaces

Note, I don't play with applets, but I know a lot of people do, but
Netscape should be fine. Only IE seems to have a problem.

the .:postgresql.jar codebase is new to me - perhaps other applet
authors can confirm if its the correct syntax. Before, people have had
to merge their classes and postgresql.jar.

If the syntax is correct, let me know, and I'll add a note about it in
the documentation.

Peter

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



-----Original Message-----
From: Erkki Seppala [mailto:flux@inside.org]
Sent: Thursday, January 06, 2000 11:03 AM
To: pgsql-interfaces@postgreSQL.org
Subject: [INTERFACES] JDBC & Netscape


Is it possible to run postgresql's jdbc-module under netscape? I managed
to create a simple local application (non-applet) that dumps a part of 
table, but doing the same in the applet doesn't seem to work. It can't
find the class "postgresql.Driver". 

I used 'codebase=".:postgresql.jar"' in the html, and as
"postgresql.jar:."
works just as fine (it still can find the original .class) compared to
just
plain "postgresql.jar", I assume this is the correct syntax.

(btw, the search engine for mailing lists at www.postgresql.org is
broken)
-- 
  _____________________________________________________________________
     / __// /__ ____  __                              Erkki Seppälä\   \
    / /_ / // // /\ \/ /                       Inside Informatics ry\  /
   /_/  /_/ \___/ /_/\_\@inside.org        http://www.inside.org/~flux/

************



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

* Re: [INTERFACES] JDBC & Netscape
  2000-01-06 11:27 RE: [INTERFACES] JDBC & Netscape Peter Mount <petermount@it.maidstone.gov.uk>
@ 2000-01-06 11:58 ` Erkki Seppala <flux@inside.org>
  0 siblings, 0 replies; 6+ messages in thread

From: Erkki Seppala @ 2000-01-06 11:58 UTC (permalink / raw)
  To: Peter Mount <petermount@it.maidstone.gov.uk>; +Cc: pgsql-interfaces

On Thu, Jan 06, 2000 at 11:27:44AM -0000, Peter Mount wrote:

> Note, I don't play with applets, but I know a lot of people do, but
> Netscape should be fine. Only IE seems to have a problem.

> the .:postgresql.jar codebase is new to me - perhaps other applet
> authors can confirm if its the correct syntax. Before, people have had
> to merge their classes and postgresql.jar.

> If the syntax is correct, let me know, and I'll add a note about it in
> the documentation.

It seems to me I made a thinko at some point: I should've had been thinking 
about 'archive' all the time, instead of 'codebase'. However, I noted an 
interesting thing: archive="foo.jar,postgresql.jar" works. I mean, this 
works:

<applet code=SqlApplet archive="sqlapplet.jar,postgresql.jar" width=100
height=100></applet>

Of course, I didn't have the class-file around why I tested it.

Don't know if that is thought to be general knowledge (according to you 
it's not?), but atleast the documentation I have doesn't reveal it.

Also, another interesting thing I noted, which is really distribution 
relevant instead of postgresql: with debian distribution of postgres, 
uncompressing and recompressing postgresql.jar shrinks it by 50% 
(from 143 kbytes to 71 kbytes).
-- 
  _____________________________________________________________________
     / __// /__ ____  __                              Erkki Seppälä\   \
    / /_ / // // /\ \/ /                       Inside Informatics ry\  /
   /_/  /_/ \___/ /_/\_\@inside.org        http://www.inside.org/~flux/



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

* RE: [INTERFACES] JDBC & Netscape
@ 2000-01-06 12:13 Peter Mount <petermount@it.maidstone.gov.uk>
  2000-01-06 12:24 ` Re: [INTERFACES] JDBC & Netscape Erkki Seppala <flux@inside.org>
  0 siblings, 1 reply; 6+ messages in thread

From: Peter Mount @ 2000-01-06 12:13 UTC (permalink / raw)
  To: 'Erkki Seppala' <flux@inside.org>; Peter Mount <petermount@it.maidstone.gov.uk>; +Cc: pgsql-interfaces

Comments below prefixed by PM: (I hate outlook)

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



-----Original Message-----
From: Erkki Seppala [mailto:flux@inside.org]
Sent: Thursday, January 06, 2000 11:59 AM
To: Peter Mount
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] JDBC & Netscape

PM: [snip]

<applet code=SqlApplet archive="sqlapplet.jar,postgresql.jar" width=100
height=100></applet>

Of course, I didn't have the class-file around why I tested it.

Don't know if that is thought to be general knowledge (according to you 
it's not?), but atleast the documentation I have doesn't reveal it.

PM: Well, it's been about 3 years since I wrote an applet, but I haven't
seen it before. It would be useful if this was possible.

Also, another interesting thing I noted, which is really distribution 
relevant instead of postgresql: with debian distribution of postgres, 
uncompressing and recompressing postgresql.jar shrinks it by 50% 
(from 143 kbytes to 71 kbytes).

PM: Hmmm, .jar files shouldn't be compressed. They are basically
uncompressed zip files (-0) and the spec states that they must never be
compressed. Perhaps its a quirk of either the jar tool the debian
maintainer used, or the browser just simply handles compressed jar
files.

-- 
  _____________________________________________________________________
     / __// /__ ____  __                              Erkki Seppälä\   \
    / /_ / // // /\ \/ /                       Inside Informatics ry\  /
   /_/  /_/ \___/ /_/\_\@inside.org        http://www.inside.org/~flux/



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

* Re: [INTERFACES] JDBC & Netscape
  2000-01-06 12:13 RE: [INTERFACES] JDBC & Netscape Peter Mount <petermount@it.maidstone.gov.uk>
@ 2000-01-06 12:24 ` Erkki Seppala <flux@inside.org>
  0 siblings, 0 replies; 6+ messages in thread

From: Erkki Seppala @ 2000-01-06 12:24 UTC (permalink / raw)
  To: Peter Mount <petermount@it.maidstone.gov.uk>; +Cc: pgsql-interfaces

On Thu, Jan 06, 2000 at 12:13:16PM -0000, Peter Mount wrote:

> PM: Hmmm, .jar files shouldn't be compressed. They are basically
> uncompressed zip files (-0) and the spec states that they must never be
> compressed. Perhaps its a quirk of either the jar tool the debian
> maintainer used, or the browser just simply handles compressed jar
> files.

Well, this is what jdk-1.1 jar does:

[14:18] lectric(pts/8):~% dd if=/dev/zero of=foo bs=1M count=1
1+0 records in
1+0 records out
[14:18] lectric(pts/8):~% jar cvf foo.jar foo
adding: foo (in=1048576) (out=1033) (deflated 99%)
[14:18] lectric(pts/8):~% ls -l foo.jar
-rw-rw-r--    1 flux     flux         1417 Jan  6 14:18 foo.jar

And that's the official jdk by Sun. Perhaps things have changed between 1.0
and 1.1? Netscape 4.7 handles it ok. I suspect that the original package
made for Debian might be created without compression, but still du -b of the
contents after extracting the original postgresql.jar is more than the size
of the original .jar.. (160768 bytes compared to 143506 bytes)
-- 
  _____________________________________________________________________
     / __// /__ ____  __                              Erkki Seppälä\   \
    / /_ / // // /\ \/ /                       Inside Informatics ry\  /
   /_/  /_/ \___/ /_/\_\@inside.org        http://www.inside.org/~flux/



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

* RE: [INTERFACES] JDBC & Netscape
@ 2000-01-06 12:27 Peter Mount <petermount@it.maidstone.gov.uk>
  0 siblings, 0 replies; 6+ messages in thread

From: Peter Mount @ 2000-01-06 12:27 UTC (permalink / raw)
  To: 'Erkki Seppala' <flux@inside.org>; Peter Mount <petermount@it.maidstone.gov.uk>; +Cc: pgsql-interfaces

Hmmm, I thought jar only appeared in 1.1. I'll have to double check the
docs.

Peter

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



-----Original Message-----
From: Erkki Seppala [mailto:flux@inside.org]
Sent: Thursday, January 06, 2000 12:24 PM
To: Peter Mount
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] JDBC & Netscape


On Thu, Jan 06, 2000 at 12:13:16PM -0000, Peter Mount wrote:

> PM: Hmmm, .jar files shouldn't be compressed. They are basically
> uncompressed zip files (-0) and the spec states that they must never
be
> compressed. Perhaps its a quirk of either the jar tool the debian
> maintainer used, or the browser just simply handles compressed jar
> files.

Well, this is what jdk-1.1 jar does:

[14:18] lectric(pts/8):~% dd if=/dev/zero of=foo bs=1M count=1
1+0 records in
1+0 records out
[14:18] lectric(pts/8):~% jar cvf foo.jar foo
adding: foo (in=1048576) (out=1033) (deflated 99%)
[14:18] lectric(pts/8):~% ls -l foo.jar
-rw-rw-r--    1 flux     flux         1417 Jan  6 14:18 foo.jar

And that's the official jdk by Sun. Perhaps things have changed between
1.0
and 1.1? Netscape 4.7 handles it ok. I suspect that the original package
made for Debian might be created without compression, but still du -b of
the
contents after extracting the original postgresql.jar is more than the
size
of the original .jar.. (160768 bytes compared to 143506 bytes)
-- 
  _____________________________________________________________________
     / __// /__ ____  __                              Erkki Seppälä\   \
    / /_ / // // /\ \/ /                       Inside Informatics ry\  /
   /_/  /_/ \___/ /_/\_\@inside.org        http://www.inside.org/~flux/



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


end of thread, other threads:[~2000-01-06 12:27 UTC | newest]

Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-01-06 11:03 JDBC & Netscape Erkki Seppala <flux@inside.org>
2000-01-06 11:27 RE: [INTERFACES] JDBC & Netscape Peter Mount <petermount@it.maidstone.gov.uk>
2000-01-06 11:58 ` Erkki Seppala <flux@inside.org>
2000-01-06 12:13 RE: [INTERFACES] JDBC & Netscape Peter Mount <petermount@it.maidstone.gov.uk>
2000-01-06 12:24 ` Erkki Seppala <flux@inside.org>
2000-01-06 12:27 RE: [INTERFACES] JDBC & Netscape 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