Hibernate Community • View topic - Delete using Native SQL not supported in H3.1!?

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Delete using Native SQL not supported in H3.1!?

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

ardal

Post subject: Delete using Native SQL not supported in H3.1!?

Posted: Wed Nov 23, 2005 6:57 am

Beginner

Joined: Tue Jul 19, 2005 4:03 am
Posts: 34
Location: Aberdeen, UK

I am using Hibernate 3.0.5

The issue is that we want to executes some bulk deletes on the system using Native SQL.

Code:

SQLQuery query = session.createSQLQuery("delete from some_table");query.executeUpdate();

But this query is casing an error

Code:

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

I read other discussions in the forum that this is not possible using H3.0, but should be possible in H3.1 (!!??) So I upgraded to H3.1rc3, but the same error occurred.

My question: Will this be possible in H3.1 or will I be forced to go down the route of executing the batch deletes using the JDBC connection?

Top

christian

Post subject:

Posted: Wed Nov 23, 2005 7:17 am

Hibernate Team

Joined: Mon Aug 25, 2003 9:11 pm
Posts: 4592
Location: Switzerland

session.connection().createStatement(SQL);
session.createQuery(HQL);

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum