Versions Compared

Old Version 16

changes.mady.by.user Unknown User (c.van.der.list)

Saved on

compared with

New Version 17

changes.mady.by.user Felix Janssen

Saved on

Key

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

...

Note

It is possible to enable both profiles but make sure a datasource is configured in just one of the .properties file.

 


A detailed description of the Blueriq properties file can be found on the Reference Guide: Properties.

...

For Oracle use  as the oracle.jdbc.driver.OracleDriver and org.hibernate.dialect.Oracle10gDialectOracle12cDialect as the dialect.

For Microsoft SQL Server use com.microsoft.sqlserver.jdbc.SQLServerDriver as the driverClassName and org.hibernate.dialect.SQLServer2012Dialect as the dialect.

...

For dbcp2 datasources the following additional options are available:

...


Code Block
titleapplication-externaldatasources.properties
blueriq.datasource.[datasource_name].poolInitialSize=0
blueriq.datasource.[datasource_name].poolMaxTotal=8
blueriq.datasource.[datasource_name].poolMaxIdle=8
blueriq.datasource.[datasource_name].poolMinIdle=0
blueriq.datasource.[datasource_name].poolMaxWait=-1L
blueriq.datasource.[datasource_name].validationQuery=""
blueriq.datasource.[datasource_name].validationQueryTimeout=-1
blueriq.datasource.[datasource_name].testOnBorrow=true
blueriq.datasource.[datasource_name].testOnReturn=false
blueriq.datasource.[datasource_name].testWhileIdle=false
blueriq.datasource.[datasource_name].timeBetweenEvictionRunsMillis=-1
blueriq.datasource.[datasource_name].numTestsPerEvictionRun=3
blueriq.datasource.[datasource_name].minEvictableIdleTimeMillis=1800000 
 

An example configuration when using the externaldatasources profile:
...