[Hibernate-issues] [Hibernate-JIRA] Created: (HB-481) SQL Update with alias replacement

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


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HB-481
    Summary: SQL Update with alias replacement
       Type: New Feature

     Status: Unassigned
   Priority: Minor

    Project: Hibernate2
 Components: 
             core

   Assignee: 
   Reporter: xfgdf

    Created: Wed, 19 Nov 2003 9:58 AM
    Updated: Wed, 19 Nov 2003 9:58 AM

Description:
There is currently a way to do a SQL SELECT with createSQLQuery(). It would be great to have a way to also perform SQL UPDATE and DELETE with alias replacement. It would be very helpfull to perform massive update on many rows.

The same way we have :

Query q = session.createSQLQuery(
    "SELECT {person.*} FROM PERSON {person} WHERE ROWNUM<10", 
    "person", 
    Person.class
);

To be able to do this :

session.executeSQL(
    "UPDATE {person} SET {person.name} = UPPER({person.name})"
);

   Adrien


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