Bonjour a tous,
J'ai une relation entre mes beans comme ceci:
Contact -> Function -> FunctionLabel
J'ai un problème lors de ma recherche à l'aide de criteria. J'utilise des projections pour récupérer uniquement certains attributs du bean Contact et certains attributs de l'association Function.FunctionLabel. Jusque la pas de problèmes sauf que le critere me renvois uniquement les attibuts des contacts possédant au moins une Function or j'ai besoin de récupérer tous les Contacts associés ou non à une fonction. Et j'ai besoin que ces Contacts soient dupliqués si j'ai plusieurs functions associées.
En fait la projection me génère une jointure interne or je voudrais avoir le même résultat mais avec une jointure externe...
Voici toutes les informations ci-dessous :
Hibernate version: 3.2.0
Requete Criteria :
Code:
session.createCriteria(Contact.class);
criteria.createAlias("functions", "fcts")
.createAlias("fcts.functionLabel", "flabel")
criteria.setFetchMode("fcts", FetchMode.JOIN);
criteria.setFetchMode("flabel", FetchMode.JOIN);
ProjectionList projections = Projections.projectionList();
projections.add(Projections.property("id"));
projections.add(Projections.property("title"));
projections.add(Projections.property("lastname"));
projections.add(Projections.property("firstname"));
projections.add(Projections.property("fcts.id"));
projections.add(Projections.property("flabel.label"));
criteria.setProjection(projections);
List beanList = criteria.list();
The generated SQL (show_sql=true):select this_.ID as y0_, this_.TITLE as y1_, this_.LASTNAME as y2_, this_.FIRSTNAME as y3_, this_.PHONE_NB as y4_, this_.MOBILE_NB as y5_, this_.FAX_NB as y6_, this_.EMAIL as y7_, this_.UPDATED_BY as y8_, this_.UPDATED_AT as y9_, fcts1_.ID as y10_, flabel2_.LABEL as y11_, com3_.SHORT_NAME as y12_ from CONTACTELUS_USER.CONTACTS this_
inner join CONTACTELUS_USER.FUNCTIONS fcts1_ on this_.ID=fcts1_.CONTACT_ID
inner join CONTACTELUS_USER.FUNCTION_LABELS flabel2_ on fcts1_.FUNCTION_LABEL_ID=flabel2_.ID
inner join CONTACTELUS_USER.COMMUNITIES com3_ on fcts1_.COMMUNITY_ID=com3_.ID
Mapping documents: Voici mon mapping hibernate
Code:
<hibernate-mapping>
<class name="com.anwrt.veolia.elus.model.generated.Contact" table="CONTACTS" schema="CONTACTELUS_USER">
<id name="id" type="integer">
<column name="ID" />
<generator class="increment" />
</id>
<property name="lastname" type="string">
<column name="LASTNAME" />
</property>
<property name="firstname" type="string">
<column name="FIRSTNAME" />
</property>
<set name="functions" inverse="true" lazy="true" cascade="all">
<key>
<column name="CONTACT_ID" precision="38" scale="0" />
</key>
<one-to-many class="com.anwrt.veolia.elus.model.generated.Function" />
</set>
</class>
<class name="com.anwrt.veolia.elus.model.generated.Function" table="FUNCTIONS" schema="CONTACTELUS_USER">
<id name="id" type="integer">
<column name="ID" />
<generator class="increment" />
</id>
<many-to-one name="functionLabel" class="com.anwrt.veolia.elus.model.generated.FunctionLabel" unique="true" fetch="select">
<column name="FUNCTION_LABEL_ID" />
</many-to-one>
<many-to-one name="community" class="com.anwrt.veolia.elus.model.generated.Community" unique="true" fetch="select">
<column name="COMMUNITY_ID" />
</many-to-one>
<many-to-one name="contact" class="com.anwrt.veolia.elus.model.generated.Contact" unique="true" fetch="select">
<column name="CONTACT_ID" />
</many-to-one>
<many-to-one name="address" class="com.anwrt.veolia.elus.model.generated.Address" unique="true" fetch="select">
<column name="ADDRESS_ID" />
</many-to-one>
</class>
<class name="com.anwrt.veolia.elus.model.generated.FunctionLabel" table="FUNCTION_LABELS" schema="CONTACTELUS_USER">
<id name="id" type="integer">
<column name="ID"/>
<generator class="increment" />
</id>
<property name="label" type="string">
<column name="LABEL" length="150" />
</property>
<property name="mailLabel" type="string">
<column name="MAIL_LABEL" length="150" />
</property>
<property name="article" type="string">
<column name="ARTICLE" length="4" />
</property>
<set name="functions" inverse="true" lazy="true" cascade="none">
<key>
<column name="FUNCTION_LABEL_ID" precision="38" scale="0" />
</key>
<one-to-many class="com.anwrt.veolia.elus.model.generated.Function" />
</set>
</class>
</hibernate-mapping>
N'hesitez pas a me questionner pour de plus amples informations.
D'avance merci.
Login
FAQ
Search
