FMW14c - Creating Outbound Connection Instance

Oracle Technology

The Oracle SOA DbAdapter outbound connection requires various procedures to ensure that the SOA composite communicates efficiently with the database.
To deploy an outbound connection in WebLogic 14c, configure the outbound connection pool properties for a resource adapter.

Outbound connection pools in a resource adapter are defined in the ra.xml and weblogic-ra.xml deployment descriptors. 
You can also utilize the Administration Remote Console to change the pool's properties. Properties you change in the remote console will be saved in a deployment plan.

First, in WebLogic server, build a JDBC data source with the appropriate database connection information, including the database name, host, port, user name, and password. This data source is used to create a connection with the database.

Next, in the DbAdapter deployment under Monitoring Tree in the Remote Console, create an outbound connection pool. This includes selecting the proper connection group and inputting the JNDI name, which must match the value provided in the developed application or service.

Navigate Remote Console to add Outbound Connection Pool instance: Monitoring Tree > Deployment > Application Management > DbAdapter > Configuration > Outbound Connection Pool Groups

Deploy and update the DBAdapter application using the updated outbound connection pool. This includes selecting the DbAdapter application from the Deployments page, hitting the Update button, and verifying the deployment plan location.

This blog's content is intended solely for informational purposes. While every effort is made to ensure accuracy, completeness, and relevance, the information may not be current or applicable in all situations. The opinions expressed are solely those of the author and do not reflect the views of any organization they may be affiliated with.