Creating the Non-XADataSource for Oracle or DB2

As with the XADataSource, creating the non-XADataSource involves specifying connection information for your database and setting some custom options.

  1. On the left side of the console, click JDBC providers.

  2. Verify that Node=<server_name><node_number>, Server=server1 is selected.

  3. Click New.

    The Create new JDBC provider screen appears.

  4. From the Database type list, select Oracle or DB2.

  5. In the Provider type list, click one of the following:

    • Oracle JDBC Driver

    • DB2 Universal JDBC Driver Provider

  6. From the Implementation type list, select Connection pool data source.

  7. Click Next.

  8. In the Directory location text box, verify that the path to the JDBC driver file for Oracle or DB2 appears. If it is not present, add it to the text box.

    For Oracle, this is the the ojdbc6.jar file you downloaded in About the Driver File for Oracle.

    For DB2, this should be the JDBC driver in the java/ subdirectory of your DB2 installation directory.

  9. Click Next.

  10. Review the summary.

  11. Click Finish.

  12. In the Name column on the right side of the console, click Oracle JDBC Driver or DB2 Universal JDBC Provider.

  13. In the Additional Properties area on the right side of the console, click Data sources.

  14. Click New.

  15. In the Data source name text box, type the following entry:

    Fiper NonXA Data Source

  16. In the JNDI name text box, type the following entry:

    fiper/jdbc/nonXADataSource

  17. Click Next.

  18. For an Oracle database, do the following:

    1. Enter the following information for the URL setting (in the Value text box):

      jdbc:oracle:thin:@hostname:port:databasename

      where:

      hostname is the computer name where Oracle is running,

      port is the appropriate port number on which the Oracle database is listening, and

      databasename is the name of the SIMULIA Execution Engine database.

      For example, if the hostname is dbcomputer, the port number is 1521, and the database name is SEE, the entry would appear as follows:

      jdbc:oracle:thin:@dbcomputer:1521:SEE

    2. From the Data store helper class name list, select the data store helper that matches the version of Oracle you are using.

  19. For a DB2 database, do the following:

    1. From the Driver type list, verify that 4 is selected.
    2. In the Database name text box, type the appropriate database name (SEE).
    3. In the Server name text box, type the name of the server that is running DB2.
    4. If necessary, in the Port number text box, alter the port number on which DB2 is listening. If you do not know this port number, contact your local DB2 administrator.

  20. Clear (uncheck) Use this data source in container managed persistence (CMP).

  21. Click Next.

  22. From the Component-managed authentication alias list, select the J2C authentication alias you created for your database.

  23. From the Mapping-configuration alias list, select DefaultPrincipalMapping.

  24. From the Container-managed authentication alias list, select the J2C authentication alias you created for your database.

  25. Click Next.

  26. Review the summary.

  27. Click Finish.

  28. On the right side of the console, click Fiper NonXA Data Source.

  29. In the Additional Properties area on the right side of the console, click Connection pool properties.

  30. Type the following information in the corresponding text boxes:

    Connection timeout: 300

    Maximum connections: 100

    Minimum connections: 25

  31. Click OK.

  32. In the Additional Properties area on the right side of the console, click Custom properties.

  33. Click New.

  34. Type the following information in the corresponding text boxes:

    Name: useRRASetEquals

    Value: true

    Description: See IBM APAR PK75897

  35. Click OK.

  36. On the left side of the console, click Data sources.

    The Data sources screen appears.

  37. Near the top of the right side of the console, click Save link to save the configuration.

  38. In the Select column, click the check box that corresponds to the new data source.

  39. Click Test connection.

  40. Verify that the connection was successful.

    Note: If your test connection fails, verify that all the information is entered correctly. Confirm that you have disabled the Windows Firewall on the computer running WebSphere. If the Windows Firewall is active, you will not be able to connect to the system running the database if the database is running on a separate system. For more information, see Configuring the Windows Firewall.