Hibernate version:last

Hello I've a big problem with my a HQL query.
I want that my query returns all the CV with a given 'lastname' and a given 'state' of the Result.
CV has a set of Result called 'resultList'.
My query is like


List cvListByname = new ArrayList();
Query q = session.createQuery("from CV where lastname =:lastname and resultList.state = :state");
q.setParameter("lastname", lastname);
q.setParameter("state", new Integer(1));
cvListByname = q.list();


cvListByname now contains the CV with the resultList but the resultList contains also the 'Result' 's with state != 1.

Someone can help me?
thanks a lot
Martina






Mapping documents:

<class
name="com.sintesinet.jobnet.imatch.cv.model.CV"
table="JN_CV"
>

<id
name="cvID"
column="cvID"
type="long"
>
<generator class="native">
<!--
To add non XDoclet generator parameters, create a file named
hibernate-generator-params-CV.xml
containing the additional parameters and place it in your merge dir.
-->
</generator>
</id>

<set
name="resultList"
lazy="true"
cascade="none"
sort="unsorted"
>

<key
column="cvId"
>
</key>

<one-to-many
class="com.sintesinet.jobnet.imatch.cv.model.Result"
/>

</set>

<property
name="address"
type="java.lang.String"
update="true"
insert="true"
column="address"
/>

<property
name="email"
type="java.lang.String"
update="true"
insert="true"
column="email"
/>

<property
name="lastname"
type="java.lang.String"
update="true"
insert="true"
column="lastname"
/>

<property
name="mailInfoID"
type="long"
update="true"
insert="true"
column="mailInfoID"
/>

<property
name="name"
type="java.lang.String"
update="true"
insert="true"
column="name"
/>

<property
name="data"
type="java.util.Date"
update="true"
insert="true"
column="data"
/>

<!--
To add non XDoclet property mappings, create a file named
hibernate-properties-CV.xml
containing the additional properties and place it in your merge dir.
-->

</class>



<class
name="com.sintesinet.jobnet.imatch.cv.model.Result"
table="JN_RESULT"
>

<id
name="id"
column="id"
type="long"
>
<generator class="foreign">
<param name="property">points</param>
<!--
To add non XDoclet generator parameters, create a file named
hibernate-generator-params-Result.xml
containing the additional parameters and place it in your merge dir.
-->
</generator>
</id>

<property
name="cvId"
type="long"
update="true"
insert="true"
column="cvID"
/>

<property
name="mansioneId"
type="long"
update="true"
insert="true"
column="mansioneID"
/>

<property
name="state"
type="int"
update="true"
insert="true"
column="state"
/>

<one-to-one
name="points"
class="com.sintesinet.jobnet.imatch.cv.model.Points"
cascade="all"
outer-join="auto"
constrained="true"
/>

<!--
To add non XDoclet property mappings, create a file named
hibernate-properties-Result.xml
containing the additional properties and place it in your merge dir.
-->

</class>


<class
name="com.sintesinet.jobnet.imatch.cv.model.Points"
table="JN_POINTS"
lazy="false"
>

<id
name="id"
column="id"
type="long"
>
<generator class="native">
<!--
To add non XDoclet generator parameters, create a file named
hibernate-generator-params-Points.xml
containing the additional parameters and place it in your merge dir.
-->
</generator>
</id>

<property
name="competenzePoint"
type="float"
update="true"
insert="true"
column="competenzePoint"
/>

<property
name="motivazioneMult"
type="float"
update="true"
insert="true"
column="motivazioneMult"
/>

<property
name="skillPoint"
type="float"
update="true"
insert="true"
column="skillPoint"
/>

<!--
To add non XDoclet property mappings, create a file named
hibernate-properties-Points.xml
containing the additional properties and place it in your merge dir.
-->

</class>

Try using a ResultTransformer and CriteriaQuery, as described here:

http://www.hibernate.org/hib_docs/v3/re ... sociations

Yes but
Is possible if I've

(Person) 1 ---------> * (Address) ?

I want to take a List of object 'Person' that have inside only the Address where the Address.country_code == 02022 ??

It's possible to retrive a List of Person with inside only the Address that specifies any condition?

Someone can give me an example?
Thanks a lot guys
Martina

NO

Hello thanks for your response
so what I've to do?
2 different queries and iterate the 1st result List?
thanks

I'd make resultList a bidirectional association. So you'd only need one query.

resultListByName will hold Result objects. But every Result object will have a reference to their CV object.