| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rob Butler | 2005-04-28 14:28:09 | Re: Feature freeze date for 8.1 |
| Previous Message | Tom Lane | 2005-04-28 14:11:37 | Re: Statement Timeout and Locking |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kris Jurka | 2005-04-28 14:26:52 | Re: Array support |
| Previous Message | Tom Lane | 2005-04-28 14:11:37 | Re: Statement Timeout and Locking |