Marketing Creatio
PDF
This documentation is valid for Creatio version 7.15.0. We recommend using the newest version of Creatio documentation.

Configure Web.config for Oracle Database

When deploying an Oracle-based Creatio application, edit the Web.config file located in the Creatio website root folder:

1.In the general parameter of the <db> block, change the value of the currentSchemaName attribute to the schema name that is specified in ConnectionStrings.config:

<db>
    <general securityEngineType="Terrasoft.DB.Oracle.OracleSecurityEngine, Terrasoft.DB.Oracle"
executorType="Terrasoft.DB.Oracle.OracleExecutor, Terrasoft.DB.Oracle"
isCaseInsensitive="true" maxAnsiJoinCount="0"
engineType="Terrasoft.DB.Oracle.OracleEngine, Terrasoft.DB.Oracle"
metaEngineType="Terrasoft.DB.Oracle.OracleMetaEngine,
Terrasoft.DB.Oracle"
metaScriptType="Terrasoft.DB.Oracle.OracleMetaScript,
 Terrasoft.DB.Oracle" typeConverterType="Terrasoft.DB.Oracle.OracleTypeConverter,
Terrasoft.DB.Oracle" connectionStringName="db"
binaryPackageSize="1048576" useOrderNullsPosition="true"
 currentSchemaName="[Oracle DB schema name]" maxEntitySchemaNameLength="30" />
</db>

2.Make sure that the 4.112.1.2 library version is specified.

<system.data>
       <DbProviderFactories>
           <remove invariant="Oracle.DataAccess.Client" />
           <add name="Oracle Data Provider for .NET"
invariant="Oracle.DataAccess.Client" description="Oracle Data
 Provider for .NET" type="Oracle.DataAccess.Client.OracleClientFactory, Oracle.DataAccess,
Version=4.112.1.2, Culture=neutral, PublicKeyToken=89b483f429c47342"/>
       </DbProviderFactories>
   </system.data>

3.Specify the quartz.dataSource.SchedulerDb.provider key value in the <quartz> block:

<add key="quartz.dataSource.SchedulerDb.provider" value="OracleODP-1123-40" />

4.Save the changes.

Did you find this information useful?

How can we improve it?