Re: Statement Timeout and Locking - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Statement Timeout and Locking
Date
Msg-id Pine.BSO.4.56.0504280920080.30994@leary.csoft.net
Whole thread Raw
In response to Re: Statement Timeout and Locking  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Statement Timeout and Locking
List pgsql-jdbc

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

pgsql-jdbc by date:

Previous
From: Tom Lane
Date:
Subject: Re: Statement Timeout and Locking
Next
From: Kris Jurka
Date:
Subject: Re: Array support