From: Eric.Boyer at insa-toulouse.fr (Eric BOYER)
Date: Tue, 11 Apr 2006 15:53:03 +0200
Subject: [Pljava-dev] Reload postgres
In-Reply-To: <443BAB27.8060103@tada.se>
References: <443B7FA9.8070401@insa-toulouse.fr> <443BAB27.8060103@tada.se>
Message-ID: <443BB4BF.8070501@insa-toulouse.fr>

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
>
>  
>