Versions Compared

Old Version 14

changes.mady.by.user Unknown User (m.schadd)

Saved on

compared with

New Version 15

changes.mady.by.user Unknown User (s.wartenberg)

Saved on

Key

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

...

UI Expand
titleJava

In order to use this component, the reporting-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.

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

UI Expand
title.NET

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

...

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

...

UI Expand
title.NET

Use the following steps to configure the database connection:

  • Configuring the database connection for the Reporting SQL Store component in .Net is done by adding a connection configuration to the Web.config file:

    Example configuration:

    Code Block
    title.NET database configuration example
    <hibernate-configuration>
  <session-factories>
    <session-factory name="ReportingDao">
      <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=|DataDirectory|\LocalDB\ReportingDB.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>

  • 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:

  • NHibernate.Dialect.MsSql2012Dialect

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