[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - 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


View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4154971#4154971

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4154971