Use the following steps to configure the datasource: - If necessary, create a new datasource. See R10 Configuring JDBC database drivers [editor] for information on how to do this.
- Process SQL Store component is using the main datasource to store data. The main datasource can be configured using JDBC or JNDI.
Using JDBC datasource : this can be configured in the application-externaldatasources.properties file. When configuring external datasources , the e xternaldatasources profile should be enabled. application-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
|
Using JNDI datasource : this can be configured in the application-jndidatasources.properties file When configuring JNDI datasources the jndidatasources profile should be enabled. application-jndidatasources.properties blueriq.hibernate.main.hbm2ddl.auto=validate
blueriq.hibernate.main.dialect=org.hibernate.dialect.SQLServerDialect
|
- Configuring the datasource from the Development Dashboard
Go to Settings Widget → Datasources tab → On the left side menu : select Main datasource. The same properties are available for configuration as from the properties file. Make sure the corresponding profile is enabled (externaldatasources or jndidatasources) - Hibernate settings
These settings are done for each datasource type in the corresponding properties file, as in the examples above.
|