Data Population Core Configurations

Core Configurations

The following configuration resources are included in the data population core module at ep-data-population-core/src/main/resources:

Database Type	Environments	Database-Reset-SQL/	Database-URL/
h2	Integration testing	h2.sql	h2.properties
mysql	Development, on-premise and Amazon RDS	mysql.sql	mysql.properties
mysql-azure	Azure DB for MySQL	mysql-azure.sql	mysql.properties
oracle	SID connections	oracle.sproc	oracle.properties
oracle-service	Service connections	oracle.sproc	oracle-service.properties
oracle-rds	Amazon RDS (Relational Database Service)	oracle-rds.sproc	oracle.properties
sqlserver	Development and on-premise	sqlserver.sql	sqlserver.properties

Database-Reset-SQL

These are the corresponding SQL (Structured Query Language) files that will reset the database. Any changes made to the database will be lost.

Database Types

The database type determines the configuration files being used. The database type can be explicitly specified using the data.population.database.type property in environment-specific database.properties files. If the type is not specified in the database.properties file, the name of the JDBC driver class determines the configuration type.

For example, oracle.jdbc.driver.OracleDriver has a database type of oracle.

The following resource-location.xml file at commerce-engine/data-population/ep-data-population-core/src/main/resources/META-INF/spring/ provides details of the supported configurations:

<util:list id="candidateDatabaseTypes" list-class="java.util.ArrayList" value-type="java.lang.String">
    <value>mysql</value>
    <value>oracle</value>
    <value>h2</value>
    <value>sqlserver</value>
</util:list>

If an exact match between the database type and configuration files without the file suffix is not found, the database type is truncated on the final - character and the lookup is attempted again. This is repeated until a match is found or no further truncation is possible. For example,

• A database type of oracle returns oracle.properties and oracle.sproc
• A database type of oracle-service returns oracle-service.properties and oracle.sproc