Hello,

I have User table with huge amount of fields and relations. But for display purposes usually all I need is couple of fields from User table (username, userid).

What would be a good solution to "switch" between simplified/full User objects? So if I need to display only usernames Hibernate won't load all those related tables. And if I need I can have all full Users with all relations.

I tried to create two different mappings (simple and with all relations) for one table but seems like Hibernate doesn't like that in one session.

Thanks.

I believe that you have to set an entity-name for each of the mappings to be able to have multiple mappings per table.

In the documentation it says that entity name by default equals to class name. I tried creating two different classes (User, SimpleUser) mapped to one user table. But when I try to run a simple query like

select u from SimpleUser u

It takes probably 5 minutes to run and returns an empty list. While the same query for User takes few seconds and returns correct data.

Yes, it is possible to have different objects in the session with the same ID, if you relate them under the form "one to one relationship on a primary key" (reference documentation 7.2.2).

Serg, in your case case I would make a class with your simplified object, with an additional property being the full object. This full-object property would be lazily associated and read only if needed.