I'm using Hibernate 3.2, jdk 1.4, and spring 2.0

I was using HQL before for a query, but I want to change to use QBC instead. In HQL, the a portion of the query looks like this and it works fine:

String hql = "from FileCycleHistory fileCycleHistory "
+ " and UPPER(fileCycleHistory.feedFile.fileName) like '"
+ inFileName.toUpperCase()
+ "'";

I want to change this to QBC like this:

DetachedCriteria crit = DetachedCriteria.forClass(FileCycleHistory.class);

if (inFileName != null && inFileName.trim().length()!=0) {
inFileName = inFileName.replace('*','%');
crit.add(Restrictions.ilike("feedFile.fileName",inFileName));
}

However, I'm getting an error:
org.hibernate.QueryException: could not resolve property: feedFile.fileName of: com.fmrco.imt.fams.domain.FileCycleHistory

Queries where I just get a string within fileCycleHistory work fine, but this one needs to fetch a string within a FeedFile object in fileCycleHistory and it's giving me an error.

Any idea what's wrong here?

Thanks.

For associations you have to create a subcriteria or an alias :
http://www.hibernate.org/hib_docs/v3/re ... sociations

Thanks for the info. That has made one of my queries work, but the other one is a little more complex.

I have some code here:
DetachedCriteria crit = DetachedCriteria.forClass(FileDependency.class);

if (inFileName != null && inFileName.trim().length()!=0) {
inFileName = inFileName.replace('*','%');
crit.add(Restrictions.or(
crit.createCriteria("feedFile").add(Restrictions.ilike("fileName",inFileName)),
crit.createCriteria("dependsOnFile").add(Restrictions.ilike("fileName",inFileName))
)
);

Because I am using spring, I need to create a detached query and then call it via the hibernateTemplate.

How do I set an "or" condition using a detached query? Restrictions.or only works for arguments (Criteria, Criteria), but I have arguments (DetachedCriteria, DetachedCriteria) so the above code has an error.

Thanks.

Maybe you can use createAlias instead of createCriteria and then use or(Restriction, Restriction) as it is shown in the doc