I am using the where attribute on class mappings extensively (as we use an InUse column to flag a row as being deleted, rather than actually deleting it for security reasons).

each of my class maps declares this like so:

<class name="User, Types" table="USERS" where="INUSE=1">

This works exactly as expected in NHibernate 0.7.*, but I recently did a build using 0.8.3 and on running I received the following message (from the log file):

Exception: System.Data.OracleClient.OracleException
Message: ORA-00936: missing expression

The problem appears to be down to the SQL being generated (again from the log):

SELECT this.USER_ID as USER_ID0_, this.SURNAME as SURNAME0_, this.ADDEDBY as ADDEDBY0_, this.LASTUPDATEDBY as LASTUPDA7_0_, this.FIRSTNAME as FIRSTNAME0_, this.DATEADDED as DATEADDED0_, this.INUSE as INUSE0_, this.PAYNUMBER as PAYNUMBER0_, this.DATELASTUPDATED as DATELAST8_0_ FROM USERS this WHERE 1=1 AND and this.INUSE=1

notice the "AND and" in the query.

If I revert to 0.7 this starts working again.

Mark

The "and and" bug should have been fixed in 0.8.3, please try that version. Be warned though that 0.8.3 still has another bug that affects Oracle. The bug was fixed in CVS and the fix will be part of 0.8.4 (scheduled to be packaged and released on Sunday or Monday).

sergey, thanks for the quick response. You're right I'm using 0.8.0, thought was up to date, but I think I can wait for the other fix in 0.8.4 next week.

Cheers

Mark