I tried using both a native query and it failed, has it ever been tested? also named native query with resultSetMapping fails at runtime, also @SqlResultSetMappings does not seem to be implemented in openjpa and fails in the MappingTool with *java.lang.ArrayStoreException*
using @SqlResultSetMapping(name="DeptBeanMapping", [EMAIL PROTECTED](entityClass=DeptBean.class ) ) this fails Query updateDeptName = _em.createNativeQuery(sql,"DeptBeanMapping"); this works // Query updateDeptName = _em.createNativeQuery(sql,DeptBean.class); <4|true|0.9.7-incubating-SNAPSHOT> org.apache.openjpa.persistence.ArgumentException: There is no query result mapping for "null" with name "DeptBeanMapping". at org.apache.openjpa.jdbc.meta.MappingRepository.getQueryResultMapping( MappingRepository.java:175) at org.apache.openjpa.jdbc.kernel.SQLStoreQuery$SQLExecutor.<init>( SQLStoreQuery.java:174) at org.apache.openjpa.jdbc.kernel.SQLStoreQuery.newDataStoreExecutor( SQLStoreQuery.java:143) at org.apache.openjpa.kernel.QueryImpl.createExecutor(QueryImpl.java:718) at org.apache.openjpa.kernel.QueryImpl.compileForDataStore(QueryImpl.java :676) at org.apache.openjpa.kernel.QueryImpl.compileForExecutor(QueryImpl.java :658) at org.apache.openjpa.kernel.QueryImpl.getOperation(QueryImpl.java:1463) at org.apache.openjpa.kernel.DelegatingQuery.getOperation( DelegatingQuery.java:120) at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:214) at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java :264) at com.ibm.ws.query.tests.JUNamedNativeQueryTest.testSelectDeptBean( JUNamedNativeQueryTest.java:457)