From: thomas at tada.se (Thomas Hallgren)
Date: Tue, 11 Apr 2006 15:12:07 +0200
Subject: [Pljava-dev] Reload postgres
In-Reply-To: <443B7FA9.8070401@insa-toulouse.fr>
References: <443B7FA9.8070401@insa-toulouse.fr>
Message-ID: <443BAB27.8060103@tada.se>

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
>