Articles

Creating Connection Pool and DataSource in SOA

This article has a step by step procedure for creating the connection pool and Data source for SOA suite.
{tab=Creating Connection Pool}

1.Start the SOA Server Suite by going to Programs -> Oracle Cholassoa - > Start SOA Suite.
2.Then go to http://chola:8888/em.
3.In the Application Servers - > Cholassoa.chola -> home click on home.

4.Click Administration tab.

5.Click on JDBC Resources icon.

6.Go to Connection Pools and click Create.

7.Click Continue.

8.In URL click Generate URL from connection Information:
{xtypo_info}
Name : CholaDemo_pool
Connection Factory Class : oracle.jdbc.pool.OracleDataSource    
Driver Type : Thin
DB Host Name : Chola.apps
DB Listener Port : 1526
DB Identifier Type :SID
SID/Service Name:VIS
{/xtypo_info}
9.In the credentials give the user name and password:
{xtypo_info}
Username : sysadmin
Password: sysadmin
{/xtypo_info}

10.Click Test connection.

11.Click Finish after the test succeeded.

{tab=Creating Data Source}

1.Click on JDBC Resources.
2.Click Create on DataSources.

3.Click Continue.

4.Give the following properties:
{xtypo_info}
Name : CholaDemo_pool
JNDI Location : jdbc/CholaDemoDS
Transaction Level : Global & Local Transactions
Connection Pool : Select the pool that we created . That is CholaDemo_pool.
Login Timeout : 0
{/xtypo_info}

5.Click Finish.
{/tabs}

• < Prev
• Next >