Docs don't make sense

**thehl** · Dec 15th, 2006, 06:44 AM

From the Spring 2.0 manual:

public class ProductDaoImpl extends HibernateDaoSupport implements ProductDao {
public Collection loadProductsByCategory(String category)
throws DataAccessException, MyException {
Session session = getSession(getSessionFactory(), false);
try {
List result = session.find(
"from test.Product product where product.category=?",
category, Hibernate.STRING);
if (result == null) {
throw new MyException("invalid search result");
}
return result;
}
catch (HibernateException ex) {
throw convertHibernateAccessException(ex);
}
}
}

But session doesn't have a find method. What am I missing?

Can anyone tell me how to create a query similar to the one above?

Thanks.

**karldmoore** · Dec 15th, 2006, 06:50 AM

Can you tell us where this is in the reference manual. If you find problems with it you should JIRA them. If you aren't going to do it, let me know and I'll do it.
http://www.springframework.org/support

Code:

public class ProductDaoImpl extends HibernateDaoSupport implements ProductDao {
    public Collection loadProductsByCategory(String category)
        throws MyException {
        
        List result = getHibernateTemplate().find("from test.Product product where product.category=?", category);
        if (result == null) {
            throw new MyException("invalid search result");
        }
        return result;
    }
}

**dejanp** · Dec 15th, 2006, 06:54 AM

The point of that part of documentation is not how to create queries, but how to get a hold of Hibernate session in different ways.

Once you have a Hibernate session you can use Hibernate docs to check the details.

If you don't want to/have to use Hibernate API directly, you can take a look at HibernateTemplate documentation.

**karldmoore** · Dec 15th, 2006, 07:01 AM

The examples should work though. I think this modified version of the example should work, this basically does what the HibernateTemplate does under the covers.

Code:

public class ProductDaoImpl extends HibernateDaoSupport implements ProductDao {
    public Collection loadProductsByCategory(String category)
        throws DataAccessException, MyException {
        
        try {
            Query queryObject = session.createQuery("from test.Product product where product.category=?");
            queryObject.setString(0, category)
            List result = queryObject.list();
            if (result == null) {
                throw new MyException("invalid search result");
            }
            return result;
        } 
        catch (HibernateException ex) {
            throw convertHibernateAccessException(ex);
        }
    }
}

http://www.springframework.org/docs/...hibernate-daos