Skip site navigation (1) Skip section navigation (2)

Re: Statement Timeout and Locking

From: Kris Jurka <books(at)ejurka(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Markus Schaber <schabi(at)logix-tt(dot)com>,"pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Statement Timeout and Locking
Date: 2005-04-28 14:21:06
Message-ID: Pine.BSO.4.56.0504280920080.30994@leary.csoft.net (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-jdbc

On Thu, 28 Apr 2005, Tom Lane wrote:

> Markus Schaber <schabi(at)logix-tt(dot)com> writes:
> >         conn.createStatement().execute("SET statement_timeout TO 5000; LOCK TABLE exampletable IN EXCLUSIVE MODE; SET statement_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

In response to

Responses

pgsql-hackers by date

Next:From: Rob ButlerDate: 2005-04-28 14:28:09
Subject: Re: Feature freeze date for 8.1
Previous:From: Tom LaneDate: 2005-04-28 14:11:37
Subject: Re: Statement Timeout and Locking

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2005-04-28 14:26:52
Subject: Re: Array support
Previous:From: Tom LaneDate: 2005-04-28 14:11:37
Subject: Re: Statement Timeout and Locking

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group