Configure the Oracle data source properties

Before you begin

Before proceeding, complete Create the Oracle JNDI data source.

Procedure

  1. Open the WebSphere Administrative Console if it is not already open.
  2. Choose Resources > JDBC > Data sources.
  3. Click the data source that you just defined.
    WebSphere displays the Configuration tab.
  4. Click WebSphere Application Server data source properties.
  5. Set Statement cache size to 0.
  6. Select Non-transactional data source.
  7. Click OK.
  8. Under Additional Properties, click Custom Properties.
  9. At the top of the Custom properties screen, click New.
  10. Enter the Name commitOrRollbackOnCleanup.
  11. Enter the Value rollback.
  12. Click OK.
  13. Click Save to apply your changes to the master configuration.

What to do next

After completing this procedure, proceed to Test the Oracle JNDI connection.