Postgres Pro
Downloads
Home   >   mailing lists

Re: stored function, multiple queries, best practices - Mailing list pgsql-jdbc

From Guy Rouillier
Subject Re: stored function, multiple queries, best practices
Date
Msg-id CC1CF380F4D70844B01D45982E671B230137A89F@mtxexch01.add0.masergy.com
Whole thread Raw
In response to stored function, multiple queries, best practices  (Ash Grove <ash_grv7@yahoo.com>)
List pgsql-jdbc
Tree view 
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

pgsql-jdbc by date:

Previous
From: Ash Grove
Date:
Subject: Re: stored function, multiple queries, best practices
Next
From: "Ed Blackmore"
Date:
Subject: Re: connection reset error, followed by broken pipe (pg74.213.jdbc3.jar)