Hi,
I'm facing the following problem, when deploying a project to decision center from rule designer :
java.sql.SQLException: The transaction is no longer active - status: 'Marked rollback. [Reason=weblogic.transaction.internal.AppSetRollbackOnlyException: setRollbackOnly called on transaction]'. No further JDBC access is allowed within this transaction.
I am using weblogic 12c with an Oracle 12c database, and a datasource configured using the following driver : "oracle.jdbc.OracleDriver" and the following transaction configuration :
Answer by Miriam.Kaestner (8892) | Jul 29, 2015 at 05:29 AM
You can increase the heap size of Weblogic domain and re-test. If the AppSetRollbackOnlyException persists, consult Oracle support to understand how to diagnose this exception
Answer by NicolasRegnier (16) | Aug 28, 2015 at 11:47 AM
Hi,
I experienced the issue, unchecking "Prend en charge les transactions globales" with the Non XA Driver made it work for me.
oracle.jdbc.OracleDriver is the non-XA driver. Global Transaction can be used only with an XA driver, for example, oracle.jdbc.xa.client.OracleXADataSource
DC does not use global transactions Also Oracle DDL statements automatically generate commit operations that cause errors when used with a Global Transaction Manager ==> SQL scripts to create or alter database schema cannot get executed from DC using this configuration. So the preferred option is to disable Global Transactions, and to use a non-XA driver.