Hibernate version:
2.1
Mapping documents:

<class name="Merchant" table="MERCHANT" proxy="Merchant">
<id name="id" type="long" column="MERCHANTID">
<generator class="native"/>
</id>
<property name="name" column="NAME"/>
</class>

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

String sql = "select {m}.MERCHANTID as {m.id}, {m}.NAME as {m.name} " +"from MERCHANT {m} join PERSON p on {m}.MERCHANTID=p.MERCHANTID " + "where p.PERSONID=" + person.getId();
Query sqlQuery = session.createSQLQuery(sql, "m", Merchant.class);
List merchants = sqlQuery.list();

Full stack trace of any exception that occurs:
No Exception

Name and version of the database you are using:
Oracle 9i
The generated SQL (show_sql=true):
select m.MERCHANTID as MERCHANTID0_, m.NAME as NAME0_ from MERCHANT m join PERSON p on m.MERCHANTID=p.MERCHANTID where p.PERSONID=110

Debug level Hibernate log excerpt:


All of my list queries such as the above returns one fewer row than
they should be. That is, if I take the SQL generated and run it
directly, I get N rows. Hibernate, however, always returns N-1 rows
on the same query. What is going on???

Thanks.

Maroon

never mind. I found the problem in my code