tags:

views:

16

answers:

0
Q: 

Eclipselink subquery error

The following NamedQuery is giving a parsing error in Eclispelink . please help

@NamedQuery(name = "OaaFlexrolesUnitT.findFlexRolesAvailableUsers", query = "select c.netId,a.emplname from IsiEdbBasT a,NyuEdbEmpT b,OaaUserRolesT c where a.emplid=b.emplid and a.emplstat <> 'X' and a.orgid = ' ' and a.qtrno = 0 and a.orgid = b.orgid and a.qtrno = b.qtrno and b.netid = c.netId and c.roleId = :role1 and c.netId not in (select netid from OaaFlexrolesUnitT where unit = :unit and division = :division and roleId = :role2)")

related questions

Can I specify a JPA compliant persistence.xml file on the java command line?
What is a good design for a query "layer" for Java JPA
Fix for Hibernate error "Use of the same entity name twice"
JPA and inheritance
Again with JPA not making sense
JPA and 2 simple tables
JPA - Unknown entity bean class
Hibernate.initialize() and second-level cache
JPA annotations and Interfaces
Another JPA Question
Enterprise App and the Enterprise App Client
When to use Hibernate/JPA/Toplink?
Can Seam 2.0.2sp1 apps run on Tomcat 5.5.9 with JBoss Embedded?
JPA 1 is not good enough
Which EJB 3 persisent provider should I use?
What are the best books for Hibernate & JPA?
Compound keys in JPA
Is there a Problem with JPA Entities, Oracle 10g and Calendar Type properties?
persistence.xml not found during maven testing
JPA Multiple Transaction Managers
Hibernate (JPA) how to do an eager query, loading all child objects
JEE SqlResultSetMapping Syntax problem?
Batch insert using JPA/Toplink
Enabling Hibernate second-level cache with JPA on JBoss 4.2
Detach an entity from JPA/EJB3 persistence context