For the Blueriq Runtime there are two types of datasources that you can define in your properties: Include Page |
---|
| BQ16:_ProfileJndiDatasourcesBQ16: |
---|
| _ProfileJndiDatasources |
---|
|
or Include Page |
---|
| BQ16:_ProfileExternalDatasourcesBQ16: |
---|
| _ProfileExternalDatasources |
---|
|
. You can only enable one type by providing the type in the property spring.profiles.active.
Datasource configuration for the Customerdata Service can be found here: Customerdata service
Note |
---|
It is possible to set the same property with a hibernate. (global) prefix and a blueriq.datasource.[name].hibernate. (datasource specific) prefix. When the same property is set with both prefixes, the property with the datasource specific prefix will have precedence over the global prefix. |
Subject | Property | Default | Explanation | Property file spring.profiles.active=
|
---|
BQ16: | _ProfileExternalDatasources |
---|
|
|
---|
BQ16: | _ProfileExternalDatasources |
---|
|
| Property file spring.profiles.active=
|
---|
BQ16:BQ16: |
---|
Datasources
| blueriq.datasource.[name].url |
| The url of the datasource which should be connected to. | |
BQ16: | _PropertiesExternalDatasources |
---|
|
|
BQ16: | _PropertiesExternalDatasources |
---|
|
| Only available when you have
|
BQ16: | _ProfileExternalDatasources |
---|
|
|
BQ16: | _ProfileExternalDatasources |
---|
|
enables instead of
|
BQ16:BQ16: |
blueriq.datasource.[name].username |
| The username to login to the datasource | |
BQ16: | _PropertiesExternalDatasources |
---|
|
|
BQ16: | _PropertiesExternalDatasources |
---|
|
| Only available when you have
|
BQ16: | _ProfileExternalDatasources |
---|
|
|
BQ16: | _ProfileExternalDatasources |
---|
|
enables instead of
|
BQ16:BQ16: |
blueriq.datasource.[name].password |
| The password to login to the datasource | |
BQ16: | _PropertiesExternalDatasources |
---|
|
|
BQ16: | _PropertiesExternalDatasources |
---|
|
| Only available when you have
|
BQ16: | _ProfileExternalDatasources |
---|
|
|
BQ16: | _ProfileExternalDatasources |
---|
|
enables instead of
|
BQ16:BQ16: |
blueriq.datasource.[name].driverClassName |
| The driver that needs to be used to connect to the datasource | |
BQ16: | _PropertiesExternalDatasources |
---|
|
|
BQ16: | _PropertiesExternalDatasources |
---|
|
| Only available when you have
|
BQ16: | _ProfileExternalDatasources |
---|
|
|
BQ16: | _ProfileExternalDatasources |
---|
|
enables instead of
|
BQ16:BQ16: |
blueriq.datasource.[name].jndiName |
| The name of the jndi datasource connection. | Only available when you have
|
BQ16:BQ16:BQ16: | _ProfileExternalDatasources |
---|
|
|
BQ16: | _ProfileExternalDatasources |
---|
|
.
| |
BQ16: | _PropertiesJndiDatasources |
---|
|
|
BQ16: | _PropertiesJndiDatasources |
---|
|
|
blueriq.hibernate.[name].hbm2ddl.auto | validate | When starting server (SessionFactory) Supported values: none / validate create/update/create-drop are not supported ways to create a schema. Use the dbscripts that are provided with the release instead. | |
BQ16: | _PropertiesExternalDatasources |
---|
|
|
BQ16: | _PropertiesExternalDatasources |
---|
|
| |
BQ16: | _PropertiesJndiDatasources |
---|
|
|
BQ16: | _PropertiesJndiDatasources |
---|
|
|
blueriq.hibernate.[name].dialect |
| The dialect that hibernate should use. | |
BQ16: | _PropertiesExternalDatasources |
---|
|
|
BQ16: | _PropertiesExternalDatasources |
---|
|
| |
BQ16: | _PropertiesJndiDatasources |
---|
|
|
BQ16: | _PropertiesJndiDatasources |
---|
|
|
blueriq.hibernate.[name].use_nationalized_character_data | true | Enable nationalized character support on all string / clob based attributes ( string, char, clob, text etc ). Note that this property by defaults to true because 'hibernate.use_nationalized_character_data' is set in application.properties that is packaged in the default runtime WAR. When using H2 this property should be set to 'false' because H2 does not have specific nationalized data types. For more information about it's usage see: UTF8 support. | |
BQ16: | _PropertiesExternalDatasources |
---|
|
|
BQ16: | _PropertiesExternalDatasources |
---|
|
| |
BQ16: | _PropertiesJndiDatasources |
---|
|
|
BQ16: Include Page |
---|
BQ16:_PropertiesExternalDatasources | BQ16: | _PropertiesJndiDatasources |
---|
|
|
blueriq.hibernate.[name].globally_quoted_identifiers | false |
This property is required to be set to 'true' when a h2 datasource is used
| Quotes all database identifiers. Note that some databases treat column names as case sensitive when they are quoted, which may break the application. Blueriq requires this property to be false (which is the default). | Include Page |
---|
| _PropertiesExternalDatasources |
---|
| _PropertiesExternalDatasources |
---|
|
| |
blueriq.hibernate.[name].globally_quoted_identifiers_skip_column_definitions | false | When blueriq.hibernate.[name].globally_quoted_identifiers is set to true, column names will be skipped. Like the previous property, Blueriq requires this property to be false (which is the default). | Include Page |
---|
| _PropertiesExternalDatasources |
---|
|
---|
|
|
_PropertiesExternalDatasources |
|
| |
blueriq.datasource.h2.enabled | false | This property is required to be set to 'true' when any data source configures a H2 database. | Can be placed in any file. |
|