> 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.
Are you sure ? Ever tried to cancel a long running statement and see if
it is still running in the DB after you cancelled it on the JDBC side ?
Cheers,
Csaba.