Versions Compared

Key

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

Configure the properties below in application-externaldatasources.properties which is on the classpath.



Property nameExample value 

datasource.main.url

jdbc:sqlserver://WKS-1966:1433;databaseName=bq_main;instance=SQL_EXPRESS 

datasource.main.username

blueriq 

datasource.main.password

welcome 

datasource.main.driverClassName

com.microsoft.sqlserver.jdbc.SQLServerDriver 

hibernate.main.hbm2ddl.auto

update 

hibernate.main.dialect

org.hibernate.dialect.SQLServerDialect

 

datasource.trace.url

jdbc:sqlserver://WKS-1966:1433;databaseName=bq_trace;instance=SQL_EXPRESS

 

datasource.trace.username

blueriq 

datasource.trace.password

welcome 

datasource.trace.driverClassName

com.microsoft.sqlserver.jdbc.SQLServerDriver 

datasource.reporting.url

jdbc:sqlserver://WKS-1966:1433;databaseName=bq_reporting;instance=SQL_EXPRESS

 

datasource.reporting.username=blueriq

blueriq 

datasource.reporting.password

welcome 

datasource.reporting.driverClassName

com.microsoft.sqlserver.jdbc.SQLServerDriver 
hibernate.reporting.hbm2ddl.autoupdate 
hibernate.reporting.dialectorg.hibernate.dialect.SQLServerDialect