Page History

...

This component persists data in a database, that must be configured as a connection. See Platform Support for the supported databases.

Installation

...

In order to use this component, the 

Add the artifact with groupId com.blueriq and artifactId blueriq-component-reporting-sql-store as a dependency to your Blueriq runtime POM file.

Configuration

Database

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

...

See Configuring database connection for information on how to create new connections for the different datasources.Use the following steps to configure the database connection:

1. Using JDBC datasource:

   • If necessary, create a new connection. The connection needs to be configured in the

     Include Page
     _PropertiesFileJava _PropertiesFileJava

     file.

   • Code Block
     language powershell title application.properties
     blueriq.connection.reporting_local_sql.sql.url=jdbc:sqlserver://<database_url>:<port_number>;databaseName=<database_name>;instance=<instance_name> blueriq.connection.reporting_local_sql.sql.username=<username> blueriq.connection.reporting_local_sql.sql.password=<password> blueriq.connection.reporting_local_sql.sql.type=jdbc blueriq.connection.reporting_local_sql.sql.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver blueriq.connection.reporting_local_sql.sql.poolInitialSize=0 blueriq.connection.reporting_local_sql.sql.poolMaxIdle=8 blueriq.connection.reporting_local_sql.sql.poolMaxTotal=8 blueriq.connection.reporting_local_sql.sql.poolMaxWait=-1L blueriq.connection.reporting_local_sql.sql.poolMinIdle=0 blueriq.connection.reporting_local_sql.sql.minEvictableIdleTimeMillis=1800000 blueriq.connection.reporting_local_sql.sql.numTestsPerEvictionRun=3 blueriq.connection.reporting_local_sql.sql.testOnBorrow=true blueriq.connection.reporting_local_sql.sql.testOnReturn=false blueriq.connection.reporting_local_sql.sql.testWhileIdle=false blueriq.connection.reporting_local_sql.sql.timeBetweenEvictionRunsMillis=-1 blueriq.connection.reporting_local_sql.sql.validationQuery="" blueriq.connection.reporting_local_sql.sql.validationQueryTimeout=-1

    

2. Using JNDI datasource:

• • If necessary, create a new connection. The connection needs to be configured in the

    Include Page
    _PropertiesFileJava _PropertiesFileJava

    file.

  • Code Block
    language powershell title application.properties
    blueriq.connection.reporting_local_sql.sql.jndi=java:/comp/env/jdbc/reporting blueriq.connection.reporting_local_sql.sql.type=jndi

     

     

• In Studio the previously configured connection name needs to be used as the Connection parameter of the AQ_Report service.

  Example configuration: In the previous example the name of the connection is reporting_local_sql .

• Configuring the database connection from the Development Dashboard
  Go to Settings Widget → Connections tab → On the left side menu : select SQL connection. The same properties are available for configuration as from the properties file.  You can perform CRUD operations on connections from here

...

Use the following steps to configure the database connection:

...

Example configuration:

<hibernate-configuration>
  <session-factories>
      <session-factory name="ReportingDao">
        <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="Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\LocalDB\ReportingDB.mdf;Integrated Security=True" />
          <property name="hbm2ddl.auto" value="update" />
          <property name="current_session_context_class" value="Aquima.WebApplication.WebPersistenceUtility.Session.CurrentHibernateSessionContext, WebPersistenceUtility" />
        </properties>
      </session-factory>
  </session-factories>
</hibernate-configuration>

• In Studio the previously configured connection name needs to be used as the Connection parameter of the AQ_Report service.

  Example configuration: In the previous example the name of the connection is ReportingDao.

Supported dialects:

...