Configure the SQL Server data source properties

Before you begin

Before proceeding, complete Create the SQL Server 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 you created for SQL Server.
  4. Under Additional Properties, click WebSphere Application Server data source properties.
  5. Set the value of Statement cache size to 0.
  6. Select the Non-transactional data source checkbox.
  7. Click OK.
  8. Click Save to apply your changes to the master configuration.
  9. Click the data source you created for SQL Server.
  10. Under Additional Properties, click Custom Properties.
  11. Verify the value of property sendStringParametersAsUnicode.

    To change the value, click the property name:

    • If you are using unicode columns (nvarchar), set this value to true.
    • If you are not using nvarchar, but single byte varchar columns, set this value to false.
    Your application server will not start up if this setting is incorrect.
  12. At the top of the Custom properties screen, click New.
    1. Enter commitOrRollbackOnCleanup in the Name field.
    2. Enter rollback in the Value field.
    3. 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 SQL Server JNDI connection.