I used Criteria to create query but Exception occur.
My java code like here:
crit.add(Expression.ilike("bourseCode", model.getBourseCode()));

and xml like here:
<many-to-one name="bourseCode" class="com.bsteel.newbase.admin.marketdata.model.BourseCodeModel" column="BOURSE_CODE"/>

when I replace Expression.ilike with Expression.eq, it works well. What the matter? How can I query the foregin key with ilike?

eh?? ilike() doesn't seem to make sense for an association!

Exception fragment is the following:
net.sf.hibernate.MappingException: No persister for: java.lang.String

at net.sf.hibernate.impl.SessionFactoryImpl.getPersister(SessionFactoryImpl.java:338)

at net.sf.hibernate.impl.SessionImpl.getClassPersister(SessionImpl.java:2569)

at net.sf.hibernate.impl.SessionImpl.getPersister(SessionImpl.java:2576)

at net.sf.hibernate.impl.SessionImpl.getEntityIdentifierIfNotUnsaved(SessionImpl.java:2638)

at net.sf.hibernate.type.EntityType.getIdentifier(EntityType.java:66)

at net.sf.hibernate.type.ManyToOneType.nullSafeSet(ManyToOneType.java:46)

................

I had done it.
I modified my code :
crit.add(Expression.ilike("bourseCode.id", model.getBourseCode()));
and it runs well.