When calling a stored procedure from SOA Suite 11g (Bpel/OSB/BPM ….) , you might get the following error:
….
java.sql.SQLSyntaxErrorException: ORA-02089: COMMIT is not allowed in a subordinate session
….
Posts Tagged ‘xa’
ORA-02089 – COMMIT is not allowed
Posted in Adapters, DB Adapter, tagged 11g, adapter, commit, connection pool, datasource, db, dbadapter, global, local, non-xa, oracle, Oracle SOA Suite, SOA, transacrion, xa on April 22, 2012| 17 Comments »
-
search for…
-
Contact the author
Subscribe to posts
Categories
- Adapters (10)
- DB Adapter (6)
- FTP Adapter (4)
- ADF (10)
- Bpel (14)
- Activities (5)
- Email (2)
- Java Embedded (2)
- Human Task (1)
- Activities (5)
- BPM (3)
- Development (5)
- Enterprise Manager (5)
- Installation (10)
- Application Server (2)
- DB (3)
- RCU (4)
- SOA Suite (3)
- JDeveloper (6)
- Repository (1)
- SangIT (1)
- UCM (1)
- Uncategorized (5)
- WebLogic (3)
- Adapters (10)
Blog visitors
- 360,503 Visitors
Tags
10.2.0.1 10.3.6 10g 11.1.1.6.0 11g 11gr1 530 activity adapter adf application archive auto recovery bean bpel bpelconsole bpm case sensitive commit configuration connection pool datasource db dbadapter db connection dbRepository Creation Utility deployment download dynamic parameter em email email activity fault FTP ftpadapter get global html human task Installation instances java Java Embedded JDeveloper jndi jta jvm local mds Middleware non-xa oracle Oracle BPM Suite Oracle Database Express Edition Oracle Linux Oracle SOA Suite oracle soa suite 12c parameter Pure SQL Operation put RCU SOA SOA DB tables SOA Suite SQLException stale states timedoutexception timeout transacrion user weblogic worklist xa XECopyright information
Oracle Fusion Middleware 