QueryException: could not resolve property: class of

bostone · **Joined:** Tue Mar 14, 2006 3:58 pm **Posts:** 3

I'm using Spring 2.5, Hibernate 3.2.6.ga and Oracle9Dialect. I'm trying to execute criteria query which fails with this message

Code:

 org.hibernate.QueryException: could not resolve property: class of: com.nams.model.DeviceSummaryView

Here's the code: basically I have example class that may contain various properties some of which can have a wildcard

Code:

   private List<DeviceSummaryView> searchByCriteria(DeviceSummaryView example)
         throws IllegalAccessException, InvocationTargetException,
         NoSuchMethodException {
      assert(example != null);
      DetachedCriteria criteria = DetachedCriteria
            .forClass(DeviceSummaryView.class);
      Map<String, Object> propMap = BeanUtils.describe(example);
      Set<Entry<String, Object>> set = propMap.entrySet();
      for (Entry<String, Object> entry : set) {
         Object value = entry.getValue();
         if (value != null && String.class.isInstance(value))
         {
            if (value.toString().indexOf('%') >= 0)
            {
               criteria.add(Expression.like(entry.getKey(), value));
            } else
            {
               criteria.add(Property.forName(entry.getKey()).eq(value));
            }
         }
      }
      // DAO will simply call HibernateTemplate#findByCriteria
      return this.deviceSummaryViewDao.findByCriteria(criteria);
   }

Cameron McKenzie · **Posted:** Wed May 14, 2008 12:57 pm

I think the problem is here:

Code:

Expression.like(entry.getKey(), value)

Whatever entry.getKey() is resolving to isn't actually a visible property in the class on which you are searching.

Can you debug and see what the value of getKey() is? Then check to see that the property exists in the class you are searching on, and that there is a public getter method?

bostone · **Joined:** Tue Mar 14, 2006 3:58 pm **Posts:** 3

Cameron! You are genius! But of course, the describe map would contain "class" property which in my code gets added as search criteria. After changing the following line:

Code:

if (value != null && String.class.isInstance(value))

to

Code:

if (!"class".equals(entry.getKey()) && value != null && String.class.isInstance(value))

Everything works as expected. Thanks a lot! Of course I do realize now that I have to pay attention to any other non-property fields my example class may have.