Re: Problem calling stored function

------=_Part_3917_8495371.1200657850977
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

2008/1/18, Oliver Jowett <oliver@[EMAIL PROTECTED]
>:
>
> Francesco Storti wrote:
> > 2008/1/17, Tom Lane tgl@[EMAIL PROTECTED]
 <mailto:tgl@[EMAIL PROTECTED]
>:
> >
> >
> >     Should work.  Maybe you're rolling back the transaction later, or
> >     something like that?
> >
> >                            regards, tom lane
> >
> >
> >
> > Thank for the answer first ;)
> > I use rollback only if throwed an SQL exception.
>
> You never call commit() so the transaction will be rolled back when you
> close the connection. (I'm assuming you have autocommit off, you didn't
> include your connection setup code)
>
> -O




Confirmed that I'm a newbye...
As sed by Oliver and tivvpgsqljdbc i've missed the commit ...
Thanks a lot for your help!

------=_Part_3917_8495371.1200657850977
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<br><br>
<div><span class="gmail_quote">2008/1/18, Oliver Jowett &lt;<a
href="mailto:oliver@[EMAIL PROTECTED]
">oliver@[EMAIL PROTECTED]
>&gt;:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px
0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Francesco Storti wrote:<br>&gt;
2008/1/17, Tom Lane <a
href="mailto:tgl@[EMAIL PROTECTED]
">tgl@[EMAIL PROTECTED]
>
 &lt;mailto:<a
href="mailto:tgl@[EMAIL PROTECTED]
">tgl@[EMAIL PROTECTED]
>&gt;:<br>&gt;<br>&gt;<br>&gt;&nbsp;&nbsp;&nbsp;&nbsp;
Should work.&nbsp;&nbsp;Maybe you&#39;re rolling back the transaction
later, or<br>&gt;&nbsp;&nbsp;&nbsp;&nbsp; something like
that?<br>&gt;<br>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;regards,
tom lane
<br>&gt;<br>&gt;<br>&gt;<br>&gt; Thank for the answer first ;)<br>&gt; I
use rollback only if throwed an SQL exception.<br><br>You never call
commit() so the transaction will be rolled back when you<br>close the
connection. (I&#39;m assuming you have autocommit off, you didn&#39;t
<br>include your connection setup code)<br><br>-O</blockquote>
<div>&nbsp;</div>
<div>&nbsp;</div>
<div>&nbsp;</div>
<div>Confirmed that I&#39;m a newbye...</div>
<div>As sed by Oliver and <font color="#888888">tivvpgsqljdbc i&#39;ve
missed the commit ...</font></div>
<div><font color="#888888">Thanks a lot for your
help!</font></div><br>&nbsp;</div><br>

------=_Part_3917_8495371.1200657850977--