Yes several instances of DeptBean were persisted before the
createNativequery was issued.  I am running 0.9.7-incubating-SNAPSHOT

On 1/10/07, Pinaki Poddar <[EMAIL PROTECTED]> wrote:


> Query updateDeptName = _em.createNativeQuery(sql,"DeptBeanMapping");
If any persistence operation using DeptBean.class preceeds this call
(e.g. _em.persist(new DeptBean())), then is there any change in
behavior?

Pinaki Poddar
BEA Systems
415.402.7317


-----Original Message-----
From: George Hongell [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 10, 2007 9:49 AM
To: open-jpa-dev@incubator.apache.org
Subject: Fwd: has @SqlResultSetMapping been tested

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)
_______________________________________________________________________
Notice:  This email message, together with any attachments, may contain
information  of  BEA Systems,  Inc.,  its subsidiaries  and  affiliated
entities,  that may be confidential,  proprietary,  copyrighted  and/or
legally privileged, and is intended solely for the use of the individual
or entity named in this message. If you are not the intended recipient,
and have received this message in error, please immediately return this
by email and then delete it.

Reply via email to