Versions Compared

Old Version 7

changes.mady.by.user Unknown User (m.schadd)

Saved on

compared with

New Version 8

changes.mady.by.user Unknown User (m.schadd)

Saved on

Key

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

...

Code Block
titleapplication-externaldatasources.properties
blueriq.datasource.main.url=jdbc:sqlserver://<database_url>:1433;databaseName=bq_main;instance=SQL_EXPRESS
blueriq.datasource.main.username=<username>
blueriq.datasource.main.password=<password>
blueriq.datasource.main.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
blueriq.hibernate.main.hbm2ddl.auto=
blueriq.hibernate.main.dialect=org.hibernate.dialect.SQLServerDialect

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=
blueriq.hibernate.trace.dialect=org.hibernate.dialect.SQLServerDialect

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=
blueriq.hibernate.reporting.dialect=org.hibernate.dialect.SQLServerDialect

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 Install plugins.

JNDI datasources

When using the jndidatasources profile, the jndiName property should be set, the url, username, password and driverClassName aren't needed.

...