Document Properties
Kbid
2873L0
Last Modified
18-May-2020
Added to KB
17-Sep-2018
Public Access
Everyone
Status
Online
Doc Type
Guidelines
Product
ICM 7.10
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.
Home
Knowledge Base
Product Releases
Log on to continue
This Knowledge Base document is reserved for registered customers.
Log on with your Intershop Entra ID to continue.
Write an email to supportadmin@intershop.de if you experience login issues,
or if you want to register as customer.