Page History

Table of contents 

Description

The Comments SQL Store component adds the ability to connect your Runtime to a database for storing comments. It's an addition to the comment containers which are provided by the Dashboard component (see Container types), which use an in-memory DAO (for development purpose only) by default.

Requirements

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

Installation

...

The Comments SQL Store component can be used together with the Dashboard component. In this case the comments from the dashboard will be saved using the CommentDao implementation from the Comments SQL Store component.

Add the artifact with groupId "com.blueriq" and artifactId "blueriq-component-comments-sql-store" as a dependency to your Blueriq runtime POM file if you want to depend on it.

In order to use this component, the comments-sql-store profile must be active. More information on how to configure the application using Spring Profiles can be found here : Application configuration with Spring Profiles

...

...

.

...

Configuration

Database

Scripts to create the required database content are provided for the following databases:

• Microsoft SQL Server
• Oracle
• H2 (we do not recommend using a H2 database in production environments)

...

Use the following steps to configure the datasource:

...

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

   Code Block
   language powershell title application-externaldatasources.properties
   blueriq.datasource.comments-sql-store.url=jdbc:sqlserver://<database_url>:<port>;databaseName=bq_comments;instance=SQL_EXPRESS blueriq.datasource.comments-sql-store.username=<username> blueriq.datasource.comments-sql-store.password=<password> blueriq.datasource.comments-sql-store.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver blueriq.hibernate.comments-sql-store.hbm2ddl.auto=validate blueriq.hibernate.comments-sql-store.dialect=org.hibernate.dialect.SQLServer2012Dialect

2. 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.comments-sql-store.jndiName=java:/comp/env/jdbc/main blueriq.hibernate.comments-sql-store.hbm2ddl.auto=validate blueriq.hibernate.comments-sql-store.dialect=org.hibernate.dialect.SQLServer2012Dialect

...

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)

...

...

<hibernate-configuration>
  <session-factories>
    <session-factory name="CommentsDao">
      <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\CommentsDB.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.

All necessary DLL files on which the Comments SQL Store component depends can be found in the /bin directory of the .NET webapp ZIP file.

Configuration

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