[Hibernate-issues] [Hibernate-JIRA] Commented: (HHH-870) support SQL updates in named queries

[Sergey V. (JIRA) <no...@at...>]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-870?page=comments#action_22316 ] 

Sergey Vladimirov commented on HHH-870:
---------------------------------------

I'm not sure that it is possible to use batchers here. We only have one sql, what to batch?

And, we need to clear all caches after every sql. We can't allow hql to be executed after sql in batch mode.

> support SQL updates in named queries
> ------------------------------------
>
>          Key: HHH-870
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-870
>      Project: Hibernate3
>         Type: New Feature

>   Components: core
>  Environment: Hibernate 3.0.5, SQL Server 2000
>     Reporter: Nathan Moon
>     Priority: Minor
>  Attachments: patch.txt
>
>
> currently attempting to execute a named <sql-query> that is an update statement throws java.lang.UnsupportedOperationException: Update queries only supported through HQL.
> In order to execute sql updates, the Session.connection() must be used directly.
> (see forum topic http://forum.hibernate.org/viewtopic.php?t=940281)
> It would be very nice to be able to be able to externalize SQL update statements and be able to run them with Session.getNamedQuery().

-- 
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
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira