Query

[preetesh kulkarni]

How to write delete query using createSQLQuery.
My query is :-

List technologydeleteList = session.createSQLQuery("Delete from lkup_detl tel where tel.lkup_value_desc='"+technology.getstrName()+"' and tel.lkup_cd='TECHNOLOGY' ")
.addEntity("tel",SBUSelection.class).list();

On submitting the page the page gives error.
But on going back and refreshing the page the value is deleted from the database.

[Paul Sturrock]

On submitting the page the page gives error.

And what does that error say?

[Franck McGeough]

have you tried doing a .executeUpdate instead of a .list? I'm not sure what you expect to get returned in a list from the delete statement.