Not supported for DML operations

kmsram420 · **Posted:** Thu Jun 12, 2008 2:46 am

Hi,

I tried to update a field in the database. It shows me "Not supported for DML Operations.". This is how i create the sessionFactory.
sessionFactory = new Configuration()
.configure("hibernate.cfg.xml")
.buildSessionFactory();

Hibernate version:3.2

Code between sessionFactory.openSession() and session.close():
String queryString = null;
Query query = null;
queryString = "update S set name = :name, description = :description where sID = :sID";
session.beginTransaction();
query = session.createQuery(queryString);
query.setString("name", stackName);
query.setString("description", stackDescription);
query.setInteger("sID", sID);
boolean resultSet;
query.list();
session.getTransaction().commit();

Full stack trace of any exception that occurs:
Exception in thread "main" org.hibernate.hql.QueryExecutionRequestException: Not supported for DML operations [update com.example.example1.db.S set name = :name, description = :description where sID = :sID]
at org.hibernate.hql.ast.QueryTranslatorImpl.errorIfDML(QueryTranslatorImpl.java:272)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:321)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at com.spikesource.sf.dbaccess.Manager.updateSInfo(Manager.java:82)
at com.spikesource.sf.dbaccess.Manager.main(Manager.java:58)

Name and version of the database you are using:
Postgres:8.2

kmsram420 · **Posted:** Tue Jun 17, 2008 1:10 am

There is an other way of updating the row in a table.

Code:

session.beginTransaction();
S s = (S)session.get(S.class, sID);
s.setDescription(sDescription);
s.setName(sName);
session.update(s);
session.getTransaction().commit();

And this works.

akvsaran · **Joined:** Sat May 03, 2008 12:30 pm **Posts:** 9

Hi,
Try query.executeUpdate()

akvsaran · **Joined:** Sat May 03, 2008 12:30 pm **Posts:** 9

Hi,
Try query.executeUpdate()

Cameron McKenzie · **Posted:** Tue Jun 17, 2008 3:31 pm

Quote:

public int executeUpdate()
throws HibernateException

Execute the update or delete statement. The semantics are compliant with the ejb3 Query.executeUpdate() method.

Returns:
The number of entities updated or deleted.
Throws:
HibernateException

JavaDoc for the Hibernate3 Query object:

http://www.hibernate.org/hib_docs/v3/api/index.html[/code]

kmsram420 · **Posted:** Wed Jun 18, 2008 12:23 am

Hey thanks....executeUpdate() works :)