...
Scripts to create the required database content are provided for the following databases:
Info |
---|
For customers that are upgrading an existing version of Blueriq, database upgrade scripts are provided in the Upgrade Instructions when applicable. |
...
UI Expand |
---|
|
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 Comments SQL Store component is using the process-sql-store datasource to store data. The processThe process-sql-store datasource can be configured using JDBC or JNDI.
Using JDBC datasource datasource : this can be configured in the application-externaldatasources.properties file. When configuring external datasources, the e xternaldatasourcesexternaldatasources profile should be enabled. Code Block |
---|
language | powershell |
---|
title | application-externaldatasources.properties |
---|
| blueriq.datasource.process-sql-store.url=jdbc:sqlserver://<database_url>:1433<port>;databaseName=bq_processcomments;instance=SQL_EXPRESS
blueriq.datasource.process-sql-store.username=<username>
blueriq.datasource.process-sql-store.password=<password>
blueriq.datasource.process-sql-store.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
blueriq.hibernate.process-sql-store.hbm2ddl.auto=validate
blueriq.hibernate.process-sql-store.dialect=org.hibernate.dialect.SQLServerDialectSQLServer2012Dialect |
Using JNDI datasource : this can be configured in the application-jndidatasources.properties file When configuring JNDI datasources the jndidatasources profile should be enabled. Code Block |
---|
language | powershell |
---|
title | application-jndidatasources.properties |
---|
| blueriq.datasource.process-sql-store.jndiName=java:/comp/env/jdbc/ | processmain
blueriq.hibernate.process-sql-store.hbm2ddl.auto=validate
blueriq.hibernate.process-sql-store.dialect=org.hibernate.dialect. | SQLServerDialect
- Configuring the datasource from the Development Dashboard
Go to Settings Widget → Datasources tab → On the left side menu : select select process-sql-store 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.
Supported dialects: - org.hibernate.dialect.SQLServer2012Dialect (for SQL Server)
- org.hibernate.dialect.Oracle10gDialect (for Oracle)
- org.hibernate.dialect.H2Dialect (for H2) (we do not recommend using a H2 database in production environments)
Supported hbm2ddl.auto values: |
UI Expand |
---|
|
Configuring the database connection for the Blueriq Component DCM in .Net is done by adding a connection configuration to the Include Page |
---|
| _PropertiesFileNet |
---|
| _PropertiesFileNet |
---|
| file. Code Block |
---|
language | xml |
---|
title | .NET database configuration example |
---|
| <hibernate-configuration>
<session-factories>
<session-factory name="ProcessCaseDao">
<properties>
<property name="connection.provider" value="NHibernate.Connection.DriverConnectionProvider" />
<property name="dialect" value="NHibernate.Dialect.MsSqlCeDialectMsSql2012Dialect" />
<property name="connection.driver_class" value="NHibernate.Driver.SqlServerCeDriverSqlClientDriver" />
<property name="connection.connection_string" value="Data Source=D:\Databases\ProcessDB.sdfServer=HOST\SQLEXPRESS;Database=test;User Id=USERNAME;Password=PASSWORD;" />
<property name="show_sql" value="false" />
<property name="current_session_context_class" value="Aquima.WebApplication.WebPersistenceUtility.Session.CurrentHibernateSessionContext, WebPersistenceUtility" />
</properties>
</session-factory>
</session-factories>
</hibernate-configuration> |
Supported dialects: - NHibernate.Dialect.MsSql2012Dialect
For more information about configuring database connections, see Configuring database connections in .NET webapp. Info |
---|
The Process SQL store component looks for a database connection named "ProcessCaseDao" so make sure that this name is used in order to configure the Process DAO properly. |
All necessary DLL files on which the Blueriq Component DCM depends can be found in the /bin directory of the webapp ZIP file. |