Set Oracle database parameters for connection initialization

About this task

Boolean attribute connections-initialized-for-application on the <jndi-connection-pool> element in database-config.xml configures how the JNDI data source provides connections to PolicyCenter. To use this feature with an external data source, you must configure your data source to initialize a set of Oracle database parameters.

Procedure

  1. Set attribute connections-initialized-for-application on the <jndi-connection-pool> element to true.
  2. Start the application server.
  3. From the server log, determine the exact values to set for connection initialization.
  4. Depending on your application server, set up the connection initialization as appropriate.

    See Connection initialization for Oracle databases for more information.

  5. After completing your initialization configuration, restart the application server and Guidewire PolicyCenter.