Creating JDBC connection pool & Datasource

Connection Pool Creation:

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


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

a.    Enter pcnDataSource for Name and JNDI Name
b.    Enable Emulate Two-Phase Commit for non-XA Driver
c.    Click Continue
d.    Select pcnPool from Pool Name list
e.    Select ejb and portal servers for target
f.    Click Create