[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: Thu, 30 Oct 2003 6:13 PM
       Body:
Forgot to mention it's Oracle9i with the Thin driver, though using OCI is not out of the question (for me, anyway... don't remember if Hib has any particular req).  Dunno if it matters.

---------------------------------------------------------------------
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: Unassigned
   Priority: Minor

    Project: Hibernate2
 Components: 
             core
   Versions:
             2.0.3

   Assignee: 
   Reporter: Jeff Rhines

    Created: Thu, 30 Oct 2003 6:09 PM
    Updated: Thu, 30 Oct 2003 6:09 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