Guide - 7.10 Database Deployment Configuration
Introduction
Intershop Commerce Management 7.10 supports MS-SQL as additional data base type besides oracle. This guide documents the resulting changes in deployment.
Deployment Changes
The database section within the settings.gradle must be adapted. So the two attributes databaseType and jdbcUrl are added to the section. Further details about the deploying ICM 7.10 can be found here: Cookbook - Deployment Tools ICM 7.10
settings.gradle
database {
...
+ databaseType = 'oracle|mssql'
+ jdbcUrl = '<FILL IN>'
...
}
databaseType
The desired data base can be selected: Either oracle or mssql written in small letters.
The selection of the database type does not select or deselect the database driver (jars, cartridges). Both kinds of databases are supported by the application server. Only the configuration is adapted by this.
jdbcUrl
The JDBC connection URL depends on the data base type.
MSSQL
MSSQL
jdbcUrl = 'jdbc:sqlserver://<HOST>:<PORT>;databaseName=<DBSCHEMA_NAME>'
Oracle With SID
Oracle
jdbcUrl = 'jdbc:oracle:thin:@<HOST>:<PORT>:<SID>'
Oracle with Service Name
Oracle
jdbcUrl = 'jdbc:oracle:thin:@//<HOST>:<PORT>/<SERVICE_NAME>'
Disclaimer
The information provided in the Knowledge Base may not be applicable to all systems and situations. Intershop Communications will not be liable to any party for any direct or indirect damages resulting from the use of the Customer Support section of the Intershop Corporate Web site, including, without limitation, any lost profits, business interruption, loss of programs or other data on your information handling system.