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

End of April. See: http://wiki.tada.se/display/pljava/Roadmap

- thomas

Eric BOYER wrote:
> 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
>>
>>  
>>
>