Configuring JNDI connection initialization for Oracle
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.
Attribute connections-initialized-for-application set to true
If you set the value of attribute connections-initialized-for-application to true, you must provide the correct settings for the Oracle database parameters that the external data sources uses for connection initialization. If you do not initialize the connections properly, the application server refuses to start and logs an error message for each incorrect setting. Guidewire recommends that you set this attribute to true, then start the application server. You can then determine the correct values to use for your database from the log error messages.
In general, the Oracle database parameters to use for connection initialization have the following meanings:
Oracle parameter |
Meaning |
|---|---|
|
Boolean. The exact setting is dependant on your database installation. |
|
The module name, which must include the database user name as well. For example, if your database user name is PCPROD1, then set the module name to PolicyCenter_PCPROD1. |
|
The default sort collation for the Oracle database. The exact setting is dependent on your Guidewire installation. See the Globalization Guide for more information. |
|
The database collation behavior. Set this value to |
To use this feature, you must configure the application server to manage the connection initialization. See Set Oracle database parameters for connection initialization for more information.
Attribute connections-initialized-for-application set to false
If you set the value of attribute connections-initialized-for-application to
false, PolicyCenter assumes no action is
taken by the data source to configure the borrowed connection before placing an item in the
connection pool. This causes PolicyCenter to run a set of SQL
statements on each and every connection that it borrows from the data source.
Although the cost in time of each of these statements is very small, Guidewire applications sometimes borrow connections at a very high rate. Thus, it is possible for the time to execute these statements to become measurable and to become visible during performance analysis in the Guidewire Profiler.