SOA 12c DB Adapter configuration

There could be scenarios where BPEL Service need to integrated with Database for the persistence or data retrieval while developing  custom SOA Services. The below given are the steps to  configure the DB Adapter in the SOA Project.

Select the DB Adapter from the Components -> Technology

SOA 12c DB Adapter configuration

Provide the name to the DB Adapter which need to be configured

DB Adapter configuration wizard

Create or select the created database connection details

Database Connection

Select the Database Operation Type

DB Adapter operation type

Select the database table by clicking on Import Tables button and select the columns that are required

DB Adapter Import Table

Select the option which need to be performed once the new records are picked for processing

DB Adapter after read action

Update the values for the Logical Delete , Read records and Unread records

DB Adapter logical delete

Update the Database Polling options as per the application need.  Select the Distributed Polling in case of Clustered environment.

DB Pooling Options

Add the parameter binding in case of run time value to be passed to the Database SQL or Edit the provided SQL in case of any additional check to be updated.

DB Selection Criteria

Update the Java Connector End Point Properties as per application need

Click Finish to complete the Database Adapter Configuration Wizard.

The DB Adapter will be configured in the SOA Project with the selected options in the Configuration Wizard.

DB Adapter in composite


SOA interview questions and answers

What is a Web Service ?

Web Service is an standard way of integrating the web based applications using XML, SOAP, WSDL , UDDI standard to interact among different applications running on different technologies due to its interoperability feature supported being XML based ,  for the exchange of data.

soa web-service

There are mainly two types of web services.

  1. SOAP web services
  2. Restful web services

What is a WSDL ?

WSDL stands for Web Services Description Language , is an XML-based language used to describe the Web Services ( location of the service, and the methods of the service). It uses the below given elements

<types>  –        provides the (XML Schema) data types used by the web service

<message> –   provides  the data elements for each operation

<portType> –   provides the operations that can be performed and the messages involved.

<binding> –      provides the protocol and data format for each port type

What is SOAP ?

SOAP stands for Simple Object Access Protocol , is an XML based protocol for accessing Web Service.

What is a XML Schema ?

XML Schema defines the structure of an XML document also known as XML Schema Definition (XSD). It provides the list of elements and attributes with the data types to be used ( integer , string , etc).

What is Oracle Fusion Middleware ?

Oracle Fusion Middleware is the collection of different software products provided together for building  UI based applications with middleware integrations and usage of different technologies combined together to achieve complex business solution with ease.  Oracle Fusion Middleware offers complete support for development, deployment, and management.  Oracle Fusion Middleware includes the below products

  • Service-Oriented Architecture (SOA)
  • Oracle Service Bus ( OSB)
  • Application Development Framework (ADF)
  • Application Architecture Integration (AIA)
  • Business Intelligence
  • Oracle Identity Management
  • Oracle Data Integration
  • Oracle WebLogic Server for deployment and management of applications, adapter, web services , authentication

What is SOA ?

SOA stands for  Service Oriented Architecture .  Oracle SOA  is one of the software products (Oracle SOA Suite) of  the Oracle Fusion Middleware developed by Oracle  which acts as a middleware layer for the integration between different applications. It provides a complete set of service infrastructure components for designing, deploying, and managing composite applications. It enables services to be created, managed, and orchestrated into composite applications and business processes.

It includes the following components:

  • BPEL Process Manager  (bpel, Mediator, Rules, B2B, and Human Workflow)
  • Oracle Business Activity Monitoring (BAM)
  • Oracle Business Process Management (BPM) Suite

Advantages of using Oracle SOA

  • Loose coupling
  • Reusability
  • Interoperability
  • Flexible

What are the components provided by the  Oracle SOA Suite ?

  • BPEL Process Manager
  • Mediator
  • Human Workflow
  • Business Rules
  • Adapters – ( File Adapter , JMS (Queue and Topic) Adapters, , AQ Adapters,  DB Adapter, Coherence Adapter)
  • BAM – Business Activity Monitoring
  • Oracle B2B
  • OWSM
  • Business Events
  • Complex Event Processing

Optimize and tuning for weblogic data source connection timeout

Data source connectivity is quite important for an application and make sure that all possible features are set and available before executing the application scenarios:

Weblogic Connection Pool Settings

  1. Maximum Capacity: This is calculated based on the number of sessions allocated in database / number of weblogic servers. If total sessions is 200 and 4 weblogic servers , then maximum capacity will be 200 /5 = 40
  2. Initial Capacity:  This includes the number of sessions made available at the time when server starts. It is also said that keep the initial capacity to maximum capacity so that all connections are available but the server will not be able to use all the available connections till it reaches the peak load.
  3. Capacity Increment: Ideal value for this should be less than 10. I have kept 5 only.
  4. Shrinking Frequency: This indicates the number of seconds to wait before shrinking a connection pool that has incrementally increased to meet demand.
  5. Statement cache type:  The most commonly used algorithm is LRU (default).  LRU stands for Least Recently Used. Weblogic Server caches the executed statements to avoid database call for the same statement required to be executed again by some other thread.  Once the cache is full then weblogic server determines which existing statement in the cache was the least recently used and replaces that statement in the cache with the new statement.
  6. Seconds to Trust an Idle Pool Connection: This indicates the number of seconds within a connection use that weblogic server trusts that the connection is still viable and will skip the connection test, either before delivering it to an application or during the periodic connection testing process. Default value is 10.
  7. Connection Timeout: While creating the data source, add the below property in the connection pool tab for adding the increased value for the connection timeout. Oracle.net.CONNECT_TIMEOUT=10000000
  8. Statement cache size:  The number of prepared and callable statements stored in the cache.  The statement cache depends upon  below factors:

–          Number of servers which data source deployed

–          Maximum connection for data source

–          Maximum cursor open allowed on database side

Weblogic statement caches related to database cursor and cache contains too many statements and reaches maximum limit of open cursors can impact the server performance. Try to reduce Statement Cache Size setting value or   increase maximum open cursors allowed for a connection


How to do a multiple composite deployment

The blog discuss the steps on “how to deploy the SOA Composites”, “multiple composite deployment in WebLogic Server” . The SOA Composites can be deployed, redeployed and undeployed using Ant and WLST scripts to the Weblogic SOA Server or it can be deployed using the WebLogic Administrator console. 

Point to Consider for SOA Composite deployment:

  • A new developed SOA Composite is deployed for the 1st time
  • A existing SOA Composite with the new revision(2.0) can be deployed. This will make a new deployment in SOA Server and will not impact the existing deployed SOA Composite(1.0)
  • Multiple SOA Composites can be deployed at once as part of single deployment process also called as SOA Bundle. The bundle can contains different revisions for different SOA Composites.

SOA Composite Deployment to WebLogic SOA Server

Perform the below given steps for SOA Composite deployment based on provided options

  • Log into the Weblogic em console for SOA applications

Navigate to SOA Infrastructure Menu

  • Select SOA Deployment > Deploy

Navigate to SOA Folder

  • Right-click soa-infra
  • Select SOA Deployment > Deploy

Navigate to SOA Infrastructure Home Page

  • Click the Deployed Composites tab.
  • Click Deploy

Navigate to SOA Composite Menu

  • Select SOA Deployment > Deploy Another Composite

From the above given options, the server navigates to the SOA Deployment Process

  • Archive or Exploded Directory -> browse the SOA composite application to deploy
  • Configuration Plan -> Select the configuration plan to deploy for SOA Composite application. The configuration plan provides the URL and property value based on deployment environment
  • Click Next
  • Select the WebLogic Server or Cluster for SOA Composite deployment
  • Click Next
  • Review the deployment details
  • Select whether to deploy the SOA composite application as the default revision
  • Click Deploy

Multiple SOA Composite Deployment to WebLogic SOA Server

Perform the below given steps for multiple SOA Composite deployment as part of SOA Bundle

  • 1. Select the Application Properties dialog, click Deployment.
  • 2. Click New and create a deployment Profile.
  • 3. Select SOA Bundle in the archive type list
  • 4. Provide a name in the name field and click OK.
  • 5. Select the dependencies node.
  • 6. Select the SARs that need to be included in the Bundle
  • 7. Click OK.
  • 8.  From the application menu, select Deploy -> <bundle_name>  and deploy to the Application Server Connection.

Redeploying SOA Composite to WebLogic SOA Server

Perform the below given steps for redeploying the SOA Composite in Weblogic Server based on provided options

  • Log into the Weblogic em console for SOA applications

Navigate to SOA Infrastructure Menu

  • Select SOA Deployment >Redeploy
  • SOA Composite Deployments -> Select the SOA Composite application revision
  • Click Next

Navigate to SOA Folder

  • Right-click soa-infra
  • Select SOA Deployment > Redeploy
  • SOA Composite Deployments -> Select the SOA Composite application revision
  • Click Next

Navigate to SOA Infrastructure Home Page

  • Click the Deployed Composites tab
  • Select the SOA Composite application revision
  • Click Deploy

Navigate to SOA Composite Menu

  • Select SOA Deployment > Redeploy

From the above given options, the server navigates to the SOA Deployment Process

  • Archive or Exploded Directory -> browse the SOA composite application to deploy
  • Configuration Plan -> Select the configuration plan to deploy for SOA Composite application. The configuration plan provides the URL and property value based on deployment environment
  • Click Next
  • Select the WebLogic Server or Cluster for SOA Composite deployment
  • Click Next
  • Review the deployment details
  • Select whether to deploy the SOA composite application as the default revision
  • Click Redeploy

Undeploying SOA Composite to WebLogic SOA Server

Perform the below given steps for undeploying the SOA Composite in Weblogic Server based on provided options

  • Log into the Weblogic em console for SOA applications

Navigate to SOA Infrastructure Menu

  • Select SOA Deployment >Undeploy
  • SOA Composite Deployments -> Select the SOA Composite application revision
  • Click Next

Navigate to SOA Folder

  • Right-click soa-infra
  • Select SOA Deployment > Undeploy
  • SOA Composite Deployments -> Select the SOA Composite application revision
  • Click Next

Navigate to SOA Infrastructure Home Page

  • Click the Deployed Composites tab
  • Select the SOA Composite application revision
  • Click Undeploy

Navigate to SOA Composite Menu

  • Select SOA Deployment > Undeploy

From the above given options, the server navigates to the SOA Deployment Process

  • Click Undeploy

Exception occured during invocation of JCA binding: “JCA Binding execute of Reference operation ‘insert’ failed due to: JCA Binding Component connection issue. JCA Binding Component is unable to create an outbound JCA (CCI) connection.

The blog discuss the common issue related to invocation of JCA binding in Weblogic Server.

Problem Statement:

JCA Binding execute of Reference operation ‘insert’ failed due to: JCA Binding Component connection issue

Cause for JCA Binding connection issue ?

The connection factory configured in Weblogic Server for the Database Adapter is not being defined with the data source value and due to that the run time connection issue occurs.

Solution Approach:

Perform the below given steps to resolve JCA Binding Component connection issue

  • Click on the Deployment
  • Click on the DBAdapter and it should have the status ACTIVE
  • Click on the Configurations
  • Click on the Outbound Connection Pools
  • Select the Connection Factory e.g eis/Apps
  • Check for the Property dataSource. If your DataSource is Non-XA then define the JNDI Name value and press ENTER
  • Check for the Property XADataSource . If your DataSource is XA then define the JNDI Name value and press ENTER
  • Click OK