The <reset-tool-params> database configuration element

The <dbcp-connection-pool> element in file database-config.xml contains, at most, a single occurrence of subelement <reset-tool-params>. The use of the <reset-tool-params> element is optional. Use this element to configure DBResetTool, not the DBCP connection pool. Guidewire defines the <reset-tool-params> element as a subelement of the <dbcp-connection-pool> element because DBResetTool only works on databases defined in the <dbcp-connection-pool> element.

The <reset-tool-params> element has the following syntax.

<database>
  <dbcp-connection-pool>
    <reset-tools-params collation="string" oracle-tnsnames="string" system-password="string"
          system-username="string"/>
  </dbcp-connection-pool>
</database>

The following list describes the attributes that you can configure on the <reset-tools-params> element. All of these attributes are optional.

collation

Collation value to use if creating a new H2 (QuickStart) or SQL Server database:

  • H2 – Sets database collation using the Java Collation class.
  • SQL Server – Sets database collation to a Microsoft Window’s or SQL collation name.

DBResetTool (dropdb) uses the value of this attribute if creating a new H2 or SQL Server database.

oracle-tnsnames

(Oracle) Name of the Oracle tnsnames.ora file.

system-password

(Oracle) Database system password.

system-username

(Oracle) Database system username.

The <reset-tools-arams> element has no subelements.

See also