[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
|
RE: [eclipselink-users] COMMIT is not allowed in a subordinate session
|
Hi,
I have seen and would expect this SQL error on a transactional JTA connection in an EE container when trying to do DDL generation.
DDL generation on Oracle for create table statements have an implicit "commit" of their own on the database. We therefore do not recommend use of DDL generation in a container managed JTA transaction (that already has its own commit) - RESOURCE_LOCAL transactional-mode is ok. Try removing your following transactional jdbc property
eclipselink.jdbc.exclusive-connection.mode=Transactional
Thank you
/michael
----------Original Message----------
From: depstei2 <depstei2@xxxxxxx>
Sent: Fri, April 10, 2009 3:59 PM
To: eclipselink-users@xxxxxxxxxxx
Subject: [eclipselink-users] COMMIT is not allowed in a subordinate session
I'm running eclipselink 1.1 with atomikos JTA, Spring and Oracle and I am
getting
[EL Warning]: 2009-04-10
14:13:49.812--ServerSession(24223536)--Thread(Thread[main,5,main])--Exception
[EclipseLink-4002] (Eclipse Persistence Services - 1.1.0.r3639-SNAPSHOT):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: ORA-02089: COMMIT is not allowed
in a subordinate session
when the tables are being generated.
I thought this issue was addressed already for 1.1. Our app works fine with
eclipselink and derby, and the same configuration we are using is also
working using both hibernate and openjpa on oracle.
The eclipse settings we have are
eclipselink.weaving=false
eclipselink.application-location=target
eclipselink.ddl-generation=drop-and-create-tables
eclipselink.ddl-generation.output-mode=database
eclipselink.jdbc.exclusive-connection.mode=Transactional
eclipselink.target-server=org.kuali.student.common.util.jta.AtomikosJtaTransactionController
(this just returns a com.atomikos.icatch.jta.UserTransactionManager in
acquireTransactionManager())
We are not using JNDI, could that be a problem?
--
View this message in context: http://www.nabble.com/COMMIT-is-not-allowed-in-a-subordinate-session-tp22992922p22992922.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.
_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users
