Page History
Table of contents
Table of Contents
Description
The Comments SQL store 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 plugincomponent (see Container types), which use an in-memory DAO (for development purpose only) by default.
Requirements
The Comments SQL store component depends on the Dashboard plugin so make sure to include this plugin as well when using the Comments SQL store.
This component persists data in a database, that must be provided. See platform support for the supported databases.
Installation
...
title | Java |
---|
...
UI Expand | ||
---|---|---|
| ||
Make sure to put the CommentsDao.dll file in the /bin directory of your .Net webapp installation. |
Configuration
Database
Scripts to create the required database content are provided for the following databases:
- H2 (download) (we do not recommend using a H2 database in production environments)
- Microsoft SQL Server (download)
- Oracle (download)
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:
...
Code Block |
---|
comments.dao.connection=commentsdao_datasource_name |
...
An additional properties file named comments.dao.hibernate.properties can be used to set the Hibernate properties.
...
...
title | .NET |
---|
...
Code Block | ||||
---|---|---|---|---|
| ||||
<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.
Info |
---|
The Comments SQL store component looks for a database connection named "CommentsDao" so make sure that this name is used in order to configure the Comments DAO properly. |
All necessary DLL files on which the Comments SQL store component depends can be found in the Plugins/CommentsDao/Lib directory of the webapp ZIP file.
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
The name of the datasource is comments-sql-store.
Include Page | ||||
---|---|---|---|---|
|