[Hibernate-issues] [Hibernate-JIRA] Updated: (HB-415) Set the isolation level for SELECT statements (add "with ur")

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

The following issue has been updated:

    Updater: Jenica Humphreys (mailto:je...@mv...)
       Date: Tue, 21 Oct 2003 4:18 PM
    Comment:
I am not sure how to create a diff file of the sort that are on most of the patches here.  This is just a standard project diff for the hibernate source.
    Changes:
             Attachment changed to hibernate.diff
    ---------------------------------------------------------------------
For a full history of the issue, see:

  http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-415&page=history

---------------------------------------------------------------------
View the issue:

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


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HB-415
    Summary: Set the isolation level for SELECT statements (add "with ur")
       Type: New Feature

     Status: Unassigned
   Priority: Major

    Project: Hibernate2
 Components: 
             core
   Versions:
             2.0rc2

   Assignee: 
   Reporter: Jenica Humphreys

    Created: Tue, 21 Oct 2003 4:16 PM
    Updated: Tue, 21 Oct 2003 4:18 PM
Environment: DB2 7.2+

Description:
DB2 allows you to set the isolation level for each select statement, and depending on environment can by default lock a page for every SELECT issued.  Adding "with ur" to each SELECT statement allows an uncommitted read, increasing speed and decreasing the chances of database locks.

This patch adds a dialect feature which allows you to add the isolation level to the end of each SELECT generated by hibernate.


---------------------------------------------------------------------
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