Re: [eclipselink-dev] Error in EMQueryJUnitTestSuite.testcreateNativeQue

[Tom Ware <tom.ware@xxxxxxxxxx>]

Hi Sabine,

  I am not familiar with how the entity manager for the tests are created.  The 
part of the spec you are referring to is for Transaction-scoped entity managers. 
 Is the entity manager used in this test created in such a way that it will be 
transaction-scoped on all servers?

-Tom

Heider, Sabine wrote:
> Hi,
>  
> I’d like to get your opinion on an error I get when running the JPA 
> server tests inside an SAP NetWeaver application server (stack 
> shortened, executed on current trunk):
>  
> java.lang.IllegalStateException: Attempting to execute an operation on a 
> closed EntityManager.
> at 
> org.eclipse.persistence.internal.jpa.EntityManagerImpl.verifyOpen(EntityManagerImpl.java:1516)
> at 
> org.eclipse.persistence.internal.jpa.EJBQueryImpl.executeUpdate(EJBQueryImpl.java:492)
> at 
> org.eclipse.persistence.testing.tests.jpa.relationships.EMQueryJUnitTestSuite.testcreateNativeQueryWithSelectSQL(EMQueryJUnitTestSuite.java:121)
> at 
> org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBareServer(JUnitTestCase.java:463)
> at 
> org.eclipse.persistence.testing.framework.server.TestRunnerBean.runTest(TestRunnerBean.java:87)
>  
> I run the test against a MySQL database. The MySQL driver throws an 
> SQLException in EMQueryJUnitTestSuite line 114: Can not issue 
> executeUpdate() for SELECTs.
> Consequently, I end up in the catch block where the current transaction 
> is rolled back.
>  
> Chapter 7.9.1 of the JPA specification says:
> “After the JTA transaction has completed (either by transaction commit 
> or rollback), The container
> closes the entity manager by calling EntityManager.close.”
>  
> Apparently, this is what the JPA container in NetWeaver does. With the 
> closed entity manager, however, query2 becomes unusable.
>  
> In my opinion, it’s an error of the test rather than of the JPA 
> container, but I might be wrong. What do you think?
>  
> Thanks and best regards,
> Sabine
>  
> *Sabine Heider
> **SAP AG
>
> *Pflichtangaben/Mandatory Disclosure Statements:
> _http://www.sap.com/company/legal/impressum.epx_
>  
>  
>  
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> eclipselink-dev mailing list
> eclipselink-dev@xxxxxxxxxxx
> https://dev.eclipse.org/mailman/listinfo/eclipselink-dev