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

Data source creation: non XA

  1. Navigate to FCUBSDomain  Services  Data Sources  select New  Generic data source.

    Figure 7-1 Summary of JDBC Data Sources


    Description of Figure 7-1 follows
    Description of "Figure 7-1 Summary of JDBC Data Sources"

  2. Enter the Name and JNDI Name and Click on Next.

    Figure 7-2 Create a New JDBC Data Source


    Description of Figure 7-2 follows
    Description of "Figure 7-2 Create a New JDBC Data Source"

  3. Select the Driver as “Oracle’s Driver (thin) for Instance connection: Versions: Any” and Click on Next.

    Figure 7-3 Create a New JDBC Data Source


    Description of Figure 7-3 follows
    Description of "Figure 7-3 Create a New JDBC Data Source"

  4. Uncheck the “Supports Global Transactions” and click on Next.

    Figure 7-4 Create a New JDBC Data Source


    Description of Figure 7-4 follows
    Description of "Figure 7-4 Create a New JDBC Data Source"

  5. Enter the Database Name, Host Name, Port, User Name, Password, Confirm Password and Click on Next.

    Figure 7-5 Create a New JDBC Data Source


    Description of Figure 7-5 follows
    Description of "Figure 7-5 Create a New JDBC Data Source"

  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:

    jdbc:oracle:oci:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOS
    T=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 changes to reflect oci.
    Then Click on Test Configuration. The connection test should be successful.

    Figure 7-6 Create a New JDBC Data Source


    Description of Figure 7-6 follows
    Description of "Figure 7-6 Create a New JDBC Data Source"

  7. Select Target as FCUBSCluster and click on Finish.

    Figure 7-7 Create a New JDBC Data Source


    Description of Figure 7-7 follows
    Description of "Figure 7-7 Create a New JDBC Data Source"

Parent topic: Data Source creation and JDBC Configuration