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

From Tom Lane
Subject Re: Statement Timeout and Locking
Date
Msg-id 11053.1114697497@sss.pgh.pa.us
Whole thread Raw
In response to Statement Timeout and Locking  (Markus Schaber <schabi@logix-tt.com>)
Responses Re: Statement Timeout and Locking
List pgsql-jdbc
Markus Schaber <schabi@logix-tt.com> writes:
>         conn.createStatement().execute("SET statement_timeout TO 5000; LOCK TABLE exampletable IN EXCLUSIVE MODE; SET
statement_timeoutTO 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.

            regards, tom lane

pgsql-jdbc by date:

Previous
From: Tom Lane
Date:
Subject: Re: ERROR: could not convert UTF-8 character 0x00ef to ISO8859-1 possiblesolution
Next
From: Kris Jurka
Date:
Subject: Re: Statement Timeout and Locking