Hi!
I have a (for an advanced user shurley easy) question. I have two classes User and Project. Every User has a list of Projects. They are n:m mapped. To find all Users of a specific Project is no Problem, I do this with
list = session.createQuery("from User1 where projectList.id="+p.getId()).list(); where p is a given Project. But how can I get all Projects of a User?

Thx

just wondering, but are you mapping it via a middleman m:n table? if you map it both ways in the hibernate you should be able to do the same query in the opposite direction

Hi,

Try this,

lazy="false" in the set or bag property of the Projects.

You will have the values.

lazy (optional - defaults to proxy): By default, single point associations are proxied. lazy="no-proxy" specifies that the property should be fetched lazily when the instance variable is first accessed (requires build-time bytecode instrumentation). lazy="false" specifies that the association will always be eagerly fetched

Yes shure I could do this, but I'm working in a team and we decided to do it with a many to many relationship.
Thx anyway for the reply

Thx I'm going to try this!

I have set my bag in User to lazy="false"; But how can I now create a query who gives me a list of all projects of a user? I can't access by the auto-generated class User_Project, this gives me an error, and in the class Project I have no reference to an User...

Hi,

Set lazy="false". Use the Criteria API as below

Criteria criteria = session.createCriteria(User.class);
criteria.add(Expression.in("userId", userId));
// Assuming userId is not PK
List userList = criteria.list();

If you searching by PK
User user = (User)session.get(User.class, userId);

Above user object will have the projects in it.

Or if you don't want to have lazy="false" which with eception of rare cases shouldn't be used, do:

User user = (User)session.get(User.class, userId);

Hibernate.initialize(user.getProjectss());

Thx, it was a little bit a stupid question, I recognized. I didn't see the simplest way,
Thank you both