Announcement: You can find the guides for Commerce 7.5 and later on the new Elastic Path Documentation site. This Developer Center contains the guides for Commerce 6.13.0 through 7.4.1.Visit new site

This version of Elastic Path Commerce is no longer supported or maintained. To upgrade to the latest version, contact your Elastic Path representative.

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.