Hello - I have a situation where I have a POJO with 42 attributes however in one part of my application I only need to select 3 of these attributes. A co-worker suggested using a named query to select only the three fields I need. This works fine but an object array is returned with my data. I then need to update the data and then persists it. How do I associate the data returned in the object array to my POJO --> which in turn, is associated to the current session?

Enabling dynamic-update for that entity will help trim down the update, but you're still going to select the whole thing when you load. I would strongly consider refactoring your model!

Hi,
You are using a Report Query. ( select clause of HQL )
Report Query is used in read-only scenarios.
You can find more information in the book "Hibernate In Action"

>>> I then need to update the data and then persists it
It does not return entites and are never "dirty-checked". So, you cannot update the data and persist it.

You can have a look at these options,
i) normalize your table ( it is flattened now ) and have 1:1 mapping between entities which can then be loaded lazily.

ii) map more than 1 class to the same table with each of them having id column (primary key) and other interested columns. Use appropriate model ( dictated by columns required ) in your query.

-----------------------------------------------------------
Rate the reply if you find it helpful