Creating database resources in SOA Suite 11.1.1.3 -part2

Log in to console

http://localhost:7001/console

Go to domain structure -->Services-->JDBC-->Data Sources

Click new



give data source name and its jndi properties






Provide details for your database

As i have created a user arpit i will be using the same here



Test your configuration



Say next and select the targer server for your application



Now create a connection pool

Go to deployment and click on dbAdapter



No got to Configuraiton-->Outbound connection pool and create a new conenction pool







And den say finish

Now again you will get an option to save the deployment plan.

Last time while creating the jms resource i have used th default location this time use some different location otherwise same deployment plan will be overwritten.

You first need to create the folder and then navigate till that folder from console to save the deployment plan.



Now again choose the new connection pool that you have created



give the jdbc name that you have created earlier as an Xa datasource name and save it.




Now again go to deployment select db adpater and select update ,the same way we have done in our last exercise for JMS moudles.