XA Enabled Data Source

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

To create the XA enabled data source, follow the steps given below:
  1. Start the Administrative Console of the WebLogic application server. Enter the Oracle WebLogic Admin Console URL in the address bar in an internet browser.
    Oracle Weblogic Server - Welcome screen is displayed.

    Figure 8-1 Oracle Weblogic Server - Welcome



  2. Specify the WebLogic Administrator Username and Password, click Log In.
    Oracle Weblogic Server - Home Page screen is displayed.

    Figure 8-2 Oracle Weblogic Server - Home Page



  3. Under the Change Center, click on the Lock & Edit button.
  4. Go to Data Sources.
    Summary of JDBC Data Sources screen is displayed.

    Figure 8-3 Summary of JDBC Data Sources



  5. On the left pane, under Domain Structure, expand Services and then Data Sources under it. Click the Lock & Edit button.
    Summary of JDBC Data Sources - Configuration screen is displayed.

    Figure 8-4 Summary of JDBC Data Sources - Configuration



  6. To create a new data source, click New and select Generic Data Source from the drop-down.
    Create a New JDBC Data Source screen is displayed.

    Figure 8-5 Create a New JDBC Data Source



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

    Table 8-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.
    Create a New JDBC Data Source - JDBC Data Source Properties screen is displayed.

    Figure 8-6 Create a New JDBC Data Source - JDBC Data Source Properties



  9. Select the database driver from the drop-down list and click Next.
    Create a New JDBC Data Source - Transaction Options screen is displayed.

    Figure 8-7 Create a New JDBC Data Source - Transaction Options



  10. On the Create a New JDBC Data Source - Connection Properties screen, specify the Database Name, Host Name, Port of the database server to connect, Database User Name, Password and Confirm password.
    Create a New JDBC Data Source - Connection Properties screen is displayed.

    Figure 8-8 Create a New JDBC Data Source - Connection Properties



  11. Click Next.
    Create a New JDBC Data Source - Test Database Connection screen is displayed.

    Figure 8-9 Create a New JDBC Data Source - Test Database Connection



  12. Specify the Driver Class Name (Eg: oracle.jdbc.OracleDriver).
  13. Specify the URL as jdbc:oracle:thin:@10.10.10.10:1001<INSTANCE_NAME>.
  14. Specify the Database Username (Eg: FCPB1121) and password.
  15. Confirm the password.
  16. Click on Test Configuration button.
  17. If the connection is established successfully, the message Connection test succeeded is displayed.
    Create a New JDBC Data Source - Messages screen is displayed.

    Figure 8-10 Create a New JDBC Data Source - Messages



  18. Click Next.
    Create a New JDBC Data Source - Select Targets screen is displayed.

    Figure 8-11 Create a New JDBC Data Source - Select Targets



  19. Check the boxes against the required servers and click Finish.
    Summary of JDBC Data Sources - New Data Source screen is displayed.

    Figure 8-12 Summary of JDBC Data Sources - New Data Source



  20. Click the Activate Changes button on the left pane. The message All the changes have been activated. No restarts are necessary is displayed.
    Summary of JDBC Data Sources - Activate Changes Message screen is displayed.

    Figure 8-13 Summary of JDBC Data Sources - Activate Changes Message



  21. Refer to Resources_To_ Be_Created.doc for the list of XA data sources to be created.
New Data Source is created.