57.32 Member Match 57.34 Da Vinci Health Record Exchange

57.143.1Database

The Database configuration category includes the following configurable options:

Default Query Timeout (Seconds)
Log Abandoned
Max Idle Connections
Connection Max Lifetime (millis)
Max Total Connections
Max Wait (Seconds)
Min Idle Connections
Pool Prepared Statements
Remove Abandoned on Borrow
Remove Abandoned Timeout Seconds
Test Connections on Return
Database Type
Expect database to be writable
Database Password
SQL Parameter Bind Mode
Database Connection URL
Database Username
Default Page Size
FHIR Version
Maximum Page Size
Use ordinal date values for day precision searches.

57.143.2Property: Default Query Timeout (Seconds)

Property Name	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.
Applies to Modules	Audit Log Persistence Cluster Manager EasyShare SHL Endpoint (Public) FHIR Storage (DSTU2 RDBMS) FHIR Storage (MongoDB) FHIR Storage (R3 RDBMS) FHIR Storage (R4 RDBMS) FHIR Storage (R5 RDBMS) Realtime Export Transaction Log Persistence
Default Value	`60`
Example Property	`module.[MODULE_ID].config.db.connectionpool.default_query_timeout_seconds = 60`

57.143.3Property: Log Abandoned

Property Name	Log Abandoned
Property Key
Property Type	BOOLEAN
Description	Log stack traces for abandoned database connections (default false)
Applies to Modules	Audit Log Persistence Cluster Manager EasyShare SHL Endpoint (Public) FHIR Storage (DSTU2 RDBMS) FHIR Storage (R3 RDBMS) FHIR Storage (R4 RDBMS) FHIR Storage (R5 RDBMS) Realtime Export Transaction Log Persistence
Default Value	`false`
Example Property	`module.[MODULE_ID].config.db.connectionpool.log_abandoned = false`

57.143.4Property: Max Idle Connections

Property Name	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.
Applies to Modules	Audit Log Persistence Cluster Manager EasyShare SHL Endpoint (Public) FHIR Storage (DSTU2 RDBMS) FHIR Storage (R3 RDBMS) FHIR Storage (R4 RDBMS) FHIR Storage (R5 RDBMS) Realtime Export Transaction Log Persistence
Default Value	`8`
Example Property	`module.[MODULE_ID].config.db.connectionpool.maxidle = 8`

57.143.5Property: Connection Max Lifetime (millis)

Property Name	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. Minimum recommended value: 120000
Applies to Modules	Audit Log Persistence Cluster Manager EasyShare SHL Endpoint (Public) FHIR Storage (DSTU2 RDBMS) FHIR Storage (R3 RDBMS) FHIR Storage (R4 RDBMS) FHIR Storage (R5 RDBMS) Realtime Export Transaction Log Persistence
Default Value	(no default)
Example Property	`module.[MODULE_ID].config.db.connectionpool.maxlifetime.millis =`

57.143.6Property: Max Total Connections

Property Name	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.
Applies to Modules	Audit Log Persistence Cluster Manager EasyShare SHL Endpoint (Public) FHIR Storage (DSTU2 RDBMS) FHIR Storage (R3 RDBMS) FHIR Storage (R4 RDBMS) FHIR Storage (R5 RDBMS) Realtime Export Transaction Log Persistence
Default Value	`32`
Example Property	`module.[MODULE_ID].config.db.connectionpool.maxtotal = 32`

57.143.7Property: Max Wait (Seconds)

Property Name	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.
Applies to Modules	Audit Log Persistence Cluster Manager EasyShare SHL Endpoint (Public) FHIR Storage (DSTU2 RDBMS) FHIR Storage (R3 RDBMS) FHIR Storage (R4 RDBMS) FHIR Storage (R5 RDBMS) Realtime Export Transaction Log Persistence
Default Value	`30`
Example Property	`module.[MODULE_ID].config.db.connectionpool.maxwait_seconds = 30`

57.143.8Property: Min Idle Connections

Property Name	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.
Applies to Modules	Audit Log Persistence Cluster Manager EasyShare SHL Endpoint (Public) FHIR Storage (DSTU2 RDBMS) FHIR Storage (R3 RDBMS) FHIR Storage (R4 RDBMS) FHIR Storage (R5 RDBMS) Realtime Export Transaction Log Persistence
Default Value	`0`
Example Property	`module.[MODULE_ID].config.db.connectionpool.minidle = 0`

57.143.9Property: Pool Prepared Statements

Property Name	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.
Applies to Modules	Audit Log Persistence Cluster Manager EasyShare SHL Endpoint (Public) FHIR Storage (DSTU2 RDBMS) FHIR Storage (R3 RDBMS) FHIR Storage (R4 RDBMS) FHIR Storage (R5 RDBMS) Realtime Export Transaction Log Persistence
Default Value	`false`
Example Property	`module.[MODULE_ID].config.db.connectionpool.pool_prepared_statements = false`

57.143.10Property: Remove Abandoned on Borrow

Property Name	Remove Abandoned on Borrow
Property Key
Property Type	BOOLEAN
Description	Remove abandoned connections when they are borrowed from the pool (default false)
Applies to Modules	Audit Log Persistence Cluster Manager EasyShare SHL Endpoint (Public) FHIR Storage (DSTU2 RDBMS) FHIR Storage (R3 RDBMS) FHIR Storage (R4 RDBMS) FHIR Storage (R5 RDBMS) Realtime Export Transaction Log Persistence
Default Value	`false`
Example Property	`module.[MODULE_ID].config.db.connectionpool.remove_abandoned_on_borrow = false`

57.143.11Property: Remove Abandoned Timeout Seconds

Property Name	Remove Abandoned Timeout Seconds
Property Key
Property Type	NON_NEGATIVE_INTEGER
Description	Sets the timeout in seconds before an abandoned connection can be removed (default 300)
Applies to Modules	Audit Log Persistence Cluster Manager EasyShare SHL Endpoint (Public) FHIR Storage (DSTU2 RDBMS) FHIR Storage (R3 RDBMS) FHIR Storage (R4 RDBMS) FHIR Storage (R5 RDBMS) Realtime Export Transaction Log Persistence
Default Value	`300`
Example Property	`module.[MODULE_ID].config.db.connectionpool.remove_abandoned_timeout_seconds = 300`

57.143.12Property: Test Connections on Return

Property Name	Test Connections on Return
Property Key
Property Type	BOOLEAN
Description	If enabled, connections will be tested for validity when they are being returned to the pool. This adds a small amount of additional overhead, but can be helpful in order to speed up recovery from network and database issues.
Applies to Modules	Audit Log Persistence Cluster Manager EasyShare SHL Endpoint (Public) FHIR Storage (DSTU2 RDBMS) FHIR Storage (R3 RDBMS) FHIR Storage (R4 RDBMS) FHIR Storage (R5 RDBMS) Realtime Export Transaction Log Persistence
Default Value	`true`
Example Property	`module.[MODULE_ID].config.db.connectionpool.test_on_return = true`

57.143.13Property: Database Type

Property Name	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.
Applies to Modules	Audit Log Persistence Cluster Manager EasyShare SHL Endpoint (Public) FHIR Storage (DSTU2 RDBMS) FHIR Storage (R3 RDBMS) FHIR Storage (R4 RDBMS) FHIR Storage (R5 RDBMS) Realtime Export Transaction Log Persistence
Default Value	(no default)
Example Property	`module.[MODULE_ID].config.db.driver =`

57.143.14Property: Expect database to be writable

Property Name	Expect database to be writable
Property Key
Property Type	BOOLEAN
Description	Fail health-check if the database is read-only.
Applies to Modules	Audit Log Persistence Cluster Manager EasyShare SHL Endpoint (Public) FHIR Storage (DSTU2 RDBMS) FHIR Storage (R3 RDBMS) FHIR Storage (R4 RDBMS) FHIR Storage (R5 RDBMS) Realtime Export Transaction Log Persistence
Default Value	`false`
Example Property	`module.[MODULE_ID].config.db.expect_writable = false`

57.143.15Property: Database Password

Property Name	Database Password
Property Key
Property Type	PASSWORD
Description	Password for the database.
Applies to Modules	Audit Log Persistence Cluster Manager EasyShare SHL Endpoint (Public) FHIR Storage (DSTU2 RDBMS) FHIR Storage (MongoDB) FHIR Storage (R3 RDBMS) FHIR Storage (R4 RDBMS) FHIR Storage (R5 RDBMS) Realtime Export Transaction Log Persistence
Default Value	(no default)
Example Property	`module.[MODULE_ID].config.db.password =`

57.143.16Property: SQL Parameter Bind Mode

Property Name	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.
Applies to Modules	FHIR Storage (DSTU2 RDBMS) FHIR Storage (R3 RDBMS) FHIR Storage (R4 RDBMS) FHIR Storage (R5 RDBMS)
Default Value	`NEVER_INLINE`
Example Property	`module.[MODULE_ID].config.db.sql_parameter_bind_mode = NEVER_INLINE`

57.143.17Property: Database Connection URL

Property Name	Database Connection URL
Property Key
Property Type	STRING
Description	JDBC Connection URL for the database. The following examples show JDBC URLs for a few different database platforms: SQL Server (MSSQL): `jdbc:sqlserver://localhost:1433;trustServerCertificate=true;database=cdr` PostgreSQL: `jdbc:postgresql://localhost/cdr`
Applies to Modules	Audit Log Persistence Cluster Manager EasyShare SHL Endpoint (Public) FHIR Storage (DSTU2 RDBMS) FHIR Storage (MongoDB) FHIR Storage (R3 RDBMS) FHIR Storage (R4 RDBMS) FHIR Storage (R5 RDBMS) Realtime Export Transaction Log Persistence
Default Value	(no default)
Example Property	`module.[MODULE_ID].config.db.url =`

57.143.18Property: Database Username

Property Name	Database Username
Property Key
Property Type	STRING
Description	Username for the database.
Applies to Modules	Audit Log Persistence Cluster Manager EasyShare SHL Endpoint (Public) FHIR Storage (DSTU2 RDBMS) FHIR Storage (MongoDB) FHIR Storage (R3 RDBMS) FHIR Storage (R4 RDBMS) FHIR Storage (R5 RDBMS) Realtime Export Transaction Log Persistence
Default Value	(no default)
Example Property	`module.[MODULE_ID].config.db.username =`

57.143.19Property: Default Page Size

Property Name	Default Page Size
Property Key
Property Type	POSITIVE_INTEGER
Description	The default number of resources per page when querying mongo if _count is not provided. If not specified, will be set to 20.
Applies to Modules	FHIR Storage (MongoDB)
Default Value	`20`
Example Property	`module.[MODULE_ID].config.default_page_size = 20`

57.143.20Property: FHIR Version

Property Name	FHIR Version
Property Key
Property Type	ENUM
Values	`DSTU2` `DSTU3` `R4` `R5`
Description	The FHIR version that will be used with the Camel routes.
Applies to Modules	Camel FHIR Gateway REST Endpoint FHIR Storage (MongoDB)
Default Value	`R4`
Example Property	`module.[MODULE_ID].config.fhir_version = R4`

57.143.21Property: Maximum Page Size

Property Name	Maximum Page Size
Property Key
Property Type	POSITIVE_INTEGER
Description	The maximum allowable value for _count. Higher values of _count will be reduced to this value. If not specified, will be set to 100.
Applies to Modules	FHIR Storage (MongoDB)
Default Value	`100`
Example Property	`module.[MODULE_ID].config.maximum_page_size = 100`

57.143.22Property: Use ordinal date values for day precision searches.

Property Name	Use ordinal date values for day precision searches.
Property Key
Property Type	BOOLEAN
Description	If enabled, causes date search params with DAY precision to rely on the ordinal versions of the dates.
Applies to Modules	FHIR Storage (MongoDB)
Default Value	`true`
Example Property	`module.[MODULE_ID].config.use_ordinal_dates_for_day_precision_searches = true`

57.32 Member Match 57.34 Da Vinci Health Record Exchange