I am a new user and playing Hibernate 2.1.8. Everything seems OK except I got a strange returned query results. In order to get my first Hibernate code worked, I use a simple query statement something like Criteria crt = HibernateUtil.getSession().createCriteria(
Message.class);
crt.add(Expression.between("postedDate", start, end));
crt.add(Expression.eq("author", author));
crt.addOrder(Order.asc("postedDate"));
Collection c = crt.list();
logger.debug("# of records:" + c.size());
When I run my code, I did get results and the logger reports correct size. But the interesting thing is all records are identical (to the first one) if I display them. Then I use the Hibernate generated sql statement to manually run ang got results as expected.
My database is Oracle 9i.

Any comments? Thanks very much for your help.
Yongping

post your display code...maybe it's a get(0) instead of get(i)

Actually I use
Iterator it = c.iterator();
while(it.hasNext())
{
msg = (Message)it.next();
logger.debug(msg.getTitle() + "|" + ...);
}
47 records are totally exactly the same.

Thanks for your info.

Y.P

OK. I got it fixed. Actually I made a mistake on id mapping. I thought key generator (in this case, only reading data out of from database) doesn't matter, so I use native (in fact, pk is defined as VARCHAR(12) in my database). I am proved wrong. it works fine if I changed it to uuid.hex.

Thanks
YP