-
1. Re: Bitwise AND in EJB-QL
cubanacan Jan 23, 2009 4:52 AM (in response to carbonch)Hi, carbonch
I have the same problem, except using EJB 3.0.
Have you solved this? -
2. Re: Bitwise AND in EJB-QL
dgeraskov Jan 23, 2009 5:04 AM (in response to carbonch)Try to create SQLFunction and add it to your dialect.
See here.
http://forum.hibernate.org/viewtopic.php?t=940978&highlight=bitwise -
3. Re: Bitwise AND in EJB-QL
dgeraskov Jan 23, 2009 5:05 AM (in response to carbonch)Also you can create your own stored procedure and use it.
-
4. Re: Bitwise AND in EJB-QL
carbonch Jan 23, 2009 5:14 AM (in response to carbonch)Hi
Thank for your posts. At the end I just used different queries checking for specific integer values. Fortunately there wasn't that much.
have fun,
Reto -
5. Re: Bitwise AND in EJB-QL
cubanacan Jan 26, 2009 6:54 AM (in response to carbonch)Hi dgeraskov
Do you know how to define user function in Oracle Toplink instead of Hibernate? -
6. Re: Bitwise AND in EJB-QL
dgeraskov Jan 26, 2009 7:21 AM (in response to carbonch)oracle have bitand(first, second) function.
Se how to create function in oracle toplink here^
http://www.oracle.com/technology/products/ias/toplink/doc/1013/MAIN/_html/expres008.htm -
7. Re: Bitwise AND in EJB-QL
cubanacan Feb 4, 2009 11:24 AM (in response to carbonch)Thanks for answers. Useful.
I'm using EntityManager methods createQuery and createNamedQuery.
So I need to define user function for JPQL (EJB QL) query or named query.
May be you know how can I do it?