topic Schema creation with JTA and Oracle database in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/schema-creation-with-jta-and-oracle-database/m-p/48372#M27657 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><BR /><SPAN>We are facing an issue during schema creation at the first Activiti startup. We are using Activiti inside a Spring application using an embedded Jencks/Geronimo JTA transaction manager which connect to an Oracle 11g database instance.</SPAN><BR /><BR /><SPAN>During schema creation, we have the following exception thrown by Activiti:</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />2011-09-07 16:56:18,676 [&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; main] ERROR [&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; o.a.e.i.d.DbSqlSession] problem during schema create, statement 'create table ACT_GE_PROPERTY ( <BR />NAME_ NVARCHAR2(64), <BR />VALUE_ NVARCHAR2(300), <BR />REV_ INTEGER, <BR />primary key (NAME_) <BR />)<BR />java.sql.SQLSyntaxErrorException: ORA-02089: COMMIT is not allowed in a subordinate session<BR /><BR />&nbsp;&nbsp;&nbsp;at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)<BR />&nbsp;&nbsp;&nbsp;at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)<BR />&nbsp;&nbsp;&nbsp;at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)<BR />&nbsp;&nbsp;&nbsp;at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)<BR />&nbsp;&nbsp;&nbsp;at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)<BR />&nbsp;&nbsp;&nbsp;at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)<BR />&nbsp;&nbsp;&nbsp;at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:194)<BR />&nbsp;&nbsp;&nbsp;at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1000)<BR />&nbsp;&nbsp;&nbsp;at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)<BR />&nbsp;&nbsp;&nbsp;at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1882)<BR />&nbsp;&nbsp;&nbsp;at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1847)<BR />&nbsp;&nbsp;&nbsp;at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:301)<BR />&nbsp;&nbsp;&nbsp;at org.tranql.connector.jdbc.StatementHandle.execute(StatementHandle.java:121)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:800)<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>What happens is the following:</SPAN><BR /><UL><LI>we have configured activiti to use the jta transaction using this spring bean</LI><PRE class="language-none line-numbers"><CODE>&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp; &lt;bean id="processEngineConfiguration" class="org.activiti.spring.SpringProcessEngineConfiguration"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="databaseType" value="${activiti.datasource.databasetype}" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="dataSource" ref="dataSource" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="transactionManager" ref="transactionManager" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="transactionsExternallyManaged" value="true"/&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="databaseSchemaUpdate" value="true" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="jobExecutorActivate" value="false" /&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;/bean&gt;<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><LI>at startup activiti wants to create the schema</LI><BR /><LI>a new JTA transaction is started</LI><BR /><LI>the DDL statements are always executed in autocommit by Oracle</LI><BR /><LI>so the exception is thrown</LI></UL><SPAN>My question is: is there a way to tell activity to not participate in JTA transaction for the schema creation/update part ?</SPAN><BR /><BR /><SPAN>Thx for your help !</SPAN></BODY></HTML> Wed, 07 Sep 2011 15:18:15 GMT wismax 2011-09-07T15:18:15Z Schema creation with JTA and Oracle database https://connect.hyland.com/t5/alfresco-archive/schema-creation-with-jta-and-oracle-database/m-p/48372#M27657 Hello,We are facing an issue during schema creation at the first Activiti startup. We are using Activiti inside a Spring application using an embedded Jencks/Geronimo JTA transaction manager which connect to an Oracle 11g database instance.During schema creation, we have the following exception thro Wed, 07 Sep 2011 15:18:15 GMT https://connect.hyland.com/t5/alfresco-archive/schema-creation-with-jta-and-oracle-database/m-p/48372#M27657 wismax 2011-09-07T15:18:15Z Re: Schema creation with JTA and Oracle database https://connect.hyland.com/t5/alfresco-archive/schema-creation-with-jta-and-oracle-database/m-p/48373#M27658 <HTML><HEAD></HEAD><BODY><SPAN>I think there is a Jira issue already for this.</SPAN></BODY></HTML> Wed, 07 Sep 2011 16:47:22 GMT https://connect.hyland.com/t5/alfresco-archive/schema-creation-with-jta-and-oracle-database/m-p/48373#M27658 ronald_van_kuij 2011-09-07T16:47:22Z Re: Schema creation with JTA and Oracle database https://connect.hyland.com/t5/alfresco-archive/schema-creation-with-jta-and-oracle-database/m-p/48374#M27659 <HTML><HEAD></HEAD><BODY><SPAN>same thing with Atomikos XA datasources see here </SPAN><A href="http://forums.activiti.org/en/viewtopic.php?f=6&amp;t=1869" rel="nofollow noopener noreferrer">http://forums.activiti.org/en/viewtopic.php?f=6&amp;t=1869</A></BODY></HTML> Thu, 08 Sep 2011 07:32:48 GMT https://connect.hyland.com/t5/alfresco-archive/schema-creation-with-jta-and-oracle-database/m-p/48374#M27659 heymjo 2011-09-08T07:32:48Z