Hi,

I have problem with HQL.

I have this entities:
UserAccount, Opravneny, Spis, Opravneny2Spis

UserAccount: {
ID,
Name,
....
Opravneny //collection to Opravneny
}

Opravneny {
ID,
...
}


Spis {
ID
Opravneny2Spis -> collection
}

Opravneny2Spis {
ID
File ->
}




Spis -> (1 : N) -> Opravneny2Spis
Opravneny2Spis -> (1 : N) -> Opravneny


UserAccount -> (1:N) Opravneny

and i got

cz.softeu.fw.FWException: net.sf.hibernate.QueryException: unindexed collection before []: useraccoun2_.opravneni [select spis from cz.softeu.evidence.SpisImpl spis inner join spis.opravneni2Spisy opr where opr.opravneny = some (select u.opravneni from cz.softeu.evidence.UserAccountImpl as u where u.id=4)]
cz.softeu.evidence.fw.SpisForm.preQuery(SpisForm.java:922)

in spis.opravneny2spis.opravneny is the collection of the possible users (opravneny is role of user)

in useraccount.opravneny is collection of enabled users.
I would like to display all SPIS where some "spis.opravneny2spis.opravneny" is in collection useraccount.opravneny


Thanx for help, Mila