Hi,
I think I found another error in JBoss EJB3 implementation.
If I execute the following query
| Query q = manager.createQuery("SELECT N FROM Customer N Where " +
| "(N.id = 1 AND N.name = 'Bill') "
| + " OR " +
| "(N.id = 2 AND N.name = 'Javier')");
|
JBoss generates the following SQL command
anonymous wrote :
| select
| customer0_.id as id11_,
| customer0_.name as name11_
| from
| Customer customer0_
| where
| customer0_.id=1
| and customer0_.name='Bill'
| or customer0_.id=2
| and customer0_.name='Javier'
|
that's wrong (in my opinion). The parenthesis should not removed from the where
clause.
Thanks in advance,
Javier
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3947438#3947438
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3947438
-------------------------------------------------------
All the advantages of Linux Managed Hosting--Without the Cost and Risk!
Fully trained technicians. The highest number of Red Hat certifications in
the hosting industry. Fanatical Support. Click to learn more
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=107521&bid=248729&dat=121642
_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user
