Configuration of Database Adapter in SOA suite 12c

Introduction:

SOA application performs any database related operation like DMLA�operations (e.g. Select, Insert, update etc.), Invokes package procedure inA�database and is done by DB Adapter Services provided as part of Oracle SOA Suite.

Configuration steps:

In order to use Database adapter, it needs configuration such as creation of JDBC data source and JNDI (Java Naming and Directory Interface) and the same is configured using SOA Administration Console.

Now I am going to take you through the steps ofA�configuring database resource.

1. Open URL http://localhost:7101/console to enter into Administration Console page
2. In the left pane navigate to Services -> Data Sources
3. Click on NEW and select Generic Data Source
4. Give JDBC data source name and JNDI name (jdbc/leeDBConnection). Then select Database Type as Oracle
5. Click on NEXT and select Database Driver
6. Click on NEXT
7. Click on NEXT and enter database connection details like hostname,port,username and password
8. Click on NEXT
9. Click on a�?Test Configurationa��
10. If database details are correct, then it will show the message like a�?Connection test succeededa��.
11. Click on NEXT and select Target Server
12. Then click on FINISH. Now create outbound connection pool. Navigate to Deployments in the left pane -> DB Adapter from deployments list
13. Navigate to Configuration -> Outbound Connection Pools. Click on NEW
14. Select outbound connection group and click on NEXT
15. Enter JNDI name of database connection pool (eis/DB/myDBConnectionPool)
16. Click on FINISH and update the connection pool with the XADataSourceName. You have to explicitly press a�?ENTERa�� button to save the datasource name. Then click on SAVE button.
17. Again go to Deployments and select DB Adapter to update db adapter configuration file a�?Plan.xmla��.
18. Select the option a�?Redeploy this application using the following deployment filesa��.
19. Click on NEXT
20. Click on FINISH to finish the configuration of database resource.