Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:

3.0

Mapping documents:

<class
name="it.sella.cms.hbm.CmsMaCategory"
table="cms_ma_category"
>

<id
name="cgId"
type="java.lang.Long"
column="cg_id"
>
<generator class="identity"/>

</id>

Code between sessionFactory.openSession() and session.close():

List l = s.createQuery("from it.sella.cms.hbm.CmsMaCategory as st").list();

int size = l.size();
for(Iterator itr=l.iterator();size>0;size--){
CmsMaCategory st = (CmsMaCategory)itr.next();
s.evict(st);
LOG.info("st id/nme: "+st.getCgId()+"/"+st.getCgNme()+"/"+st.getCgDescr());
}

Full stack trace of any exception that occurs:

None.

Name and version of the database you are using:

MySQL 4.1

The generated SQL (show_sql=true):

select cmsmacateg0_.cg_id as cg1_, cmsmacateg0_.cg_nme as cg2_8_, cmsmacateg0_.cg_descr as cg3_8_ from cms_ma_category cmsmacateg0_

Debug level Hibernate log excerpt:

The DB query (hibernate generated sql) produces:



But when I run the program, I get the output:



Why is Hibernate not displaying the correct id corresponding to Java (1) and Oracle (2)? This is an application which was previously working in Hibernate2. After migration to 3.0, we are facing this.

Thanks in Advance.