Unsupported content This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

Configuring JDBC

  1. In the left navigation pane, select Security - Global Security.
  2. On the right navigation list, select Java Authentication and Authorization Service > J2C authentication data.
  3. In the Global security > JAAS - J2C authentication data form, 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 > Data Sources.
  7. In the Data sources form, select the Node=machineNameNode01, Server=server1 server scope.
  8. In the JDBC providers form, click New.
  9. In the Create new JDBC provider form, 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 Enter database class path information, enter DB Class Path information and click Next.
  12. In Summary, 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 Select JDBC provider, click Select an existing JDBC provider.
  19. Select the provider that you specified in step 9 from the list.
  20. Click Next.
  21. In Enter database specific properties for the data source, 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 Set up security aliases, 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 Summary, 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 Data sources, click Test connection to test your connection.
  30. Click Data Source DS.
  31. In Additional Properties on the right, click Connection pool properties.
  32. In General Properties, 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*