Guide - 7.10 Database Deployment Configuration

1 Introduction

Intershop Commerce Management 7.10 supports MS-SQL as additional data base type besides oracle. This guide documents the resulting changes in deployment.

2 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>'
...
}

2.1 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.

2.2 jdbcUrl

The JDBC connection URL depends on the data base type.

2.2.1 MSSQL

MSSQL
jdbcUrl = 'jdbc:sqlserver://<HOST>:<PORT>;databaseName=<DBSCHEMA_NAME>'

2.2.2 Oracle With SID

Oracle
jdbcUrl = 'jdbc:oracle:thin:@<HOST>:<PORT>:<SID>'

2.2.3 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.

Customer Support
Knowledge Base
Product Resources
Support Tickets