> 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. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
