Versions Compared

Old Version 19

changes.mady.by.user Unknown User (a.jansen)

Saved on

compared with

New Version Current

changes.mady.by.user Tijmen Daatselaar

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrate text box

...

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

Hibernate Dialects: Oracle database, Microsoft (MS) SQL Server database

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

...

type
Code Block
titleapplication-externaldatasources.properties
blueriq.datasource.trace.url=jdbc:sqlserver://<database_url>;databaseName=bq_trace;instance=SQL_EXPRESS
blueriq.datasource.trace.username=<username>
blueriq.datasource.trace.password=<password>
blueriq.datasource.trace.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
blueriq.hibernate.trace.hbm2ddl.auto=validate
blueriq.hibernate.trace.dialect=org.hibernate.dialect.SQLServer2012Dialect

blueriq.datasource.reporting.url=jdbc:sqlserver://<database_url>:1433;databaseName=bq_reporting;instance=SQL_EXPRESS
blueriq.datasource.reporting.username=<username>
blueriq.datasource.reporting.password=<password>
blueriq.datasource.reporting.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
blueriq.hibernate.reporting.hbm2ddl.auto=validate
blueriq.hibernate.reporting.dialect=org.hibernate.dialect.SQLServer2012Dialect
UI Text Box
 Info
While in earlier versions the datasources were sometimes shared between components, now each component has its own datasource. For an overview of components and plugins, see Installation.
JNDI datasources
When using the jndidatasources profile, the jndiName property should be set, the url, username, password and driverClassName aren't needed.
...