Hi,

Working on supporting a legacy database with Hiberante 3.0 RC1. The database uses a lot of bitfield columns which means a lot of our queries rely on binary & and binary | working. This used to work fine in Hibernate 2.1.x but now dies in Hibernate 3.x with "unexpected char: '&'" errors.

A typical query would look something like this

"select UserProfile u where status & 1 = 1"

Note that all this is running on PostgreSQL which does support such an operator.

Is it likely that Hibernate 3.x HQL will support bitwise operators? Or is there a better way of dealing with legacy databases with these types of columnes? Possibly an EnumSet?

Thanks,
Dan

you can always use native sql queries.

otherwise i dont think we have plan/support for bitwise operations.
It only works in H2 because that parser where more forgiven than the one in H3 which is more correct.


add a jira for the request of bitwise operators - but no promises.