| From: | "Francesco Storti" <francesco(dot)storti(at)gmail(dot)com> |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org |
| Cc: | oliver(at)opencloud(dot)com |
| Subject: | Re: Problem calling stored function |
| Date: | 2008-01-18 12:04:10 |
| Message-ID: | bf6786b40801180404rf2f9df1kd354af3cf94149ea@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
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!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Albretch Mueller | 2008-01-18 17:13:50 | Re: trying to connect to pg from within a local network |
| Previous Message | Oliver Jowett | 2008-01-18 11:56:00 | Re: Problem calling stored function |