[Pljava-dev] Reload postgres

From: Eric(dot)Boyer at insa-toulouse(dot)fr (Eric BOYER)
To:
Subject: [Pljava-dev] Reload postgres
Date: 2006-04-11 10:06:33
Message-ID: 443B7FA9.8070401@insa-toulouse.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pljava-dev

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.

Responses

Browse pljava-dev by date

  From Date Subject
Next Message Thomas Hallgren 2006-04-11 13:12:07 [Pljava-dev] Reload postgres
Previous Message Thomas Hallgren 2006-04-11 08:08:16 [Pljava-dev] out of memory