[Hibernate-issues] [Hibernate-JIRA] Commented: (HB-439) Ability to cancel query from a separate thread

[<leg...@at...>]

The following comment has been added to this issue:

     Author: Jeff Rhines
    Created: Fri, 31 Oct 2003 8:44 AM
       Body:
From the javadoc:  "Cancel execution of the current query. May be called from one thread to stop execution of a query in another thread. Use with care!"

What kind of care needs to be taken?  Are there cases where this should not be used?  Is it not safe in some respect?
---------------------------------------------------------------------
View the issue:

  http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-439


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HB-439
    Summary: Ability to cancel query from a separate thread
       Type: New Feature

     Status: Closed
   Priority: Minor
 Resolution: FIXED

    Project: Hibernate2
 Components: 
             core
   Fix Fors:
             2.1 rc1
   Versions:
             2.0.3

   Assignee: 
   Reporter: Jeff Rhines

    Created: Thu, 30 Oct 2003 6:09 PM
    Updated: Thu, 30 Oct 2003 11:40 PM
Environment: Hib2.0.3/My App/JDK1.4.2/Win2000/Dell PC/Grey Cubical Walls/etc.

Description:
Need a way to allow a user to cancel a running query.  Tried Session.close() to pull the connection out from under the query, but received a ConcurrentModificationException on SessionImpl:1949.  Reasonable, as the documentation claims Session implementations are not required to be thread safe.  So, it would be nice to have a feature so one thread could cancel a query being actively run by another thread.  Maybe similar to (or using?) java.sql.Statement.cancel()?



---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.

If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira