Now lets try to fetch the data and perform crud using JCA Adaptor and OSB.
Our prevoius post shows you how to perform DB operation using below given concept
‘- using an external webservice proxied by the OSB – Done
‘- using the fn-bea:execute-sql function from the OSB using Xquery
In this article I will try to show you how to perform CRUD using JCA DbAdapter from the OSB provided by Oracle as part of Oracle SOA Suite
Please follow below given steps for the same
1- Create a datasource as shown below
Start your integrated weblogic server and access its console. for me it is started on https://localhost:7101/console
Click on datasouce and new
Now go to deployment option of the Weblogic console as shown below
Go to DbAdaptor
Click on DbAdaptor
Enter eis/DB/SiddhuJCA as JNDI name (Note we had change the jdni Name to eis/DB now)
click on + icon and check if you are able to see your newly created JNDI
Click on it and Enter the datasourcename in this text box of XADatasourcename (jdbc/DB/SiddhuJCA) by double click in that property value field..enter the datasource name which we have created previously and click enter on keyboard and click save.
Go to deployments again and select the dBAdapter check box and click on update to take this changes effect.
That it now lets create a Database
Now lets run our database adapter JCA as shown belwo
1- Select
2- Insert
3- Delete
3- update
No comments:
Post a Comment