Configuring the free-text batch load command

The configuration and support files for the free-text batch load command and the command itself are located in the following directory on the host where the Guidewire Solr Extension resides:

/opt/gwsolr/pc/solr/policy_active/conf

The following files configure the free-text batch load command:

batchload.sh or batchload.bat: Specifies the batch load configuration file to use for your database brand.
batchload-config-databaseBrand.xml: Defines the connection to the relational database that the free-text batch load command uses to query for policy data, as well as other system resources that the command requires. In addition, the batch load configuration file contains the native SQL Select statements that the batch load command uses to extract data from the PolicyCenter database.

Initial configuration of the free-text batch load command

Generally, you configure the free-text batch load command when you first install and set up free-text search. Afterward, you need to modify your initial configuration only if resources in your computing environment change, such as the connection to your database.

SQL Select statement configuration for the free-text batch load command

The free-text batch load command extracts data from the PolicyCenter database by using native SQL. The native SQL Select statements that the batch loader uses are defined in configuration files for specific database brands.

The following configuration files contain the native SQL commands:

batchload-config-h2.xml: For H2 databases, suitable only for development mode
batchload-config-oracle.xml: For Oracle databases, suitable only for development mode
batchload-config-postgresql.xml: For PostgreSQL databases, suitable for development or production modes
batchload-config-sqlserver.xml: For SQL Server databases, suitable only for development mode

You do not need to modify the native SQL when you first set up and configure the free-text batch load command. The native SQL correctly selects data for the search fields in the default configuration of free-text search. You must modify the native SQL only when you want to extend or modify the search fields for your configuration of free-text search.