Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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. 

SubjectPropertyDefaultExplanation

Property file

spring.profiles.active=

Include Page

BQ16:

_ProfileExternalDatasources

BQ16:

_ProfileExternalDatasources

Property file

spring.profiles.active=

Include Page

BQ16:

_ProfileJndiDatasources

BQ16:

_ProfileJndiDatasources

Datasources







blueriq.datasource.[name].url
The url of the datasource which should be connected to.

Include Page

BQ16:

_PropertiesExternalDatasources

BQ16:

_PropertiesExternalDatasources

Only available when you have 

Include Page

BQ16:

_ProfileExternalDatasources

BQ16:

_ProfileExternalDatasources
enables instead of 
Include Page

BQ16:

_ProfileJndiDatasources

BQ16:

_ProfileJndiDatasources
.

blueriq.datasource.[name].username
The username to login to the datasource

Include Page

BQ16:

_PropertiesExternalDatasources

BQ16:

_PropertiesExternalDatasources

Only available when you have 

Include Page

BQ16:

_ProfileExternalDatasources

BQ16:

_ProfileExternalDatasources
enables instead of
Include Page

BQ16:

_ProfileJndiDatasources

BQ16:

_ProfileJndiDatasources
.

blueriq.datasource.[name].password
The password to login to the datasource

Include Page

BQ16:

_PropertiesExternalDatasources

BQ16:

_PropertiesExternalDatasources

Only available when you have 

Include Page

BQ16:

_ProfileExternalDatasources

BQ16:

_ProfileExternalDatasources
enables instead of
Include Page

BQ16:

_ProfileJndiDatasources

BQ16:

_ProfileJndiDatasources
.

blueriq.datasource.[name].driverClassName
The driver that needs to be used to connect to the datasource

Include Page

BQ16:

_PropertiesExternalDatasources

BQ16:

_PropertiesExternalDatasources

Only available when you have 

Include Page

BQ16:

_ProfileExternalDatasources

BQ16:

_ProfileExternalDatasources
enables instead of
Include Page

BQ16:

_ProfileJndiDatasources

BQ16:

_ProfileJndiDatasources
.

blueriq.datasource.[name].jndiName
The name of the jndi datasource connection.

Only available when you have

Include Page

BQ16:

_ProfileJndiDatasources

BQ16:

_ProfileJndiDatasources
instead of
Include Page

BQ16:

_ProfileExternalDatasources

BQ16:

_ProfileExternalDatasources
.

Include Page

BQ16:

_PropertiesJndiDatasources

BQ16:

_PropertiesJndiDatasources

blueriq.hibernate.[name].hbm2ddl.autovalidate

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.

Include Page

BQ16:

_PropertiesExternalDatasources

BQ16:

_PropertiesExternalDatasources

Include Page

BQ16:

_PropertiesJndiDatasources

BQ16:

_PropertiesJndiDatasources

blueriq.hibernate.[name].dialect
The dialect that hibernate should use.

Include Page

BQ16:

_PropertiesExternalDatasources

BQ16:

_PropertiesExternalDatasources

Include Page

BQ16:

_PropertiesJndiDatasources

BQ16:

_PropertiesJndiDatasources

blueriq.hibernate.[name].use_nationalized_character_data

trueEnable 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.

Include Page

BQ16:

_PropertiesExternalDatasources

BQ16:

_PropertiesExternalDatasources

Include Page

BQ16:

_PropertiesJndiDatasources

BQ16: Include PageBQ16:_PropertiesExternalDatasourcesBQ16:

_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. (warning) 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

falseWhen blueriq.hibernate.[name].globally_quoted_identifiers is set to true, column names will be skipped. (warning) Like the previous property, Blueriq requires this property to be false (which is the default).

Include Page
_PropertiesExternalDatasources

_PropertiesExternalDatasources


blueriq.datasource.h2.enabledfalseThis property is required to be set to 'true' when any data source configures a H2 database.Can be placed in any file.