Hey folks,

A simple question. (And yes i searched the forum, but i was not very successful)
Is it possible to make a simple update by criteria??? Everything else works fine! So the problem is maybe just the understanding!

I mean, what if i just want to do smth. like this:

UPDATE users SET locked = true, reason = '' WHERE username like 'a%' and locked = true

And i only have the criteria, the fieldnames and values!!! I don't want to generate the HQL query by myself out of the criteria object!

Any ideas?

Thanks.

I mean. It cannot be the deal that i have to load all concerning entities into the RAM, just to update their fields via reflection and then save them back to the data base!
Performance???

Does really nobody have the same problem like me?

You'll need to use HQL (or SQL): http://docs.jboss.org/hibernate/core/3. ... tch-direct

That is what i am talking about! I do not want to generate the HQL by myself.

Given is a Criteria Object, the field names and the values.
I can generate the Update clause, but not the WHERE clause out of the Criteria object! That is the point!
So how can i mix a Criteria object with a HQL Query???

Or any other suggestions?

If I use HQL Queries, i am not object orientated anymore and not as dynamic as with Criteria objects!

Thx

As far as I know the only option for UPDATE statements offered by Hibernate is to use HQL or SQL. Criterias are only for SELECTing.

Unless you are updating thousand or millions of objects there is nothing wrong with loading them into memory, updating their fields, and then let Hibernate worry about sending the UPDATE to the database. That is the object-oriented approach. Trying to mix this with DML-style operations may be a source of problems. For example, the documentation says:



Meaning that entities that you already have loaded into memory in the same session are not affected by the update so they may now contain stale data. An even worse scenario is that the in-memory entity is dirty and then the next flush/commit will overwrite what was sent with the UPDATE.

OK thanks! That helps a lot! :)

Bye