use hibernate3.0.5 and Spring1.1

when i use it as the hibernate3.0.5 reference:

Session session = this.getHibernateTemplate().getSessionFactory().openSession();
Transaction tx = session.beginTransaction();

String hqlDelete = "delete VbufferGis ";
int deletedEntities = session.createQuery( hqlDelete ).executeUpdate();
tx.commit();
session.close();
but it throws the exception of:
query must begin with SELECT or FROM

pls help me! 3ks.

Hi,
I cannot see anything wrong in what you have written.
This is the code that I have written for deleting.

tx=session.beginTransaction();
String hqlDelete = "delete from Item ";
int deletedEntities = session.createQuery( hqlDelete ).executeUpdate();
tx.commit();
session.close();

where Item is the name of the file mapped in hibernate.cfg.xml.


Regards
falgunipm.

Are you possibly using the H2 query parser?

Curtis ...

I didn't think spring 1.1 worked with hibernate 3.x. I thought you had to use atleast Spring 1.24. The Spring hibernate template might be pointing to net.sf.hibernate.* instead of org.hibernate.*

if I am mistaken and it is, try writing a more verbose hql statement to see if that works. like "delete from Class where id=:watever"