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
_ProfileJndiDatasources
_ProfileJndiDatasources
or
Include Page
_ProfileExternalDatasources
_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
_ProfileExternalDatasources
_ProfileExternalDatasources

Property file

spring.profiles.active=

Include Page
_ProfileJndiDatasources
_ProfileJndiDatasources

Datasources








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

Include Page
_PropertiesExternalDatasources
_PropertiesExternalDatasources

Only available when you have 

Include Page
_ProfileExternalDatasources
_ProfileExternalDatasources
enables instead of 
Include Page
_ProfileJndiDatasources
_ProfileJndiDatasources
.

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

Include Page
_PropertiesExternalDatasources
_PropertiesExternalDatasources

Only available when you have 

Include Page
_ProfileExternalDatasources
_ProfileExternalDatasources
enables instead of
Include Page
_ProfileJndiDatasources
_ProfileJndiDatasources
.

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

Include Page
_PropertiesExternalDatasources
_PropertiesExternalDatasources

Only available when you have 

Include Page
_ProfileExternalDatasources
_ProfileExternalDatasources
enables instead of
Include Page
_ProfileJndiDatasources
_ProfileJndiDatasources
.

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

Include Page
_PropertiesExternalDatasources
_PropertiesExternalDatasources

Only available when you have 

Include Page
_ProfileExternalDatasources
_ProfileExternalDatasources
enables instead of
Include Page
_ProfileJndiDatasources
_ProfileJndiDatasources
.

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

Only available when you have

Include Page
_ProfileJndiDatasources
_ProfileJndiDatasources
instead of
Include Page
_ProfileExternalDatasources
_ProfileExternalDatasources
.

Include Page
_PropertiesJndiDatasources
_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
_PropertiesExternalDatasources
_PropertiesExternalDatasources

Include Page
_PropertiesJndiDatasources
_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. For more information about it's usage see: UTF8 support.

Include Page
_PropertiesExternalDatasources
_PropertiesExternalDatasources

Include Page
_PropertiesJndiDatasources
_PropertiesJndiDatasources

blueriq.hibernate.[name].globally_quoted_identifiers

false

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