The <jndi-connection-pool> database configuration element

The <database> element in file database-config.xml contains, at most, a single occurrence of subelement <jndi-connection-pool>. The use of the <jndi-connection-pool> element is optional. However, file database-config.xml must contain this element if you use a JNDI (Java Naming and Directory Interface) data source managed by a JBoss, WebSphere, WebLogic, or Tomcat application server.

The <jndi-connection-pool> element has the following syntax. The following code sample shows required attributes in bold font. 

<database>
  
  <!-- Sets the data source for a JBoss, WebSphere, WebLogic, or Tomcat application server-->
  <jndi-connection-pool datasource-name="string" 
        connections-initialized-for-application="true|false"/>
  
</database>
Important: If you modify the <jndi-connection-pool> element in any way, you must restart the application server.

The following list describes the attributes that you can configure on the <jndi-connection-pool> element.

datasource-name

Required. Specifies the JNDI name to assign to the data source. See Configure PolicyCenter to use a direct JNDI data source for more information.

The following attribute is optional.

connections-initialized-for-application

(Oracle) Boolean. Controls the number of SQL statements that PolicyCenter executes on every connection that it borrows from an external data source. This setting applies to the named JNDI database connection set up in this <jndi-connection-pool> element only.

Valid values are:

  • true – If configured appropriately, the data source provides connections with certain Oracle database parameters set to their desired values.
  • false – PolicyCenter runs a set of SQL statements on each and every database connection that it borrows from the data source.

The default is false.

To take advantage of this feature:

  • Your PolicyCenter installation must use an Oracle database.
  • You must configure the data source appropriately.

See Configuring JNDI connection initialization for Oracle for more information.

IMPORTANT If you set this attribute to true and do not initialize the connections properly, the application server refuses to start and logs an error message for each incorrect setting.

The <jndi-connection-pool> element has no subelements.

See also