max wrote:
are you sure that is the query you run ? "select * from Message m" ? and do you do it through createSQLQuery().list() ?
anyways somehow your query or simply the database contains the same id for more than one row....have you chekked you data?
Well, here is the exact query:
2006-02-13 22:00:21,375 DEBUG [ROOT] (HibernateFuncs.java:75) - SQLQueryImpl(select {m.*} from Message m where category=:p1 order by dateTime desc)
It is through createSQLQuery().list()...
messageOid is the PK for Message, so yeah, I am still scratching my head. Is it possible for Hibernate to log the offending object and its id?