ORA-02089 – COMMIT is not allowed

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
….

The reason for that error(you can use one of them):
You have defined a data source base on Global Transaction (XA)
In a Global Transaction, the ‘Two-Phase Commit’ protocol for global transaction processing is automatically being selected. It means that the Weblogic server is responsible to complete all of the transactions (or non of them).
In short – adding a COMMIT to your code (being invoked) is not allowed.
There are few ways to solve this error:

1. Change the data source to use Non-XA
   (and check  the “Supports Global Transactions” & “Emulate Two-Phase Commit” buttons)
2. Delete the COMMIT from your code.
3. Use the “PRAGMA AUTONOMOUS_TRANSACTION“. This will kind of create a separate transaction that will allow to use a commit.For example:CREATE PROCEDURE XXX AS
   PRAGMA AUTONOMOUS_TRANSACTION;
   BEGIN …

WebLogic Server 11g Errors and their Solutions

Problem 1: 

While deploying ADF application into WebLogic Server 11g, Getting following error:

=================================================================== 

An error occurred during activation of changes, please see the log for details.

[J2EE:160149]Error while processing library references. Unresolved application library references, defined in weblogic-application.xml: [Extension-Name: adf.oracle.domain, exact-match: false].

================================================================== 

Solution:

Step 1)

Login to WebLogic Server 11g Console

Step 2) 

Click on Deployements

Step 3) 

Click on adf.oracle.domain(1.0,11.1.1.2.0) library

Step 4) 

Click on Targets tab and select the server where the application going to be deployed

Step 5) 

Click on "Save"

Do the same steps from 3 to 5 on following librarys too

a) adf.oracle.businesseditor(1.0,11.1.1.2.0)

b) adf.oracle.domain.webapp(1.0,11.1.1.2.0)

c) jstl(1.2,1.2.0.1)

d) jsf(1.2,1.2.9.0)

Now try to deploy your application again, that's it from Haridas.