Versions Compared

Key

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

...

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

A description of the usage of Spring profiles in Blueriq can be found here.

...

Code Block
titleapplication-externaldatasources.properties
blueriq.datasource.[datasource_name].url=jdbc:sqlserver://demo-host:1433;databaseName=db_main;instance=SQL_EXPRESS
blueriq.datasource.[datasource_name].username=username
blueriq.datasource.[datasource_name].password=password
blueriq.datasource.[datasource_name].driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
blueriq.datasource.[datasource_name].jndiName=
blueriq.datasource.[datasource_name].type=org.apache.commons.dbcp2.BasicDataSource

...

The datasource.[datasource_name].type property configures the custom DataSource  implementation implementation used (needs to implement the javax.sql.DataSource interface). If not set or can't be loaded the default one, org.apache.commons.dbcp.BasicDataSource (from dbcp2) will be used. 

For the driverClassName property, see Configuring JDBC database drivers for possible values.

For dbcp2 datasources the following additional options are available:

...