agora inbox for pljava-dev@postgresql.org  
help / color / mirror / Atom feed
Subject: [Pljava-dev] classloading
Date: Mon, 04 Feb 2013 18:16:49 +0100
Message-ID: <510FED01.1050705@tada.se> (raw)
In-Reply-To: <CALdd-zjJq96J3Xwsd8G0bimdZi=Sq-kbLqWGVhVzefkbcG1pCg@mail.gmail.com>
References: <CALdd-zjJq96J3Xwsd8G0bimdZi=Sq-kbLqWGVhVzefkbcG1pCg@mail.gmail.com>

Hi Jonathan,

Not sure what you mean with "reloading jars". PL/Java will give you a 
JVM session that is dedicated to your session (i.e. the database 
connection). What classes you have access to is normally something that 
someone with super privileges has decided earlier by installing jars and 
declaring the class paths. Letting normal users do this would IMO be 
dangerous. The same is true for other types of stored procedures and 
functions.

Now, if you indeed do have super user priveliges, then there's nothing 
stopping you from changing the classpath to see different classes at 
different times. There would still be only one loader though (the one 
that uses the database and effective classpath). PL/Java will not allow 
that you load classes directly from the file system.

- thomas

On 2013-02-04 12:51, Jonathan Ellis wrote:
> Hi all,
>
> I was looking at pl/java since we're looking at doing something along
> those lines for user-defined triggers in Cassandra [1].  Slightly
> confused to only see one Loader per Schema.  Does this mean that
> reloading jars is not supported?  Curious about the design tradeoffs
> there because that sounds like something users would want.
>
> Thanks for any light you can shed here!
>
> [1] https://issues.apache.org/jira/browse/CASSANDRA-1311
>




view thread (2+ messages)

Message-ID: <510FED01.1050705@tada.se>
Permalink:  ../510FED01.1050705@tada.se/
Also on:    postgresql.org/message-id/510FED01.1050705@tada.se

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pljava-dev@postgresql.org
  Subject: Re: [Pljava-dev] classloading
  In-Reply-To: <510FED01.1050705@tada.se>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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