I've this hibernate mapping:

<class
name="Sante.PAT.CPatient, Sante">
<id
name="no"
access="field"
column="patientId"
length="10">
<generator
class="guid" />
</id>
<property
name="dateNaissance"
access="field" />
<property
name="dateDeces"
access="field" />
<property
name="estDecede"
access="field"
column="IndicateurDeces" />
<bag
name="noms"
access="field">
<key
column="patientID"
foreign-key="patientDeNom" />
<one-to-many
class="Sante.PAT.CNom, Sante" />
</bag>
</class>
name="Sante.PAT.CNom, Sante">
<id
name="nomFamille"
access="field"
length="50">
<generator
class="assigned" />
</id>
<property
name="prenom1"
access="field"
length="50" />
<property
name="prenom2"
access="field"
length="50" />
</class>

with the corresponding C# classes:

public class CNom:CEntite, INom
{
private string nomFamille;

public string NomFamille
{
get { return nomFamille; }
set { nomFamille = value; }
}

private string prenom1;

public string Prenom1
{
get { return prenom1; }
set { prenom1 = value; }
}

private string prenom2;

public string Prenom2
{
get { return prenom2; }
set { prenom2 = value; }
}

}

[Class]
public class CPatient
{
private DateTime dateNaissance;

public DateTime DateNaissance
{
get { return dateNaissance; }
set { dateNaissance = value; }
}

private DateTime dateDeces;

public DateTime DateDeces
{
get { return dateDeces; }
set { dateDeces = value; }
}

private bool estDecede;

public bool EstDecede
{
get { return estDecede; }
set { estDecede = value; }
}

private ISet<INom> noms;

public virtual ISet<INom> Noms
{
get {
return noms;
}
}
}

when i try this HQL request, i've got an error:

from CPatient where CPatient.noms.nomFamille like 'Mor%'

"The multi-part identifier "CPatient.noms.nomFamille" could not be bound."

I need to write this:

from CPatient as patient join patient.noms as noms where noms.nomFamille like 'Mor%'


So apparently, you can't really used pointed notation to traverse the model?
does it exist another method more "intuitive"? How can i wrote this request using Criteria object?

Hi xavos, can you post the query your statement is generating, please.
I believe the sql query is incorrect of course your proposite.

I remark that i've forgot to add CNom in From clause, so i wrote:

from CPatient,CNom where CPatient.noms.nomFamille like 'Mor%'

and the SQL request is:

select cpatient0_.patient_id as patient1_14_,cnom1_.nom_famille as nom1_3_1_, cpatient0_.date_naissance as date4_14_0_, cpatient0_.date_deces
as date5_14_0_, cpatient0_.indicateur_deces as indicateur6_14_0_, cnom1_.prenom1 as prenom3_3_1_, cnom1_.prenom2 as prenom4_3_1_ from cpatient cpatient0_, cnom cnom1_ where (CPatient.noms.nomFamille like 'Mor%')

(In my class model, i forget CEntite class inheritance for CPatient, CEntite implementing "no" object attribute (mapped to patient_id in mapping file))

which doesn't work too

im having same troubles here.


devis mutuelle assurance complementaire sante maladie - Faut-il recourir à une mutuelle ou une assurance complémentaire santé ? A cette question, 90% des françaisdevis mutuelle assurance complementaire sante maladie

as an example