Re: [JDBC] Problem calling stored function

From: Oliver Jowett <oliver(at)opencloud.com>
Date: Fri Jan 18 2008 - 06:56:00 EST

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

---------------------------(end of broadcast)---------------------------

TIP 4: Have you searched our list archives?

               http://archives.postgresql.org Received on Fri Jan 18 06:57:59 2008