Hibernate: Native SQL [update]

[Chandra Sekhar]

Hi,

While triying to execute an update query using native SQL ,i'm getting an exception as follows.

java.lang.UnsupportedOperationException: Update queries only supported through HQL at org.hibernate.impl.AbstractQueryImpl.executeUpdate(AbstractQueryImpl.java:607)

My code is like

session.createSQLQuery("UPDATE ITEM set name='hib' WHERE itemid=1").executeUpdate()

I can change to HQL, but I like to know why this exception is thrown.

Why is native SQL for update not supported by Hibernate.

Thanks in Advance
Chandrasekhar S

[Chandra Sekhar]

Hi,

When i changed my version to hibernate3.2 its working.


Thanks
Chandrasekhar S

[Cameron Wallace McKenzie]

Indeed, there shouldn't be a problem with a native query update using Hibernate. The following works fine on Hibernate 3.2.5 on MySQL:

 
final static String UPDATE = "UPDATE user SET   password = 123456 WHERE id = 101";
private static void hibernateNativeQueryUpdate(SessionFactory factory) {
 
Session session = factory.getCurrentSession();
session = factory.openSession();
session.beginTransaction();
SQLQuery sqlQuery = session.createSQLQuery(UPDATE);
int result = sqlQuery.executeUpdate();
System.out.println(result);
session.getTransaction().commit();
 
}