0 Replies Latest reply on Apr 10, 2002 2:59 AM by Paw Dybdahl

    EJBQL with i.<fieldname> = FALSE fails

    Paw Dybdahl Newbie

      Hi, this goes for JBoss 3.0 compiled from CVS-checkout 5. april 2002.

      Having an EJBQL including SELECT OBJECT(i) FROM WorkOrder AS i WHERE i.isSentToServer = FALSE ... generates a JDBCException with the explanation: 'No such column: false'.

      The field isSentToServer is of type boolean and is mapped by the MS SQLSERVER2000 type mapping to a BIT. I am using the SQL Server 2000 JDBC Driver from Microsoft.

      I guess it is the containers responsibility to generate the right SQL-statement before executing it by the JDBC-driver?