Elastic Path Production Tools

Data Population Core Configurations

Data Population Core Configurations

Configuration Types

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 oracle-rds.sproc oracle.properties
sqlserver Development and on-premise sqlserver.sql sqlserver.properties

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.