Re: Statement Timeout and Locking

On Thu, 28 Apr 2005, Tom Lane wrote:

> Markus Schaber <schabi@logix-tt.com> writes:
> >         conn.createStatement().execute("SET statement_timeout TO 5000; LOCK TABLE exampletable IN EXCLUSIVE MODE;
SETstatement_timeout TO DEFAULT;"); 
>
> At least in more recent JDBC drivers, I'd expect the above to fail
> entirely because you can only put one SQL command per V3 Parse message.
> Try splitting it into three statements.
>

The JDBC driver splits this query itself and issues it in three queries
internally.

Kris Jurka