Hi,

I have three entities, User, Role and Access.
User has many-to-many association to Role.
Role has many-to-many association to Access.

I want to make query that fetches data from all three tables, but I don't want to set association property 'lazy' to false in mapping file, because I don't want fetch all information every time.

This code already fetches users with roles


How can I make it to fetch Access also?

Hibernate version:2.1


Thank you

Here is some additional information to my question.

Java classes,

UserBean
private String username;
private Set roles;

RoleBean
private String name;
private Set access;

AccessBean
private String name;

And I need to fetch data from three tables and then give it to logic, logic doesn't know about Hibernate, so I cannot use lazy initialization.

Problem solved, I think...

Following clause does what I want:

from UserBean as user
left join fetch user.roles as role
left join fetch role.access

Ups, problem not solved yet. Somehow I managed to get results like it worked, but it does not.

Hmm...