[Pljava-dev] Reload postgres

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