Re: [JDBC] 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! Received on Fri Jan 18 07:06:13 2008