Simple things (as below) work with 0.9.7 OpenJPA
public void testSQLQuery() {
EntityManager em = getEM();
em.getTransaction().begin();
Person original = new Person();
original.setFirst("OpenJPA");
em.persist(original);
em.getTransaction().commit();
String sql = "SELECT ID,AGE,FIRST,LAST FROM XYZ WHERE
ID="+original.getId();
Query query = em.createNativeQuery(sql, "SQLMapping");
Person result = (Person)query.getSingleResult();
assertNotNull(result);
assertEquals(original.getFirst(), result.getFirst());
}
where in Person.java
@SqlResultSetMapping(name="SQLMapping",
[EMAIL PROTECTED](entityClass=Person.class))
Your test surely is more complex than the above. Can you send us an
isolated example test, persistence.xml and failure stack trace?
Pinaki Poddar
BEA Systems
415.402.7317
-----Original Message-----
From: George Hongell [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 10, 2007 10:24 AM
To: open-jpa-dev@incubator.apache.org
Subject: Re: has @SqlResultSetMapping been tested
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.
>
_______________________________________________________________________
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.
