Posted in Adapters, DB Adapter, Enterprise Manager, tagged 10.1.3.1, application server, connection pool, datasource, db connection, em, jndi, Oracle SOA Suite, SOA on February 27, 2013| 1 Comment »
The following steps describes how to create a JNDI location so you can use it later on your DbAdapter
(The configuration is done on Oracle EM 10g(10.1.3.1) Application Server Control):
1. Create a Connection Pool
In the EM click on your OC4J server (where Bpel PM exists in):
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 »
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
….
Oracle Fusion Middleware 