View Single Post

   
  #5 (permalink)  
Old 04-16-2008, 12:59 AM
Francesco Storti
 
Posts: n/a
Default Re: Problem calling stored function

2008/1/18, Oliver Jowett <oliver@opencloud.com>:
>
> Francesco Storti wrote:
> > 2008/1/17, Tom Lane tgl@sss.pgh.pa.us <mailto:tgl@sss.pgh.pa.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!

Reply With Quote