The following statement worked fine under hibernate3b2:

from Quiz q order by q.sortOrder asc where parentunit_id=:chapterId

when upgrading to hibernate3rc1, the very same statement throws:

org.hibernate.QueryException: Named parameter does not appear in Query: chapterId [from de.vierundsechzig.springer.model.modules.quiz.Quiz q order by q.sortOrder asc where parentunit_id= :chapterId]

but the named parameter obviously appears in the query. It looks like the where-clause is ignored completely: Even if i put a static id in the where (from de.vierundsechzig.springer.model.modules.quiz.Quiz q order by q.sortOrder asc where parentunit_id= 103) the where-clause never appears in the generated sql.

Any ideas, what has changed between b2 and rc1 that could have caused this behavior?

thx in advance!
stf

What happens if you put the where clause first?
I'm nore sure if it is an agreed standard, but shouldn't your restriction come before your sorting?

Also:

Is parentunit_id a property of Quiz?:

A related post: http://forum.hibernate.org/viewtopic.php?t=939335

resolved this one: The parser cuts off silently, whatever comes after the order by - phrasing the statement correctly solves the case.