Greetings,

Is it at all possible to initialize a collection of string values using a custom sql query?

I have a User object that has a Set of String values, named roles, which I need to populate when the User object is retrieved. However certain conditions in other tables dictate which values will be included in the Set, so I need to to do some custom sql.



I have been attempting to map the User roles like so:



With a (simplified) custom query:


From what I can gather the <load-collection> can only work with defined entities, and since I have a Set of strings it won't work for me.

I've been experimenting with different configurations with no luck. Basically I just need to know whether it is possible to achieve this using Hibernate mapping.

Thanks,
Alan.

Have you try with the 'where' clause:


http://www.hibernate.org/hib_docs/v3/reference/en-US/html/collections-mapping.html

Christophe

I actually need to select the roles based on values in other tables, so the sql looks more like this:



I over simplified the sql in the previous example - didn't want it to be too confusing.

I have a user_role table which matches the users and roles, but which roles are added to the Set in the User object is determined by the 'active' value in separate tables representing those roles.

Is it still possible to populate the Set somehow?

Mate, I am facing the same problem.

I need to map a collection of basic types using a sql query. Is there anyway doing this?