1. Configuring Weblogic Server 12c
  2. Data Source creation and JDBC Configuration
  3. Data source creation: non XA

6.1 Data source creation: non XA

  1. Navigate to FCUBSDomain → Services → Data Sources → select New > Generic Data Source.Description of picture35.png follows
    Description of the illustration picture35.png
  2. Enter the Name and JNDI Name and Click on NextDescription of picture36.png follows
    Description of the illustration picture36.png
  3. Select the Driver as Oracle’s Driver(thin) for Instance connection: Versions: Any and Click on Next.Description of picture37.png follows
    Description of the illustration picture37.png
  4. Uncheck the Supports Global Transactions and click on Next.Description of picture38.png follows
    Description of the illustration picture38.png
  5. Enter the Database Name, Host Name, Port, Database User Name, Password, Confirm Password and click on Next.Description of picture39.png follows
    Description of the illustration picture39.png
  6. Replace the JDBC URL in the below format and click on Next.

    Default URL: jdbc:oracle:thin:@<IP_Adress>:<Port>:<INSTANCE_NAME>.

    Change the default URL to:

    dbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxxxxx.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=fcubs)))

    Where,

    Scan IP = xxxxxx.com

    Service Name = fcubs

    Port = 1521

    Make sure that in URL, we make the necessary changes.

    Then Click on Test Configuration. The connection test should be successful.Description of picture40.png follows
    Description of the illustration picture40.png

  7. Select Target as FCUBSCluster and click on Finish.Description of picture41.png follows
    Description of the illustration picture41.png

Parent topic: Data Source creation and JDBC Configuration