[Pljava-dev] Reload postgres
Eric BOYER
Eric.Boyer at insa-toulouse.fr
Tue Apr 11 10:06:33 UTC 2006
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.
More information about the Pljava-dev
mailing list