"JCA Binding execute of Reference operation 'insert' failed" with DB Adapter

Problem:

The SOA 11g BPEL process is using a database adapter. However, upon execution, the DB Adapter would not work and following exception is returned:

Error Message:
Fault ID    reference:40019
Fault Time    Mar 13, 2011 9:28:07 PM
Non Recoverable System Fault :
Exception occured when binding was invoked. Exception occured during invocation of JCA binding: "JCA Binding execute of Reference operation 'insert' failed due to: Could not create/access the TopLink Session. This session is used to connect to the datastore. Caused by javax.resource.spi.InvalidPropertyException: Missing Property Exception. Missing Property: [ConnectionFactory> xADataSourceName or dataSourceName]. You may have set a property (in _db.jca) which requires another property to be set also. Make sure the property is set in the interaction (activation) spec by editing its definition in _db.jca. . You may need to configure the connection settings in the deployment descriptor (i.e. DbAdapter.rar#META-INF/weblogic-ra.xml) and restart the server. This exception is considered not retriable, likely due to a modelling mistake. ". The invoked JCA adapter raised a resource exception. Please examine the above error message carefully to determine a resolution.

The JNDI referenced in the code was eis/db/PerfTest, yet this is already configured in WebLogic Server 11g.

Solution:

1. Log in to the WebLogic Administration console

2. Navigate to:

Home --> Summary of Deployments --> JmsAdapter --> Summary of Deployments --> DbAdapter

3. Add the data source (e.g., jdbc/db/PerfTest) to the connection factory.

Application Versions:

• WebLogic Server 11g (10.3.x)
• Oracle SOA Suite 11g (11.1.1.x)