57.141.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.141.2Property: Default Query Timeout (Seconds)
|
|
Default Query Timeout (Seconds) |
|
|
|
| NON_NEGATIVE_INTEGER | |
| 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. | |
|
|
60
|
|
|
57.141.3Property: Log Abandoned
|
|
Log Abandoned |
|
|
|
| BOOLEAN | |
| Log stack traces for abandoned database connections (default false) | |
|
|
false
|
|
|
57.141.4Property: Max Idle Connections
|
|
Max Idle Connections |
|
|
|
| NON_NEGATIVE_INTEGER | |
| The maximum number of idle connections to keep in the database connection pool at any given time. | |
|
|
8
|
|
|
57.141.5Property: Connection Max Lifetime (millis)
|
|
Connection Max Lifetime (millis) |
|
|
|
| POSITIVE_INTEGER | |
| 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 | |
|
|
| (no default) | |
|
57.141.6Property: Max Total Connections
|
|
Max Total Connections |
|
|
|
| POSITIVE_INTEGER | |
| 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. | |
|
|
32
|
|
|
57.141.7Property: Max Wait (Seconds)
|
|
Max Wait (Seconds) |
|
|
|
| POSITIVE_INTEGER | |
| The maximum number of seconds that a request should wait for a database connection before timing out and aborting. | |
|
|
30
|
|
|
57.141.8Property: Min Idle Connections
|
|
Min Idle Connections |
|
|
|
| NON_NEGATIVE_INTEGER | |
| The minimum number of idle connections to keep in the database connection pool at any given time. | |
|
|
0
|
|
|
57.141.9Property: Pool Prepared Statements
|
|
Pool Prepared Statements |
|
|
|
| BOOLEAN | |
| 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. | |
|
|
false
|
|
|
57.141.10Property: Remove Abandoned on Borrow
|
|
Remove Abandoned on Borrow |
|
|
|
| BOOLEAN | |
| Remove abandoned connections when they are borrowed from the pool (default false) | |
|
|
false
|
|
|
57.141.11Property: Remove Abandoned Timeout Seconds
|
|
Remove Abandoned Timeout Seconds |
|
|
|
| NON_NEGATIVE_INTEGER | |
| Sets the timeout in seconds before an abandoned connection can be removed (default 300) | |
|
|
300
|
|
|
57.141.12Property: Test Connections on Return
|
|
Test Connections on Return |
|
|
|
| BOOLEAN | |
| 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. | |
|
|
true
|
|
|
57.141.13Property: Database Type
|
|
Database Type |
|
|
|
| ENUM | |
| Values |
|
|
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.
|
|
|
|
| (no default) | |
|
57.141.14Property: Expect database to be writable
|
|
Expect database to be writable |
|
|
|
| BOOLEAN | |
| Fail health-check if the database is read-only. | |
|
|
false
|
|
|
57.141.15Property: Database Password
|
|
Database Password |
|
|
|
| PASSWORD | |
| Password for the database. | |
|
|
| (no default) | |
|
57.141.16Property: SQL Parameter Bind Mode
|
|
SQL Parameter Bind Mode |
|
|
|
| ENUM | |
| Values |
|
| Specifies whether parameters in SQL statements should be inlined or bound to parameters. | |
|
|
NEVER_INLINE
|
|
|
57.141.17Property: Database Connection URL
|
|
Database Connection URL |
|
|
|
| STRING | |
|
JDBC Connection URL for the database. The following examples show JDBC URLs for a few different database platforms:
|
|
|
|
| (no default) | |
|
57.141.18Property: Database Username
|
|
Database Username |
|
|
|
| STRING | |
| Username for the database. | |
|
|
| (no default) | |
|
57.141.19Property: Default Page Size
|
|
Default Page Size |
|
|
|
| POSITIVE_INTEGER | |
| The default number of resources per page when querying mongo if _count is not provided. If not specified, will be set to 20. | |
|
|
20
|
|
|
57.141.20Property: FHIR Version
|
|
FHIR Version |
|
|
|
| ENUM | |
| Values |
|
| The FHIR version that will be used with the Camel routes. | |
|
|
R4
|
|
|
57.141.21Property: Maximum Page Size
|
|
Maximum Page Size |
|
|
|
| POSITIVE_INTEGER | |
| The maximum allowable value for _count. Higher values of _count will be reduced to this value. If not specified, will be set to 100. | |
|
|
100
|
|
|
57.141.22Property: Use ordinal date values for day precision searches.
|
|
Use ordinal date values for day precision searches. |
|
|
|
| BOOLEAN | |
| If enabled, causes date search params with DAY precision to rely on the ordinal versions of the dates. | |
|
|
true
|
|
|