Re: stored function, multiple queries, best practices

From: "Guy Rouillier" <guyr(at)masergy(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: stored function, multiple queries, best practices
Date: 2006-04-18 20:19:16
Message-ID: CC1CF380F4D70844B01D45982E671B230137A89F@mtxexch01.add0.masergy.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Ash Grove wrote:

> I can only call one function (from the application)
> per transaction, right?

Incorrect. Transactions are delimited by commits or rollbacks, not by
function calls or SQL statements (more correctly, DML.) If you want to
control your commit points, tell JDBC to "conn.setAutocommit(false)".

--
Guy Rouillier

Browse pgsql-jdbc by date

  From Date Subject
Next Message Ed Blackmore 2006-04-19 17:21:58 Re: connection reset error, followed by broken pipe (pg74.213.jdbc3.jar)
Previous Message Ash Grove 2006-04-18 18:53:51 Re: stored function, multiple queries, best practices