Discussion :

[Incinerator]

Bonjour,

Merci de m'aider à convertir la requête ci-dessous vers une requête HQL d'Hibernate :

select
p.PROJ_NOM,
b.BES_DATESOUHAITEE,
r.ROL_NOM,
b.BES_CANDIDATPOTENTIEL1,
b.BES_CANDIDATPOTENTIEL2,
b.BES_DATEPOSSIBLE2,
b.BES_COMMENTAIRE
from
besoinrh b,
projet p,
rol r,
collaborateur c,
centre ce,
v1centre vc
where
b.PK_BES_COLL_OID = c.COLL_OID
and b.PK_BES_PROJ_OID = p.PROJ_OID
and b.PK_BES_ROL_OID = r.ROL_OID
and p.PK_PROJ_CENT_OID = ce.CENT_OID
and vc.PK_V1CEN_CENT_OID = ce.CENT_OID
and vc.V1CEN_OID = 1

Merci de votre aide.

[guigui5931]

C'est difficile sans connaitre ton mapping.
De plus ce n'est pas la peine d'ouvrir 2 sujet identique en 2 heures.

[Incinerator]

Veuillez trouver ci-dessous le mapping concernant la requête ci-dessus :

mapping 1 :

<hibernate-mapping>
<class name="com.business.domain.BesoinRH" table="BESOINRH">
<id name="id" column="BES_OID">
<generator class="native"/>
</id>

<property name="dateSouhaitee" type="timestamp" not-null="true" column="BES_DATESOUHAITEE"/>
<property name="candidatPotentiel1" type="java.lang.String" not-null="true" column="BES_CANDIDATPOTENTIEL1"/>
<property name="datePossible1" type="timestamp" not-null="true" column="BES_DATEPOSSIBLE1"/>
<property name="candidatPotentiel2" type="java.lang.String" not-null="true" column="BES_CANDIDATPOTENTIEL2"/>
<property name="datePossible2" type="timestamp" not-null="true" column="BES_DATEPOSSIBLE2"/>
<property name="commentaire" type="java.lang.String" not-null="true" column="BES_COMMENTAIRE"/>
<property name="version" type="timestamp" not-null="true" column="BES_VERSION"/>

<many-to-one name="miseAJour" class="com.business.domain.Collaborateur" not-null="true">
<column name="PK_BES_COLL_OID"></column>
</many-to-one>

<many-to-one name="projet" class="com.business.domain.Projet" not-null="false" lazy="false">
<column name="PK_BES_PROJ_OID"></column>
</many-to-one>

<many-to-one name="rol" class="com.business.domain.Rol" not-null="false" lazy="false">
<column name="PK_BES_ROL_OID"></column>
</many-to-one>

</class>
</hibernate-mapping>

mapping 2 :

<hibernate-mapping>
<class name="com.business.domain.V1Centre" table="V1CENTRE">

<id name="id" column="V1CEN_OID">
<generator class="native"/>
</id>

<property name="version" type="timestamp" not-null="true" column="V1CEN_VERSION"/>

<many-to-one name="miseAJour" class="com.business.domain.Collaborateur" not-null="true">
<column name="PK_V1CEN_COLL_OID"></column>
</many-to-one>

<many-to-one name="centre" class="com.business.domain.Centre" not-null="true">
<column name="PK_V1CEN_CENT_OID"></column>
</many-to-one>

<many-to-one name="calendrier" class="com.business.domain.Calendrier" not-null="true">
<column name="PK_V1CEN_CALE_OID"></column>
</many-to-one>

<set name="v1CorpCentre" sort="natural" inverse="true" cascade="all-delete-orphan" lazy="false">
<key>
<column name="PK_V1COCE_V1CEN_OID" not-null="true" />
</key>
<one-to-many class="com.business.domain.V1CorpCentre" />
</set>

</class>
</hibernate-mapping>

Merci de votre aide.