Saturday, 3 November 2018

SOA Database Adapter Configuration

1. In the left navigation bar, click Deployments.
2. Click the DbAdapter application (click the name, not the checkbox)
3. Click the Configuration tab, and then click the Outbound Connection Pools tab.
4. Click New
5. Select the radio button for javax.resource.cci.ConnectionFactory and click Next
6. Enter the JNDI Name: eis/db/dart_application_csvc/dart_application_csvc
7. Click Finish
8. Click the Configuration tab, then click the Outbound Connection Pools tab,
and expand the connection factory and click the connection pool eis/db/dart_application_csvc/dart_application_csvc (click on the name, not the checkbox)
9. Select the box to the far right of dataSourceName. An edit box will appear
10. Type in the data source name jdbc/dart_application_csvc/dart_application_csvc.
11. Press the ENTER key to apply the value.
12. Select Save.
13. Click Deployments in the left navigation bar.
14. Select the checkbox next to DbAdapter.
15. Click Update.
16. Select Redeploy this application and confirm the deployment plan location.
17. Click Finish
18. Confirm that the connection pool is added by accessing  DbAdapter >Configuration > Outbound Connection Pools and expanding the connection factory details.
19. Confirm the value of the xADataSource property.

4 comments:

  1. This step-by-step guide makes configuring the adapter much less intimidating. I’ve run into issues before when mapping JNDI names with data sources, so the clarity here is really helpful.

    ReplyDelete
  2. This walkthrough is clear and easy to follow—setting up the adapter can be tricky if the JNDI naming isn’t consistent. I faced a similar issue once where the database reference wasn’t applied correctly, and it caused connection pool errors until we redeployed.

    ReplyDelete