Re: What is causing 'canceling statement due to user request' ?

On 23.10.2006 16:14 Csaba Nagy wrote:
> Hi all,
>
> I know of 2 causes:
>
>  - hit CTRL-C in the psql client;
>  - have a non-zero statement timeout and have the statement actually
> time out;
>
> But I am seeing this via JDBC which can't cancel a statement AFAIK

JDBC *can* cancel a running statement. You just need to call cancel()
from another thread.

http://java.sun.com/j2se/1.5.0/docs/api/java/sql/Statement.html#cancel()

Works great in my SQL front end.

Thomas