Dear all,

I'm new to hibernate, I have create a mapping which have a composite key. mapping as follow,

<hibernate-mapping>
<class name="bean.AccountProfile" table="member_profiles">
<composite-id name="id" class="bean.AccountProfileId">
<key-property name="accountId" type="int" column="member_id" />
<key-property name="name" type="string" column="name" />
</composite-id>
<many-to-one name="account" class="bean.Account" update="false" insert="false" fetch="select">
<column name="member_id" not-null="true" />
</many-to-one>
<property name="value" type="string">
<column name="value" />
</property>
</class>
</hibernate-mapping>

what i want to do is to retrieve a list of AccountProfile objects filter by the accountId. following is my code,

accountProfile = new AccountProfile();
accountProfileId = new AccountProfileId();

accountProfileId.setAccountId(accountId);
accountProfile.setId(accountProfileId);

List accountProfiles = accountProfileDAO.findByExample(accountProfile);

method findByExample():

public List<AccountProfile> findByExample(AccountProfile instance) {
try {
sessionFactory.getCurrentSession().beginTransaction();
List<AccountProfile> results = List<AccountProfile>) sessionFactory.getCurrentSession().createCriteria("com.sysfotech.ums.bean.AccountProfile").add(create(instance)).list();
return results;
} catch (RuntimeException re) {
throw re;
}
}

the debug sql from hibernate,

Hibernate: select this_.member_id as member1_25_0_, this_.name as name25_0_, this_.value as value25_0_ from member_profiles this_ where (1=1)

I don't know why the sql's criteria is not the one which i have specify for the the accountId.

what i except is,

select this_.member_id as member1_25_0_, this_.name as name25_0_, this_.value as value25_0_ from member_profiles this_ where (member_id=?)

any ideas?? or i have missed something in my mapping file??

Thanks in advance.

Jeffery

User the criteria and specify the FetchMode.JOIN in the criteria.


List<AccountProfile> results = List<AccountProfile>) sessionFactory.getCurrentSession().createCriteria("com.sysfotech.ums.bean.AccountProfile").setFetchMode("accountProfiles",FetchMode.JOIN).add(Expression.eq("accountId", id)

User the criteria and specify the FetchMode.JOIN in the criteria.


List<AccountProfile> results = List<AccountProfile>) sessionFactory.getCurrentSession().createCriteria("com.sysfotech.ums.bean.AccountProfile").setFetchMode("accountProfiles",FetchMode.JOIN).add(Expression.eq("accountId", id)

User the criteria and specify the FetchMode.JOIN in the criteria.


List<AccountProfile> results = List<AccountProfile>) sessionFactory.getCurrentSession().createCriteria("com.sysfotech.ums.bean.AccountProfile").setFetchMode("accountProfiles",FetchMode.JOIN).add(Expression.eq("accountId", id)

Indeed, the Criteria API would be a great tool for doing these types of queries, although, I must say, I'm not sure if it needed to be said three times. :)

Here's a very simple tutorial on creating Hibernate3 Criteria Queries:


http://www.hiberbook.com/HiberBookWeb/learn.jsp?tutorial=09howtousethecriteriaapi