• Post Reply Bookmark Topic Watch Topic
  • New Topic

EJB deployment error

 
Vaidehi Mehta
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I am using EJB2.0 for deploying an application on WebLogic 6.1. But, I am getting an error when I use nested queries inside the <ejb-ql> tag in ejb-jar.xml descriptor.
The error is something like "Could not parse EJB QL expression: SELECT OBJECT(o) from document_masterBean as o WHERE o.id IN(select u.usename from User_masterBean as u WHERE u.code = ?1))"
Can anyone please help me.
 
Marcelo Sousa Ancelmo
Ranch Hand
Posts: 498
Eclipse IDE Fedora Firefox Browser
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The EJB Specification fobid the use of subqueries, you can achieve this by using extensions provided by the App Server vendor, i.e. Weblogic in your case.
In JBoss, subqueries goes on the jbosscmp-jdbc.xml, in Websphere they go on ejb-jar.xml, you must read the Weblogic documentation to discover how you can make subqueries in EJB-QL
Regards,
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!