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