Oracle database settings

A typical deployment of NexJ CRM requires the following data sources to be configured with the following properties.

The SessionDatabase is required when using session persistence.

The following data sources are required for a typical deployment with Oracle database:
  • AuditLogDatabase
  • BI_1_BI_Database
  • call:Call
  • Conversation
  • DefaultRelationalDatabase
  • ecr:ECR
  • flow:Flow
  • LockDatabase
  • msg:Messaging
  • ObjectQueueDatabase
  • rules:Rules
  • SessionDatabase
  • sso:SSO
  • StagingDatabase
  • StatDatabase
  • uicomp:UIComponent

The suggested properties and values are the same for all data sources.

Table 1. Data source settings for a typical Oracle NexJ CRM deployment
Attribute Value Notes
Data Source datasourcename
Adapter Oracle11g Data source adapter.
Host localhost Dababase server host name.
User Database_User_ID The ID used by the application to access the database.
Path ojdbc6-11.2.0.3.jar Name of the JDBC driver JAR file.
Port 1521 Database server port number.
Database Database_Name The name of the database the application will access.
Password Database_Password The password corresponding to the database user ID.
Query Timeout 10 Number of seconds before queries timeout.
Warning Timeout 250 Number of milliseconds before a timeout warning occurs for long-running queries.