OracleArea51

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:

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

9.In the credentials give the user name and password:

Username : sysadmin
Password: sysadmin

10.Click Test connection.

11.Click Finish after the test succeeded.

Creating Data Source

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

3.Click Continue.

4.Give the following properties:

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

5.Click Finish.