agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feed[Pljava-dev] Reload postgres
4+ messages / 0 participants
[nested] [flat]
* [Pljava-dev] Reload postgres
@ 2006-04-11 10:06
2006-04-11 13:12 ` [Pljava-dev] Reload postgres
0 siblings, 1 reply; 4+ messages in thread
From: @ 2006-04-11 10:06 UTC (permalink / 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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* [Pljava-dev] Reload postgres
2006-04-11 10:06 [Pljava-dev] Reload postgres
@ 2006-04-11 13:12 `
2006-04-11 13:53 ` [Pljava-dev] Reload postgres
0 siblings, 1 reply; 4+ messages in thread
From: @ 2006-04-11 13:12 UTC (permalink / raw)
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
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* [Pljava-dev] Reload postgres
2006-04-11 10:06 [Pljava-dev] Reload postgres
2006-04-11 13:12 ` [Pljava-dev] Reload postgres
@ 2006-04-11 13:53 `
2006-04-11 13:54 ` [Pljava-dev] Reload postgres
0 siblings, 1 reply; 4+ messages in thread
From: @ 2006-04-11 13:53 UTC (permalink / raw)
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
>
>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* [Pljava-dev] Reload postgres
2006-04-11 10:06 [Pljava-dev] Reload postgres
2006-04-11 13:12 ` [Pljava-dev] Reload postgres
2006-04-11 13:53 ` [Pljava-dev] Reload postgres
@ 2006-04-11 13:54 `
0 siblings, 0 replies; 4+ messages in thread
From: @ 2006-04-11 13:54 UTC (permalink / raw)
End of April. See: http://wiki.tada.se/display/pljava/Roadmap
- thomas
Eric BOYER wrote:
> 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
>>
>>
>>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2006-04-11 13:54 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-04-11 10:06 [Pljava-dev] Reload postgres
2006-04-11 13:12 `
2006-04-11 13:53 `
2006-04-11 13:54 `
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox