7 Replies Latest reply on Feb 4, 2009 11:24 AM by cubanacan

    Bitwise AND in EJB-QL

    carbonch

      Hi Everybody

      I couldn't find a way to us a bitwise AND operator in an EJB-QL Query. I'd like to have something like

      SELECT OBJECT(a) FROM Patient AS a WHERE a.registrationStatus & 1 = 0


      which should be similar to the SQL Statement

      SELECT * FROM Patient WHERE registrationstatus & 1 = 0;


      Is there a way to use bitwise operators in EJB-QL? I'm still using EJB 2.

      Thank in advance for all your hints.

      Kindest regards,
      Reto