Read the rules before posting!
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:2.1


<hibernate-mapping>
<class name="Conference.Paper" table="paper">
<id name="id" column="id" type="java.lang.Integer" unsaved-value="any">
<generator class="assigned"/>
</id>
<property name="title" column="title" type="string" not-null="true"/>
<property name="filetype" column="filetype" type="string" not-null="false"/>
<property name="abStract" column="abStract" type="string" not-null="false"/>
<property name="userid" column="userid" type="java.lang.Integer" not-null="true"/>

</class>
</hibernate-mapping>



StringBuffer s=new StringBuffer("select c from Paper as c where c.userid='");
s.append(userid);
s.append("'");
beginTransaction();
Query query=session.createQuery(s.toString());
Iterator it=query.iterate();
while(it!=null && it.hasNext())
{
Paper paper=(Paper)it.next();
System.out.println("Paperid="+paper.getId());
}

return it;



***********************************
the problem is weird: I can get all properties except id. It just looks like the getId() method always returns 0.Why??
Thanks.

Well, you are using generator=assigned, do you assign the ids?

Do you get any results in your Iterator it, what is the size of it.

But if you want to check the quick alternative to get the same thing you are doing, you can try this :-

List results = session.createCriteria(Paper.class)
.add( Expression.eq("userid", Obj.getUserID())).list();

And then iterate as you were doing, hope you will get the required results.

Forget to mention, best way to debug is turn on your sql statements in main hibernate mapping file, so you get the exact SQL generated and get to the error immediately.

srigold