[Hibernate-issues] [Hibernate-JIRA] Created: (HB-266) Bulk update / batch operations

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

Message:

  A new issue has been created in JIRA.

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

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


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HB-266
    Summary: Bulk update / batch operations
       Type: New Feature

     Status: Unassigned
   Priority: Major

    Project: Hibernate2

   Assignee: 
   Reporter: Michael Schechter

    Created: Fri, 15 Aug 2003 10:39 PM
    Updated: Fri, 15 Aug 2003 10:39 PM
Environment: N/A

Description:
In working with Hibernate, I have had the need to execute high-performance bulk updates. Without the concept of an equivalent to the SQL UPDATE statement, I was forced to fall back to obtaining a PreparedStatement on a connection to execute the hand-coded SQL directly. I see this as a problem, as there is no way to protect this code from changes in the table names, column names, or object relationships the way we can with other operations in Hibernate.

A typical statement that would fit the above description would be:
UPDATE MY_TABLE
SET COL_1="A"
WHERE COL_1="B";

There is always the possibility that iterating over the matching object set and committing the transaction through Hibernate would be comparable. It seems counterintuitive that creating a large number of row updates could possibly be as fast as a single statement executed on the database server.


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