Versions Compared

Old Version 3

changes.mady.by.user Alexandra Aldea

Saved on

compared with

New Version Current

changes.mady.by.user Geert Graat

Saved on

Key

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


 

Table of contents 

Table of Contents

Description 

This component contains a process DAO implementation for storing the process engine data. It is used by the worklist container to display open tasks.

...

This worklist implementation does NOT use the mapping from the Process module to the PCA module. This is done to increase performance.

Requirements

This component persists data in a database, that must be provided. See platform support for the supported databases.

Installation

...

titleJava

...

 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 :

...

External application configuration with Spring Profiles

...

UI Expand
title.NET

In order to use this component, make sure to have the BlueriqComponentDCM.dll in the /bin directory of your .NET webapp installation.

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.

 

...

titleJava

Use the following steps to configure the datasource:

...

Using JDBC datasource  : this can be configured in the  application-externaldatasources.properties file. When configuring external datasources , the externaldatasources profile should be enabled.

...

 

...

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

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.

Configuration

The name of the datasource is process-sql-store.

Include Page
_DatasourceConfiguration
_DatasourceConfiguration

Case insensitive searching

SQL Server is case insensitive by default. This makes it possible to search Case Data in a case insensitive way in this database. By default Oracle and PostgreSQL are case sensitive, wich means searching in Case Data is also case sensitive in these databases.

We created the possibility to enable case insensitive searching on case sensitive databases. For more information on how to enable it see: How to enable case insensitive search on case data for Oracle & PostgreSQL

Using JNDI datasource : this can be configured in the  application-jndidatasources.properties file When configuring JNDI datasources the jndidatasources profile should be enabled.

...

 

...

blueriq.datasource.main.jndiName=java:/comp/env/jdbc/main
blueriq.hibernate.main.hbm2ddl.auto=validate
blueriq.hibernate.main.dialect=org.hibernate.dialect.SQLServerDialect

...

title.Net

...

Code Block
languagexml
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.MsSqlCeDialect" />
        <property name="connection.driver_class" value="NHibernate.Driver.SqlServerCeDriver" />
        <property name="connection.connection_string" value="Data Source=D:\Databases\ProcessDB.sdf" />
        <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>

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.

...

.