Creating JDBC Connection Pool/JDBC Data Source

Connection Pool Creation:

1.    Start admin server
 
2.    Go to http:///console and login
 
3.    Go to Services/JDBC/Connection Pools jdbc

4.    Click  Configure a new JDBC Connection Pool...

     a.    Select Database Type : Oracle
     b.    Select Database Driver  : Oracle’s Driver (Thin) version 9.0.1, 9.0.2,10
     c.    Click Continue
     d.    Enter following values
           i.    Name: XXXXXXXXXXX
           ii.    Database Name: XXXXXXX
           iii.    Host Name: XXXXXXXXXXXXX
           iv.    Port: XXXXXX
           v.    Database User Name: XXXXXXXXXXX
           vi.    Password: XXXXXX
           vii.    Confirm Password: XXXXXXXXXX
     e.    Click Continue
     f.    Click Test Driver Configuration, this must result in successful test. If not, review above steps
     g.    Select ejb and portal server as targets
     h.    Click Create and deploy
     i.    This will bring you back to Connection Pools list with new pool listed

5.    Now go to Services/JDBC/Data Sources and click

Configure a new JDBC Data Source
 
1.    Enter pcnDataSource for Name and JNDI Name
 
2.    Enable Emulate Two-Phase Commit for non-XA Driver
 
3.    Click Continue
 
4.    Select pcnPool from Pool Name list
 
5.    Select ejb and portal servers for target
 
6.    Click Create