On this page:
   24.13    Cross-Origin Resource Sharing (CORS) 24.15    ETL Import: CSV Properties   

24.14Database

 

The Database configuration category includes the following configurable options:

  • Database Type

  • Database Connection URL

  • Database Username

  • Database Password

  • Schema Update Mode

  • Min Idle Connections

  • Max Idle Connections

  • Max Total Connections

  • Connection Max Lifetime (millis)

  • Max Wait (Seconds)

  • Default Query Timeout (Seconds)

  • Pool Prepared Statements

  • SQL Parameter Bind Mode

24.14.1Property: Database Type

 
Property Key
Property Type ENUM
Values
  • H2_EMBEDDED
  • DERBY_EMBEDDED
  • MARIADB_10_1
  • MYSQL_5_7
  • POSTGRES_9_4
  • ORACLE_12C
  • MSSQL_2012
Description The database platform being used. Smile CDR supports several relational database platforms for persistence so this setting selects the dialect that is specific to the platform being used.

For example, if you are using Postgres 9.4, select the POSTGRES_9_4 dialect.
Default Value (no default)
Is Optional? No

24.14.2Property: Database Connection URL

 
Property Key
Property Type STRING
Description JDBC Connection URL for the persistence database.

The following examples show JDBC URLs for a few different database platforms:
  • Derby Filesystem: jdbc:derby:directory:target/testDatabase;create=true
  • Postgresql: jdbc:postgresql://localhost/cdr
  • MariaDB: jdbc:mariadb://localhost:3306/cdr
Default Value (no default)
Is Optional? No

24.14.3Property: Database Username

 
Property Key
Property Type STRING
Description Username for the persistence database.
Default Value (no default)
Is Optional? No

24.14.4Property: Database Password

 
Property Key
Property Type PASSWORD
Description Password for the persistence database.
Default Value (no default)
Is Optional? No

24.14.5Property: Schema Update Mode

 
Property Key
Property Type ENUM
Values
  • UPDATE
  • NONE
Description Controls whether Smile CDR should attempt to update the database schema on startup. This is useful when setting up a new system, but should generally be disabled on a production system for safety and improved startup speed.
Default Value UPDATE
Is Optional? No

24.14.6Property: Min Idle Connections

 
Property Key
Property Type NON_NEGATIVE_INTEGER
Description The minimum number of idle connections to keep in the database connection pool at any given time.
Default Value 0
Is Optional? No

24.14.7Property: Max Idle Connections

 
Property Key
Property Type NON_NEGATIVE_INTEGER
Description The maximum number of idle connections to keep in the database connection pool at any given time.
Default Value 8
Is Optional? No

24.14.8Property: Max Total Connections

 
Property Key
Property Type POSITIVE_INTEGER
Description The maximum total number of connections to allow the database connection pool to hold at any given time. Set this value carefully as it may negatively impact database performance when set too low or too high.
Default Value 8
Is Optional? No

24.14.9Property: Connection Max Lifetime (millis)

 
Property Key
Property Type POSITIVE_INTEGER
Description If set, provides the maximum total number of milliseconds that a connection is allowed to live. Any connections that are open for longer will be closed instead of being reused. Note that this setting applies only to idle connections in the pool, it does not affect active database operations even if the timeout is exceeded.
Default Value (no default)
Is Optional? Yes

24.14.10Property: Max Wait (Seconds)

 
Property Key
Property Type POSITIVE_INTEGER
Description The maximum number of seconds that a request should wait for a database connection before timing out and aborting.
Default Value 30
Is Optional? No

24.14.11Property: Default Query Timeout (Seconds)

 
Property Key
Property Type NON_NEGATIVE_INTEGER
Description This setting is the maximum number of seconds that a query may run before being automatically aborted by the database. This setting is a failsafe to prevent overly taxing searches from dominating the database.
Default Value 60
Is Optional? No

24.14.12Property: Pool Prepared Statements

 
Property Key
Property Type BOOLEAN
Description If enabled, prepared statements will be pooled by the connection pool. Note that when using schema-based multitenancy, Smile CDR may choose to ignore this setting.
Default Value false
Is Optional? No

24.14.13Property: SQL Parameter Bind Mode

 
Property Key
Property Type ENUM
Values
  • ALWAYS_INLINE
  • INLINE_NUMERIC
  • NEVER_INLINE
Description Specifies whether parameters in SQL statements should be inlined or bound to parameters.
Default Value NEVER_INLINE
Is Optional? No
   24.13    Cross-Origin Resource Sharing (CORS) 24.15    ETL Import: CSV Properties