public inbox for [email protected]help / color / mirror / Atom feed
[Pljava-dev] How to cancel a trigger operation 5+ messages / 0 participants [nested] [flat]
* [Pljava-dev] How to cancel a trigger operation @ 2010-03-15 20:22 2010-03-16 09:35 ` [Pljava-dev] How to cancel a trigger operation 0 siblings, 1 reply; 5+ messages in thread From: @ 2010-03-15 20:22 UTC (permalink / raw) HI all, Some of you knows how to cancel a trigger operation (insert, delete or update) from a trigger function in PLJAVA? In PLPGSQL I know I can get it returning a null value. I tried several things in PLJAVA but i couldnt make it. Thanx a lot, Best, Jose Martinez _________________________________________________________________ Recibe en tu m?vil un SMS con tu Hotmail recibido. ?Date de alta ya! http://serviciosmoviles.es.msn.com/ -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20100315/44b16d0d/attachment.html; ^ permalink raw reply [nested|flat] 5+ messages in thread
* [Pljava-dev] How to cancel a trigger operation 2010-03-15 20:22 [Pljava-dev] How to cancel a trigger operation @ 2010-03-16 09:35 ` 0 siblings, 0 replies; 5+ messages in thread From: @ 2010-03-16 09:35 UTC (permalink / raw) Hi Andres, Thanks for the answer. Throwing an exception works but not in the way i need because the transaction is aborted. I was looking for something that I already read in this list: http://pgfoundry.org/pipermail/pljava-dev/2006/001000.html http://pgfoundry.org/pipermail/pljava-dev/2006/001001.html I was expecting someone already fixed that bug (i think its a bug because we can not use triggers in a proper way) because these posts are from 4 years ago. Has someone already worked in this bug? Thanks to all, Best, Jose _________________________________________________________________ ?Te gustar?a tener Hotmail en tu m?vil Movistar? ?Es gratis! http://serviciosmoviles.es.msn.com/hotmail/movistar-particulares.aspx -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20100316/895e5b7a/attachment.html; ^ permalink raw reply [nested|flat] 5+ messages in thread
* [Pljava-dev] how to cancel a trigger operation @ 2010-03-19 15:02 2010-03-19 15:31 ` [Pljava-dev] how to cancel a trigger operation 0 siblings, 1 reply; 5+ messages in thread From: @ 2010-03-19 15:02 UTC (permalink / raw) Hi all, Im sending this email again to the list because I really need to get an answer for the pljava developers or someone who can help me. Im wondering how to cancel a trigger operation. Throwing an exception works but not in the way i need because the transaction is aborted. I was looking for something that I already read in this list: http://pgfoundry.org/pipermail/pljava-dev/2006/001000.html http://pgfoundry.org/pipermail/pljava-dev/2006/001001.html I was expecting someone already fixed that bug (i think its a bug because we can not use triggers in a proper way) because these posts are from 4 years ago. Has someone already worked in this bug? Thanks to all, Best, Jose _________________________________________________________________ Escucha a quienes ya han probado Windows 7 ?Hazlo aqu?! http://www.sietesunpueblodeexpertos.com/index_windows7.html -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20100319/94704cf9/attachment.html; ^ permalink raw reply [nested|flat] 5+ messages in thread
* [Pljava-dev] how to cancel a trigger operation 2010-03-19 15:02 [Pljava-dev] how to cancel a trigger operation @ 2010-03-19 15:31 ` 2010-03-19 15:48 ` [Pljava-dev] how to cancel a trigger operation 0 siblings, 1 reply; 5+ messages in thread From: @ 2010-03-19 15:31 UTC (permalink / raw) I'll bite. Why are you using triggers? Why are you using Java for the trigger code? Jon From: pljava-dev-bounces at pgfoundry.org [mailto:pljava-dev-bounces at pgfoundry.org] On Behalf Of JOSE CARLOS MARTINEZ LLARIO Sent: Friday, March 19, 2010 10:02 AM To: pljava-dev at pgfoundry.org Subject: [Pljava-dev] how to cancel a trigger operation Hi all, Im sending this email again to the list because I really need to get an answer for the pljava developers or someone who can help me. Im wondering how to cancel a trigger operation. Throwing an exception works but not in the way i need because the transaction is aborted. I was looking for something that I already read in this list: http://pgfoundry.org/pipermail/pljava-dev/2006/001000.html http://pgfoundry.org/pipermail/pljava-dev/2006/001001.html I was expecting someone already fixed that bug (i think its a bug because we can not use triggers in a proper way) because these posts are from 4 years ago. Has someone already worked in this bug? Thanks to all, Best, Jose ________________________________ Actual?zate gratis al nuevo Internet Explorer 8 y navega m?s seguro <http://www.microsoft.com/spain/windows/internet-explorer/default.aspx; -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20100319/c55b35e9/attachment.html; ^ permalink raw reply [nested|flat] 5+ messages in thread
* [Pljava-dev] how to cancel a trigger operation 2010-03-19 15:02 [Pljava-dev] how to cancel a trigger operation 2010-03-19 15:31 ` [Pljava-dev] how to cancel a trigger operation @ 2010-03-19 15:48 ` 0 siblings, 0 replies; 5+ messages in thread From: @ 2010-03-19 15:48 UTC (permalink / raw) Hi Jon, for many reasons: -All my project is java. It is a spatial extension for postgres and h2 -plpgsql is not working because i need to know the column names so i can use NEW.something or OLD.something..so and other stuff i have to use C or plpython or Pljava -pljava works perfect with triggers but it has the problem i mentioned so my question is related just with PLJAVA and Triggers. I already know how to solve that in C or other pl languages. Cheers, Jose Subject: RE: [Pljava-dev] how to cancel a trigger operation Date: Fri, 19 Mar 2010 10:31:45 -0500 From: Jon.Roberts at asurion.com To: jcllario at hotmail.com; pljava-dev at pgfoundry.org I?ll bite. Why are you using triggers? Why are you using Java for the trigger code? Jon From: pljava-dev-bounces at pgfoundry.org [mailto:pljava-dev-bounces at pgfoundry.org] On Behalf Of JOSE CARLOS MARTINEZ LLARIO Sent: Friday, March 19, 2010 10:02 AM To: pljava-dev at pgfoundry.org Subject: [Pljava-dev] how to cancel a trigger operation Hi all, Im sending this email again to the list because I really need to get an answer for the pljava developers or someone who can help me. Im wondering how to cancel a trigger operation. Throwing an exception works but not in the way i need because the transaction is aborted. I was looking for something that I already read in this list: http://pgfoundry.org/pipermail/pljava-dev/2006/001000.html http://pgfoundry.org/pipermail/pljava-dev/2006/001001.html I was expecting someone already fixed that bug (i think its a bug because we can not use triggers in a proper way) because these posts are from 4 years ago. Has someone already worked in this bug? Thanks to all, Best, Jose Actual?zate gratis al nuevo Internet Explorer 8 y navega m?s seguro _________________________________________________________________ ?Te gustar?a tener Hotmail en tu m?vil Movistar? ?Es gratis! http://serviciosmoviles.es.msn.com/hotmail/movistar-particulares.aspx -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20100319/7b29364b/attachment.html; ^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2010-03-19 15:48 UTC | newest] Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2010-03-15 20:22 [Pljava-dev] How to cancel a trigger operation 2010-03-16 09:35 ` 2010-03-19 15:02 [Pljava-dev] how to cancel a trigger operation 2010-03-19 15:31 ` [Pljava-dev] how to cancel a trigger operation 2010-03-19 15:48 ` [Pljava-dev] how to cancel a trigger operation
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox