Configuring JDBC

  1. On the left navigation pane, select Security - Global Security.
  2. In the right navigation list, select Java Authentication and Authorization Service > J2C authentication data.
  3. In the Global security > JAAS - J2C authentication data window, create a New alias with the following information:
    • Alias: Database instance (sid)
    • User ID: Oracle User ID

    • Password: Oracle database password for the given user ID.

      Note

      Use the J2C user ID that you manually create in the IBM Console with user name and password corresponding to the Oracle database schema user name and password. For example, if the BMC IT Business Management Suite schema user name is ArAdmin and the password is AR#dmin, create a J2C record with user name ArAdmin and password AR#dmin in the IBM console.

  4. Click OK.
  5. Click Save in the Messages window at the top of the screen to commit the changes.
  6. From the left navigation pane in the main console window, select Resources > JDBC > JDBC providers.
  7. In the JDBC providers window, select the Node=machineNameNode01, Server=server1 server scope.
  8. In the JDBC providers window, click New.
  9. In the Create new JDBC provider window, specify the following options:
    • Database type: Oracle
    • Provider type: Oracle JDBC driver
    • Implementation type: XA data source
    • Name: Simple Provider
  10. Click Next.
  11. In the Enter database class path information field, enter DB Class Path information and click Next.
  12. In the Summary area, click Finish.
  13. Click Save in the Messages window at the top of the screen to commit the changes.
  14. From the left navigation pane in the main console window, select Resources > JDBC > Data sources.
  15. In Data sources, choose the server scope (for example, Node=machineNameNode01, Server=server1).
  16. To create a new data source, click New and in Enter basic data source information, specify the following information:
    • Data source name: SimpleDS
    • JNDI name: com/itmsoft/SimpleDataSource
  17. Click Next.
  18. In the Select JDBC provider field, click Select an existing JDBC provider.
  19. Select the provider that you specified in step 9 from the list.
  20. Click Next.
  21. In the Enter database specific properties for the data source field, specify the database attribute URL as the URL of the database from which the datasource obtains connections, such as jdbc:oracle:thin:@localhost:1521:sample.
  22. Click Next.
  23. In the Set up security aliases field, specify the values from the menu for:
    • Authentication alias for XA recovery
    • Component-managed authentication alias
    • Mapping-configuration alias as None
    • Container-managed authentication alias
  24. Click Next.
  25. In the Summary area, click Finish.
  26. Click Save in the Messages window at the top of the screen to commit the changes.
  27. Repeat steps 16 to 25 to create a new data source with the following information:
    • Data source name: DS
    • JNDI name: com/itmsoft/DataSource
  28. Click Save in the Messages box at the top of the screen to commit the changes.
  29. In the Data sources area, click Test connection to test your connection.
  30. Click Data Source DS.
  31. In the Additional Properties field on the right, click Connection pool properties.
  32. In the General Properties field, change the value of Maximum connections to 200 and Minimum connections to 10.
  33. Click Apply.
  34. Click Save in the Messages window at the top of the screen to save the changes.
  35. Repeat steps 30 to 34 for the SimpleDS data source.

 

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*