1. Payments Weblogic Configuration
  2. Create Resources on Weblogic
  3. Resource Administration
  4. Create Data Source
  5. Non-XA Enabled Data Source

Non-XA Enabled Data Source

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

To create the Non-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-14 Oracle Weblogic Server - Welcome


    Description of Figure 8-14 follows
    Description of "Figure 8-14 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-15 Oracle Weblogic Server - Home Page


    Description of Figure 8-15 follows
    Description of "Figure 8-15 Oracle Weblogic Server - Home Page"

  3. Go to Data Sources.
    Summary of JDBC Data Sources screen is displayed.

    Figure 8-16 Summary of JDBC Data Sources


    Description of Figure 8-16 follows
    Description of "Figure 8-16 Summary of JDBC Data Sources"

  4. 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-17 Summary of JDBC Data Sources - Configuration


    Description of Figure 8-17 follows
    Description of "Figure 8-17 Summary of JDBC Data Sources - Configuration"

  5. 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-18 Create a New JDBC Data Source


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

  6. On the Create a New JDBC Data Source screen, specify the fields.
    For more information on fields, refer to the field description table.

    Table 8-3 Create a New JDBC Data Source

    Field Description
    JDBC Datasource Name Name of the Datasource.
    JNDI Name JNDI for lookup.
    Database Type Oracle
  7. Click Next.
    Create a New JDBC Data Source - JDBC Data Source Properties screen is displayed.

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


    Description of Figure 8-19 follows
    Description of "Figure 8-19 Create a New JDBC Data Source - JDBC Data Source Properties"

  8. Select the database driver as shown in the figure. For Payments Online datasource, check Support Global Transactions and Select Logging Last Resource.
    Create a New JDBC Data Source - Transaction Options screen is displayed.

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


    Description of Figure 8-20 follows
    Description of "Figure 8-20 Create a New JDBC Data Source - Transaction Options"

  9. For other datasources, click Next. The following screen is displayed:
    Create a New JDBC Data Source - Connection Properties screen is displayed.

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


    Description of Figure 8-21 follows
    Description of "Figure 8-21 Create a New JDBC Data Source - Connection Properties"

  10. The Create a New JDBC Data Source - Connection Properties defines the connection properties.
  11. Specify the Database Name, Host Name, Port of the database server to connect, Database User Name, Password, and Confirm the password.
  12. Click Next.
    Create a New JDBC Data Source - Test Database Connection screen is displayed.

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


    Description of Figure 8-22 follows
    Description of "Figure 8-22 Create a New JDBC Data Source - Test Database Connection "

  13. Specify the Driver Class Name (Eg: oracle.jdbc.OracleDriver).
  14. Specify the URL as jdbc:oracle:oci:@10.10.10.10:1010:<INSTANCE_NAME> from jdbc:oracle:thin:@10.10.10.10:1001<INSTANCE_NAME>.
  15. Specify the Database Username (Eg: testdb) and password.
  16. Confirm the password.
  17. Click on Test Configuration button.
  18. 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-23 Create a New JDBC Data Source - Messages


    Description of Figure 8-23 follows
    Description of "Figure 8-23 Create a New JDBC Data Source - Messages"

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

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


    Description of Figure 8-24 follows
    Description of "Figure 8-24 Create a New JDBC Data Source - Select Targets"

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

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


    Description of Figure 8-25 follows
    Description of "Figure 8-25 Summary of JDBC Data Sources - New Data Source"

  21. 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-26 Summary of JDBC Data Sources - Activate Changes Message


    Description of Figure 8-26 follows
    Description of "Figure 8-26 Summary of JDBC Data Sources - Activate Changes Message"

  22. The FCUBSDS datasource is created.
  23. Click the Datasource, and then click on the Connection Pool tab.
    Settings for fcjdevDS - Connection Pool screen is displayed.

    Figure 8-27 Settings for fcjdevDS - Connection Pool


    Description of settings-connection-pool.jpg follows
    Description of the illustration settings-connection-pool.jpg

  24. On the Settings for fcjdevDS - Connection Pool screen, select the statement cache type as LRU from the drop-down list.
  25. Specify the statement cache size as 200.
  26. Click on Save button.
  27. Refer to Resources_To_ Be_Created.doc for the list of Non-XA data sources to be created.
    Note the following:
    • You need to create another data source for Oracle FCpayments with the JNDI name ‘<Non-XA FCUBS HOST JNDI name>_ASYNC’ for the batch process. For example, if the Oracle FCUBS HOST Non-XA data source JNDI name is jdbc/fcjdevDS, then you need to create another data source for FCUBS with the JNDI name jdbc/fcjdevDS_ASYNC.
    • While creating a branch using the Branch Parameters Maintenance (STDBRANC) screen, if you have created a data source for the branch, then you need to create a corresponding ASYNC data source with the JNDI name <Non-XA FCpayments BRANCH JNDI name>_ASYNC.

Parent topic: Create Data Source