Hello,
I can't find how to build an hibernate query for a mapping like this in the docuementation:

<set name="names" table="person_names">
<key column="person_id"/>
<element column="person_name" type="string"/>
</set>

I need to know all the existing person_names( select person_name from person_names, of course), but usin hsql, that is , without tables.

getSession().createQuery("select names from person").list()

throws an error sayig names is not an entity, which is true, in case of a set of entities it works, but how should I do in case of value types(elemens)?
Many Thanks in advance
Igor

[quote="igorarbizu"]Hello,
I can't find how to build an hibernate query for a mapping like this in the docuementation:

[b]<set name="names" table="person_names">
<key column="person_id"/>
<element column="person_name" type="string"/>
</set>[/b]

I need to know all the existing person_names( select person_name from person_names, of course), but usin hsql, that is , without tables.

[b]getSession().createQuery("select names from person").list()[/b]

throws an error sayig names is not an entity, which is true, in case of a set of entities it works, but how should I do in case of value types(elemens)?
Many Thanks in advance
Igor[/quote]

Hello Friend:

I guess that you can create a Criteria, and then iterate the result set of Person.

After this, you say: person.getNames(), it will return you a list, then you add this resultSet into a Collection.

That is I wanna do if i was you, i think that is very inefficent. Waiting for ths post of others friends.

No,

select p.names from person name

it causes the same error (not an entity),
I'm working with Dynamic models (hibernate 3) so there is not class Person (getName() etc..) but a map

select p["names"] from person p (???) doesn't work either

any idea?
Thanks
Igor

post the full mapping file please

this is all the mapping the question is aboutmapping

<class entity-name="person" table="av_person">
<id name="id" type="string" column="id" />
<set name="names" table="person_names">
<key column="person_id"/>
<element column="person_name" type="string"/>
</set>
</class>

this is all the mapping the question is aboutmapping

<class entity-name="person" table="av_person">
<id name="id" type="string" column="id" />
<set name="names" table="person_names">
<key column="person_id"/>
<element column="person_name" type="string"/>
</set>
</class>

So I assume this is not possible with dynamic entities? is it a bug??

I'm not sure if this fits your question but:

I have a User Object that has a set of roles, which are simply strings so the mapping looks like that:



Now to get a list of all users with a specific role I do this:



Note the 'join u.roles as role', which does the trick.

I just would like to know if and how this can be made using Criteria ...

regards, ridcully