<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
--></style>
</head>
<body class='hmmessage'>
Hi Jon, for many reasons:<br><br>-All my project is java. It is a spatial extension for postgres and h2<br>-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<br> i have to use C or plpython or Pljava<br>-pljava works perfect with triggers but it has the problem i mentioned<br><br>so my question is related just with PLJAVA and Triggers. I already know how to solve that in C or other pl languages.<br>Cheers,<br>Jose<br><br><hr id="stopSpelling">Subject: RE: [Pljava-dev] how to cancel a trigger operation<br>Date: Fri, 19 Mar 2010 10:31:45 -0500<br>From: Jon.Roberts@asurion.com<br>To: jcllario@hotmail.com; pljava-dev@pgfoundry.org<br><br>
<style>
.ExternalClass .ecxshape
{;}
</style>
<style>
.ExternalClass p.ecxMsoNormal, .ExternalClass li.ecxMsoNormal, .ExternalClass div.ecxMsoNormal
{margin-bottom:.0001pt;font-size:12.0pt;font-family:'Times New Roman','serif';}
.ExternalClass a:link, .ExternalClass span.ecxMsoHyperlink
{color:blue;text-decoration:underline;}
.ExternalClass a:visited, .ExternalClass span.ecxMsoHyperlinkFollowed
{color:purple;text-decoration:underline;}
.ExternalClass p
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:'Times New Roman','serif';}
.ExternalClass pre
{margin-bottom:.0001pt;font-size:10.0pt;font-family:'Courier New';}
.ExternalClass span.ecxHTMLPreformattedChar
{font-family:Consolas;}
.ExternalClass span.ecxEmailStyle20
{font-family:'Calibri','sans-serif';color:#1F497D;}
.ExternalClass .ecxMsoChpDefault
{font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;}
.ExternalClass div.ecxSection1
{page:Section1;}
</style>
<div class="ecxSection1">
<p class="ecxMsoNormal"><span style="font-size: 11pt; font-family: 'Calibri','sans-serif'; color: rgb(31, 73, 125);">I’ll bite. Why are you using triggers? Why are you using Java
for the trigger code?</span></p>
<p class="ecxMsoNormal"><span style="font-size: 11pt; font-family: 'Calibri','sans-serif'; color: rgb(31, 73, 125);"> </span></p>
<p class="ecxMsoNormal"><span style="font-size: 11pt; font-family: 'Calibri','sans-serif'; color: rgb(31, 73, 125);"> </span></p>
<p class="ecxMsoNormal"><span style="font-size: 11pt; font-family: 'Calibri','sans-serif'; color: rgb(31, 73, 125);">Jon</span></p>
<p class="ecxMsoNormal"><span style="font-size: 11pt; font-family: 'Calibri','sans-serif'; color: rgb(31, 73, 125);"> </span></p>
<div>
<div style="border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0in 0in;">
<p class="ecxMsoNormal"><b><span style="font-size: 10pt; font-family: 'Tahoma','sans-serif';">From:</span></b><span style="font-size: 10pt; font-family: 'Tahoma','sans-serif';"> pljava-dev-bounces@pgfoundry.org
[mailto:pljava-dev-bounces@pgfoundry.org] <b>On Behalf Of </b>JOSE CARLOS
MARTINEZ LLARIO<br>
<b>Sent:</b> Friday, March 19, 2010 10:02 AM<br>
<b>To:</b> pljava-dev@pgfoundry.org<br>
<b>Subject:</b> [Pljava-dev] how to cancel a trigger operation</span></p>
</div>
</div>
<p class="ecxMsoNormal"> </p>
<pre>Hi all, Im sending this email again to the list because I really need to get an answer for<br><br>the pljava developers or someone who can help me.<br><br> <br><br>Im wondering how to cancel a trigger operation.<br><br><br><br>Throwing an exception works but not in the way i need because the transaction is aborted.<br><br> <br><br>I was looking for something that I already read in this list:<br><br> <br><br><a href="http://pgfoundry.org/pipermail/pljava-dev/2006/001000.html">http://pgfoundry.org/pipermail/pljava-dev/2006/001000.html</a><br><br><a href="http://pgfoundry.org/pipermail/pljava-dev/2006/001001.html">http://pgfoundry.org/pipermail/pljava-dev/2006/001001.html</a><br><br> <br><br>I was expecting someone already fixed that bug (i think its a bug because we can not use triggers in a proper way) because<br><br>these posts are from 4 years ago. <br><br> <br><br>Has someone already worked in this bug?<br><br> <br><br>Thanks to all,<br><br>Best,<br><br>Jose<br><br> </pre>
<p class="ecxMsoNormal"><span style="font-size: 10pt; font-family: 'Verdana','sans-serif';"> </span></p>
<div class="ecxMsoNormal" style="text-align: center;" align="center"><span style="font-size: 10pt; font-family: 'Verdana','sans-serif';">
<hr align="center" size="2" width="100%">
</span></div>
<p class="ecxMsoNormal"><span style="font-size: 10pt; font-family: 'Verdana','sans-serif';">Actualízate
gratis al nuevo Internet Explorer 8 y <a href="http://www.microsoft.com/spain/windows/internet-explorer/default.aspx">navega más seguro</a></span></p>
</div> <br /><hr />¿Quieres saber qué móvil eres? <a href='http://www.quemovileres.com/' target='_new'>¡Descúbrelo aquí!</a></body>
</html>