7.1.2 XA Enabled Data Source

This topic explains the systematic instructions to create the XA enabled data source in the Weblogic application server.

Follow the steps given below to create the XA enabled data source for Gateway Application (MDB):
  1. Start the Administration Console of the WebLogic Application server. Enter the Oracle WebLogic Admin Console URL in the address bar in an internet browser. For example:http://10.10.10.10:1001/console
    The Oracle WebLogic Server Login screen is displayed.

    Figure 7-1 Weblogic Application Server Login



  2. Specify the Username and Password in the WebLogic Server domain and click Login.
    The Oracle Weblogic Server Home Page screen is displayed.

    Figure 7-2 Oracle Weblogic Server Home Page



  3. Click the Lock & Edit button under the Change Center section to add, modify or delete items.
    The Summary of JDBC Data Sources screen is displayed.

    Figure 7-3 Summary of JDBC Data Sources



  4. On the left pane, under Domain Structure, expand the node Services and click Data Sources from the list.
    The Summary of JDBC Data Sources_Configuration screen is displayed.

    Figure 7-4 Summary of JDBC Data Sources



  5. Navigate to Data Sources section.
    The Summary of JDBC Data Sources_Data Sources screen is displayed.

    Figure 7-5 Data Sources_New_Generic Data Source



  6. Click New to create a new data source and select Generic Data Source from the drop-down.
    Create a New JDBC Data Source_JDBC Data Source Properties screen is displayed.

    Figure 7-6 Create a New JDBC Data Source_JDBC Data Source Properties



  7. On the Create a New JDBC Data Source screen, specify the fields.

    Table 7-2 Create a New JDBC Data Source

    Field Description
    JDBC Datasource Name Name of the data source.
    JNDI Name JNDI name which will be used for lookup.
    Database Type Specify the database type as Oracle from the drop-down list.
  8. Click Next to specify Database Driver.
    Create a New JDBC Data Source_Database Driver screen is displayed.

    Figure 7-7 Create a New JDBC Data Source_Database Driver



  9. Select the XA database driver from the drop-down list and click Next to specify the transaction options.
    Create a New JDBC Data Source_Transaction Options screen is displayed.

    Figure 7-8 Create a New JDBC Data Source_Transaction Options



  10. Click Next to define the connection properties. On the Create a New JDBC Data Source_Connection Properties screen, specify the Database Name, Host Name, Port of the database server to connect to the Database User Name, Password, and Confirm Password.
    Create a New JDBC Data Source_Connection Properties screen is displayed.

    Figure 7-9 Create a New JDBC Data Source_Connection Properties



  11. Click Next.
    Create a New JDBC Data Source_Test Database Connection screen is displayed.

    Figure 7-10 Create a New JDBC Data Source_Test Database Connection



  12. Specify the Driver Class Name.
    For Example: oracle.jdbc.OracleDriver.
  13. Specify the URL as jdbc:oracle:thin:@10.10.10.10:1001<INSTANCE_NAME>.
  14. Specify the Database Username.
    For Example: FCPB1121
  15. Specify password and confirm the password.
  16. Click Test Configuration tab in the Create a New JDBC Data Source screen.
    If the connection is established successfully, the message Connection test succeeded is displayed.
    Create a New JDBC Data Source_Messages screen is displayed.

    Figure 7-11 Create a New JDBC Data Source_Messages



  17. Click Next to select targets.
    Create a New JDBC Data Source_Select Targets screen is displayed.

    Figure 7-12 Create a New JDBC Data Source_Select Targets



  18. Select the boxes against the required servers and click Finish.
    Summary of JDBC Data Sources_New Data Source screen is displayed.

    Figure 7-13 Summary of JDBC Data Sources_New Data Source



  19. Click the Activate Changes button under the Change Center section of the screen.
    The message All the changes have been activated. No restarts are necessary. is displayed.
    The Summary of JDBC Data Sources screen is displayed.

    Figure 7-14 Change Center_Activate Changes



  20. On the Summary of JDBC Data Sources screen, you can view the new data source created in the Data Sources section.
    Refer to unresolvable-reference.html#GUID-74C0D61B-7D45-4776-99C2-8D9829E74773 for the list of XA data sources to be created.
    The new Data Source is created. For Example: FLEXTEST.WORLD