Page History
...
This component persists data in a database, that must be provided. See platform support for the supported databases.
Installation
...
title | Java |
---|
...
In order to use this component, the process-sql-store profile must be active. More information on how to configure the application using Spring Profiles can be found here : R10 External application configuration with Spring Profiles [editor].
Add the artifact with groupId "com.blueriq"
and artifactId "blueriq-component-process-sql-store"
as a dependency to your Blueriq runtime POM file if you want to depend on it
...
title | .NET |
---|
...
.
Configuration
Database
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. |
...
...
title | Java |
---|
Use the following steps to configure the datasource:
- If necessary, create a new datasource. See Configuring JDBC database drivers for information on how to do this.
- Process SQL Store component is using the process-sql-store datasource to store data. The process-sql-store 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, theexternaldatasources
profile should be enabled.Code Block language powershell title application-externaldatasources.properties blueriq.datasource.process-sql-store.url=jdbc:sqlserver://<database_url>:<port>;databaseName=bq_comments;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.SQLServer2012Dialect
Using JNDI datasource : this can be configured in the
application-jndidatasources.properties
file When configuring JNDI datasources thejndidatasources
profile should be enabled.Code Block language powershell title application-jndidatasources.properties blueriq.datasource.process-sql-store.jndiName=java:/comp/env/jdbc/main blueriq.hibernate.process-sql-store.hbm2ddl.auto=validate blueriq.hibernate.process-sql-store.dialect=org.hibernate.dialect.SQLServer2012Dialect
- Configuring the datasource from the Development Dashboard
Go to Settings Widget → Datasources tab → On the left side menu : selectprocess-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:
- none
- validate
...
title | .Net |
---|
...
Code Block | ||||
---|---|---|---|---|
| ||||
<hibernate-configuration>
<session-factories>
<session-factory name="ProcessCaseDao">
<properties>
<property name="connection.provider" value="NHibernate.Connection.DriverConnectionProvider" />
<property name="dialect" value="NHibernate.Dialect.MsSql2012Dialect" />
<property name="connection.driver_class" value="NHibernate.Driver.SqlClientDriver" />
<property name="connection.connection_string" value="Server=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. |
...