1. Weblogic Configuration
  2. Resource Administration
  3. Creating Data Source
  4. Non-XA Enabled Data Source

7.2.1.3 Non-XA Enabled Data Source

  1. Follow the steps given below:Start the Administrative Console of Weblogic application server. You can start this by entering Oracle Weblogic Admin Console URL in the address bar in an internet browser.

    http:10.10.10.10:1001/console Eg: http://10.10.10.10:1001/consoleDescription of picture17.png follows
    Description of the illustration picture17.png

  2. Specify the Weblogic administrator user name and password. Click ‘Log In’.
  3. Navigate to Oracle Weblogic home page.Description of picture18.png follows
    Description of the illustration picture18.png

    The following screen is displayed:Description of picture19.png follows
    Description of the illustration picture19.png

  4. Expand ‘Services’ and then ‘Data Sources’ under it. Click ‘Lock & Edit’ button.Description of picture20.png follows
    Description of the illustration picture20.png
  5. To create a new data source, click ‘New’ and select ‘Generic Data Source’.Description of picture21.png follows
    Description of the illustration picture21.png
  6. Specify the following details:
    JDBC Datasource Name Name of the Datasource
    JNDI Name JNDI for lookup
    Database Type Oracle
  7. Click ‘Next’.Description of picture22.png follows
    Description of the illustration picture22.png
  8. Select the database driver as shown in the figure. Click ‘Next’.

    Following screen is displayed:Description of picture23.png follows
    Description of the illustration picture23.png

  9. Select Logging Last Resource then uncheck ‘Support Global Transactions’. Click ‘Next’. The following screen is displayed:Description of picture24.png follows
    Description of the illustration picture24.png
  10. This screen defines the connection properties. Set the details as given below:
  11. Specify the Database Name, Host Name, Port of the database server to connect, Database User Name and Password. Confirm the password.
  12. Click ‘Next’. The following screen is displayed.Description of picture25.png follows
    Description of the illustration picture25.png
  13. Specify the Driver Class Name (Eg: oracle.jdbc.OracleDriver)
  14. Specify the URL.

    Default URL: jdbc:oracle:thin:@10.10.10.10:1001:<INSTANCE_NAME>.

    Change the default URL to: jdbc:oracle:oci:@10.10.10.10:1010:<INSTANCE_NAME>

  15. Specify the Database Username (Eg: testdb) and password.
  16. Confirm the password.
  17. Click ‘Test Configuration’ tab.
  18. If the connection is established successfully, the message ‘Connection test succeeded’ is displayed.Description of picture26.png follows
    Description of the illustration picture26.png
  19. Click ‘Next’. The following screen is displayed:Description of picture27.png follows
    Description of the illustration picture27.png
  20. Check the boxes against the required servers(for data source jdbc/fcjdevDS, it is mandatory to check the admin server as well as application-deployed server). Click ‘Finish’. The following screen is displayed:Description of picture28.png follows
    Description of the illustration picture28.png
  21. Click ‘Activate Changes’ button. Click ‘Activate Changes’ button on the left pane.

    The message ‘All the changes have been activated. No restarts are necessary’ is displayed.Description of picture29.png follows
    Description of the illustration picture29.png

  22. FCUBSDS’ datasource is created.
  23. Click the datasource, and then click on the Connection Pool tab.Description of picture30.png follows
    Description of the illustration picture30.png
  24. Select the statement cache type as ‘LRU’.
  25. Specify the statement cache size as ‘200’.
  26. Click ‘Save’.
  27. Refer to “Resources_To_ Be_Created.doc” for the list of Non-XA datasources to be created.
    TRADE Note the following
    • You need to create another data source for Oracle FCUBS with the JNDI name ‘<Non-XA FCUBS HOST JNDI name>_ASYNC’ for 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 FCUBS BRANCH JNDI name>_ASYNC’.
    • You need to create another data source for Oracle ELCM with the JNDI name ‘<ENTITY_ID JNDI name>_EL’. 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_EL’. Ensure that the checkbox “Support Global Transaction” is checked and select "Emulate Two-Phase Commit" for ELCM data source.
    • The following are the list of datasources that can be created depending on the requirement. Please refer to the document Resources_to_ be_created.docx for more information -
      Purpose Datasource Name JNDI Name
      FCUBS FCUBS Data source jdbc/fcjdevDS
      SMS SMS_Datasource jdbc/fcjdevDSSMS
      VAMS VAMS_DATASOURCE jdbc/fcvamDS
      Gateway FLEXTEST.WORLD FLEXTEST.WORLD
      Async data source FCUBS DS_ASYNC jdbc/fcjdevDS_ASYNC
      Scheduler Scheduler_Datasource jdbc/fcjSchedulerDS

Parent topic: Creating Data Source