Hi, I am trying to get my first hibernate application working. Following the doc, i have a pojo class Category and a table with the same name.

1. i have the mapping added in element <session-factory> in hibernate.cfg.xml
2. I have category.hbm.xml with following entry for mapping
<class name="Category" table="CATEGORY">
<id name="categoryid" type="int" unsaved-value="null">
<column name="categoryid" sql-gtype="int" not-null="true"/>
</id>
....
</class>
3. I have program snippet

Session sess = HibernateUtil.currentSession();
Transaction tx = sess.beginTransaction();
Category cat = new Category();

Query query = sess.createQuery("select c from category as c where c.categoryid = :id");
query.setInteger("id", 1);

for(Iterator it = query.iterate(); it.hasNext();)
{
cat = (Category)it.next();
out.prntln("category " + cat.getCategoryName());
}

But i got error:

ERROR: category is no mapped
ERROR: invalid path: c.categoryid'

I got the CAT working following the document and i use the same hibernate.cfg.xml, also category.hbm.xml is modified based on CAT.hbm.xml.

Could any one tell me which part is missing in my config?

Thanks

HQL is case sensitive. Try Category instead of category in your query.

yes. i changed "category" to "Category" in the query:
select c from category as c where c.categoryid = :id to
select c from Category as c where c.categoryid = :id

But this really does not make much sense to me.

IS the category here referred in the query the java object instead of table?
sql is not case sensitive.

Can anybody explain?

Think of HQL as an object-oriented query language.