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