agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feedSubject: [Pljava-dev] Reload postgres
Date: Tue, 11 Apr 2006 15:53:03 +0200
Message-ID: <443BB4BF.8070501@insa-toulouse.fr> (raw)
In-Reply-To: <443BAB27.8060103@tada.se>
References: <443B7FA9.8070401@insa-toulouse.fr>
<443BAB27.8060103@tada.se>
Yes !
It's this bugs ...
When do you think this 1.3 will be available
Thanks
Eric
Thomas Hallgren a ?crit :
>Hi Eric,
>When you say "restart postgres" I assume you mean drop and reestablish
>the connection? This is fixed in the coming PL/Java 1.3 release. See
>bug: http://gborg.postgresql.org/project/pljava/bugs/bugupdate.php?1531.
>
>If you feel adventurous, the latest snapshots can be found here:
>
>http://eng.tada.se/pljava
>
>Kind Regards,
>Thomas Hallgren
>
>Eric BOYER wrote:
>
>
>>Hello,
>>
>>I would like to don't have to restart postgres every times I change the
>>class launched ...
>>
>>I use :
>>select
>>sqlj.install_jar('file:///usr/local/aladin/jars/trigger_exploitation.jar','aladin',true);
>>select sqlj.set_classpath('exploitation','aladin');
>>or
>>select
>>sqlj.replace_jar('file:///usr/local/aladin/jars/trigger_exploitation.jar','aladin',true);
>>
>>the content of the jar is :
>> 0 Tue Apr 11 11:47:54 CEST 2006 META-INF/
>> 174 Tue Apr 11 11:47:52 CEST 2006 META-INF/MANIFEST.MF
>> 0 Tue Apr 11 11:17:24 CEST 2006 deployment/
>> 628 Tue Apr 11 11:17:24 CEST 2006 deployment/triggerExpl.ddr
>> 89 Mon Apr 10 10:52:50 CEST 2006 deployment/triggerExpl.manifest
>> 0 Mon Apr 10 15:35:22 CEST 2006 fr/
>> 0 Mon Apr 10 15:35:22 CEST 2006 fr/insat/
>> 0 Mon Apr 10 15:35:26 CEST 2006 fr/insat/aladin/
>> 0 Mon Apr 10 15:35:24 CEST 2006 fr/insat/aladin/service/
>> 600 Tue Apr 11 11:47:50 CEST 2006
>>fr/insat/aladin/service/TriggerClient$1.class
>> 11658 Tue Apr 11 11:47:50 CEST 2006
>>fr/insat/aladin/service/TriggerClient.class
>>
>>
>>When I change TriggerClient.java, I have to restart postgres !
>>
>>What do I have to do for only use sqlj.replace_jar ?
>>
>>Thanks,
>>Eric.
>>
>>PS
>>My ddr is :
>>SQLActions[ ] = {
>> "BEGIN INSTALL
>>
>> CREATE FUNCTION exploitation.alloTrigger()
>> RETURNS trigger
>> AS 'fr.insat.aladin.service.TriggerClient.traiter'
>> LANGUAGE javaU;
>>
>> CREATE TRIGGER trigCategorie
>> AFTER INSERT OR UPDATE OR DELETE ON
>>exploitation.categorie
>> FOR EACH ROW
>> EXECUTE PROCEDURE exploitation.alloTrigger ();
>> END INSTALL",
>>
>> "BEGIN REMOVE
>> DROP FUNCTION exploitation.alloTrigger() CASCADE;
>> END REMOVE"
>> }
>>
>>I really need javaU.
>>_______________________________________________
>>Pljava-dev mailing list
>>Pljava-dev at gborg.postgresql.org
>>http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>>
>>
>>
>
>_______________________________________________
>Pljava-dev mailing list
>Pljava-dev at gborg.postgresql.org
>http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>
>
>
view thread (4+ messages) latest in thread
Message-ID: <443BB4BF.8070501@insa-toulouse.fr>
Permalink: ../443BB4BF.8070501@insa-toulouse.fr/
Also on: postgresql.org/message-id/443BB4BF.8070501@insa-toulouse.fr
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] Reload postgres
In-Reply-To: <443BB4BF.8070501@insa-toulouse.fr>
* 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