agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feed[Pljava-dev] Jars as blobs
4+ messages / 0 participants
[nested] [flat]
* [Pljava-dev] Jars as blobs
@ 2005-03-07 22:17
0 siblings, 1 reply; 4+ messages in thread
From: @ 2005-03-07 22:17 UTC (permalink / raw)
Has anyone considered storing jar files as blobs and a modified
classloader to read from this table? This would make deployment much
easier as file system access to the database would not be required. I
was just wanting to check with everyone first to make sure there is
not something obvious that I am missing before I start work. Any
ideas?
Thanks,
Stephen
(Please CC responses as I am not subscribed to the list)
^ permalink raw reply [nested|flat] 4+ messages in thread
* [Pljava-dev] Jars as blobs
@ 2005-03-07 22:29
parent:
0 siblings, 1 reply; 4+ messages in thread
From: @ 2005-03-07 22:29 UTC (permalink / raw)
Stephen Crowley wrote:
>Has anyone considered storing jar files as blobs and a modified
>classloader to read from this table? This would make deployment much
>easier as file system access to the database would not be required. I
>was just wanting to check with everyone first to make sure there is
>not something obvious that I am missing before I start work. Any
>ideas?
>
>
You are missing something obvious :-)
Jar files are already loaded and stored in the database today using the
install_jar, replace_jar, and remove_jar function calls. The only jar
that is stored in the filesystem is the pljava.jar. Among other things,
that jar contains the table based classloader which explains why it has
to be loaded from the file system.
The CLASSPATH visible to the postmaster (or configured using
pljava.classpath) should *only* appoint the pljava.jar. All other jars
(short of the ones in the JVM bootclasspath path of course) should be
loaded into the database.
Regards,
Thomas Hallgren
^ permalink raw reply [nested|flat] 4+ messages in thread
* [Pljava-dev] Jars as blobs
@ 2005-03-07 22:34
parent:
0 siblings, 1 reply; 4+ messages in thread
From: @ 2005-03-07 22:34 UTC (permalink / raw)
Oh. That would explain a lot :) Where is the jar data actually stored
when install_jar is called? Also, install_jar takes a file url as a
parameter so the file still has to be on the server. How much work
would it take to make install_jar accept a blob as a parameter so jars
could be installed remotely instead of copying files back to the
server each time?
--Stephen
On Mon, 07 Mar 2005 23:29:18 +0100, Thomas Hallgren
<thhal at mailblocks.com> wrote:
> Stephen Crowley wrote:
>
> >Has anyone considered storing jar files as blobs and a modified
> >classloader to read from this table? This would make deployment much
> >easier as file system access to the database would not be required. I
> >was just wanting to check with everyone first to make sure there is
> >not something obvious that I am missing before I start work. Any
> >ideas?
> >
> >
> You are missing something obvious :-)
> Jar files are already loaded and stored in the database today using the
> install_jar, replace_jar, and remove_jar function calls. The only jar
> that is stored in the filesystem is the pljava.jar. Among other things,
> that jar contains the table based classloader which explains why it has
> to be loaded from the file system.
>
> The CLASSPATH visible to the postmaster (or configured using
> pljava.classpath) should *only* appoint the pljava.jar. All other jars
> (short of the ones in the JVM bootclasspath path of course) should be
> loaded into the database.
>
> Regards,
> Thomas Hallgren
>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* [Pljava-dev] Jars as blobs
@ 2005-03-07 22:42
parent:
0 siblings, 0 replies; 4+ messages in thread
From: @ 2005-03-07 22:42 UTC (permalink / raw)
Stephen Crowley wrote:
>Oh. That would explain a lot :) Where is the jar data actually stored
>when install_jar is called?
>
In the tables sqlj.jar_repository and sqlj.jar_entry
> Also, install_jar takes a file url as a
>parameter so the file still has to be on the server.
>
No, the url is not limited to file. It might just as well be an url
starting with ftp:// or http://.
> How much work
>would it take to make install_jar accept a blob as a parameter so jars
>could be installed remotely instead of copying files back to the
>server each time?
>
>
Not much. It would be fairly simple to implement. Please add a feature
request on this.
Regards,
Thomas Hallgren
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2005-03-07 22:42 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-03-07 22:17 [Pljava-dev] Jars as blobs
2005-03-07 22:29 `
2005-03-07 22:34 `
2005-03-07 22:42 `
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox