Jay Jay - 2 months ago 22
Java Question

Weblogic datasource configuration for DB on Oracle Dataguard with PDB

We are moving to Oracle Dataguard with PDB.

Currently we just point to a single DB url in Weblogic datasource configuration.

How to configure the Datasource in weblogic for Oracle Dataguard with PDB ?
Should we use 'JDBC Multi Datasource' ?

Jay Jay
Answer

The link provided by @Emmanuel Collin in the comments has the complete details.

And for those who need short answer, in weblogic server I have created a 'GridLink Data Source' and added the multiple DB server configuration details.

And the DB connection URL came out like below. And it worked fine.

jdbc:oracle:thin:@
    (DESCRIPTION=
        (
            ADDRESS_LIST=(LOAD_BALANCE=on)
                (ADDRESS=(PROTOCOL=TCP)(HOST=MY_DB_SERVER1)(PORT=1521))
                (ADDRESS=(PROTOCOL=TCP)(HOST=MY_DB_SERVER2)(PORT=1521))
        )
        (
            CONNECT_DATA=(SERVICE_NAME=MY_SERVICE)
        )
    )   
Comments