getting Problem in hibernate delete Query...

[Jigar Gohil]

hi...i am trying to execute the following query...

query = session.createQuery("delete from TblSuperProfMapping tblSuperProfMapping " +
"where tblSuperProfMapping.vcreatedBy='MMADMIN'");

and getting following error...

org.hibernate.hql.ast.QuerySyntaxError: unexpected token: tblSuperProfMapping near line 1, column 56 [delete from com.moneymax.hibernate.TblSuperProfMapping tblSuperProfMapping where vcreatedBy='MMADMIN']


can any body tell me why am getting this error....

[ December 04, 2008: Message edited by: Jigar Gohil ]
[ December 04, 2008: Message edited by: Jigar Gohil ]

[Paul Sturrock]

Can we see your mapping file?