problems with delete(query)

christian · **Posted:** Mon Dec 08, 2003 9:39 am

You are not binding an argument to your delete statement parameter. Your code is wrong, just look at it again.

herrera · **Posted:** Mon Dec 08, 2003 9:44 am

but I am using setParameter. Isn

christian · **Posted:** Mon Dec 08, 2003 9:46 am

You set the parameter, and then don't execute the query. The only thing you do is passing the query string to the delete().

Check the API documentation for delete(), you can used positional parameters (no Query).

herrera · **Posted:** Mon Dec 08, 2003 9:58 am

Sorry. I

christian · **Posted:** Mon Dec 08, 2003 10:05 am

Please read the documentation and API Javadoc for Session.delete():

delete(String query)
Delete all objects returned by the query.

delete(String query, Object[] values, Type[] types)
Delete all objects returned by the query.

delete(String query, Object value, Type type)
Delete all objects returned by the query.

You use a query string like "from myClass foo where foo.someAttribute = ?" and then bind a value to that parameter. This is the same mechanism as for Session.find(), which is well documented everywhere.

herrera · **Posted:** Mon Dec 08, 2003 10:11 am

sorry,

then my code is correct, isn

christian · **Posted:** Mon Dec 08, 2003 10:18 am

No, its not. Look, you just say:

Code:

int regDel = session.delete(query.getQueryString());

which is like executing:

Code:

int regDel = session.delete("from TbPerson as tbPerson where tbPerson.comp_id.cdPerson = :cdPessoa");

The argument you bind to the Query in the lines before that are not executed, because you are not executing the Query object, but only the string!

Try to understand the following code:

Code:

String cdPessoa = "aValue";

String queryString = "from TbPerson as tbPerson where tbPerson.comp_id.cdPerson = ?";

int regDel = session.delete(queryString, new Object[]{cdPessoa}, new Type[]{Hibernate.STRING});

herrera · **Posted:** Mon Dec 08, 2003 10:30 am

Ok ..

It