Hi
How portable accross several DB is the use of
IN with a value that is a
component ?
Eg : Let's say a property of my entity is a Name being composed of firstName and lastName.
If I want to write an HQL query like ;
Code:
...where name in (:name1,:name2,:name3)
The generated SQL query will be on Oracle something like :
Code:
...where (FIRSTNAME,LASTNAME) in ((?,?),(?,?),(?,?))
It seems this SQL IN construct may not work on some DB as it is Oracle specific, Can all the dialects of all the DB supported by Hibernate handle this kind of HQL IN requests ? Are there exceptions ?
Thanks
Login
FAQ
Search