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 plugin (see Container types), which use an in-memory DAO 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
Unzip the CommentsDao-Plugin-x.y.z.zip and copy the extracted folders to the runtime folder (make sure that the spring.config.additional-location folder is merged).
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:
Link the datasource to the comments DAO plugin. This can be done by editing application.properties in spring.config.additional-location directly or by using the Development plugin. So, either:
Set the following property in application.properties:
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.