Versions Compared

Key

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

...

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

...

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

...

Code Block
titleapplication-jndidatasources.properties
blueriq.datasource.main.jndiName=java:/comp/env/jdbc/main
blueriq.hibernate.main.hbm2ddl.auto=createvalidate

blueriq.datasource.trace.jndiName=java:/comp/env/jdbc/trace
blueriq.hibernate.trace.hbm2ddl.auto=createvalidate

blueriq.datasource.reporting.jndiName=java:/comp/env/jdbc/reporting
blueriq.hibernate.reporting.hbm2ddl.auto=createvalidate

spring.jmx.enabled=false
endpoints.jmx.unique-names=true