Re: Problem calling stored function

["Francesco Storti" <francesco(dot)storti(at)gmail(dot)com>]

2008/1/18, Oliver Jowett <oliver(at)opencloud(dot)com>:

Francesco Storti wrote:
> 2008/1/17, Tom Lane tgl(at)sss(dot)pgh(dot)pa(dot)us <mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us>:
>
>
>     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!