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
|
