agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

Subject: [Pljava-dev] Reload postgres
Date: Tue, 11 Apr 2006 12:06:33 +0200
Message-ID: <443B7FA9.8070401@insa-toulouse.fr> (raw)

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.

view thread (4+ messages)  latest in thread

Message-ID: <443B7FA9.8070401@insa-toulouse.fr>
Permalink:  ../443B7FA9.8070401@insa-toulouse.fr/
Also on:    postgresql.org/message-id/443B7FA9.8070401@insa-toulouse.fr

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pljava-dev@postgresql.org
  Subject: Re: [Pljava-dev] Reload postgres
  In-Reply-To: <443B7FA9.8070401@insa-toulouse.fr>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox