Problem in executing Native Query in Eclipse Link

[Venu JaMocha]

StringBuilder query = new StringBuilder();
query.append("Select rt.id 'int1' from NodeMaster na INNER JOIN ");
query.append(" InterfaceMmaster im on im.nodeId = na.nodeId INNER JOIN ObjectMaster rt on  ");
query.append(" im.interfaceid = rt.id where na.templateId=1");


objQuery = em.createNativeQuery(nativeQuery, CommonVO.class);
objQuery.setFirstResult(offset);
result = objQuery.getResultList();

While executing this query in Open JPA, i received expected Result.
But Eclipse Link is showing an error by saying
" Missing descriptor for [class com.jamochatech.poc.util.CommonVO]"

Can someone help in this.

[tware]

Hi Venu,

   The error you are seeing is because, for some reason, EclipseLink does not
think CommonVO.class is an Entity in your model.

   Is CommonVO.class an Entity in your model?  If so, how is it defined?  Is it
annotated as an Entity? Is it listed in the persistence.xml as a class?  Is it
mapped via orm.xml?

-Tom

Venu JaMocha wrote:

> StringBuilder query = new StringBuilder();
> query.append("Select rt.id 'int1' from NodeMaster na INNER JOIN ");
> query.append(" InterfaceMmaster im on im.nodeId = na.nodeId INNER JOIN
> ObjectMaster rt on  ");
> query.append(" im.interfaceid = rt.id where na.templateId=1");
>
>
> objQuery = em.createNativeQuery(nativeQuery, CommonVO.class);
> objQuery.setFirstResult(offset);
> result = objQuery.getResultList();
>
> While executing this query in Open JPA, i received expected Result.
> But Eclipse Link is showing an error by saying
> " Missing descriptor for [class com.jamochatech.poc.util.CommonVO]"
>
> Can someone help in this.

_______________________________________________
eclipselink-users mailing list
eclipselink-users@...
https://dev.eclipse.org/mailman/listinfo/eclipselink-users