Versions Compared

Old Version 2

changes.mady.by.user Unknown User (emoke.olti)

Saved on

compared with

New Version 3

changes.mady.by.user Unknown User (emoke.olti)

Saved on

Key

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

...

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

 

Info

For customers that are upgrading an existing version of Blueriq, database upgrade scripts are provided in the Upgrade Instructions when applicable.

in directly or by using the Development plugin. So, either:
  1. Set the following property in
:
UI Expand
titleJava

Use the following steps to configure the component datasource:

  1. If necessary, create a new datasource. See Configuring JDBC database connections in the Java webappdrivers for information on how to do this.
  2. The Trace SQL Store component is using the trace datasource to store data.The trace datasource can be configured using JDBC or JNDI.

    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
      languagepowershell
      titleapplication-externaldatasources.properties
      blueriq.datasource.trace.url=jdbc:sqlserver://<database_url>:<port>;databaseName=bq_main;instance=SQLEXPRESS
blueriq.datasource.trace.username=<username>
blueriq.datasource.trace.password=<password>
blueriq.datasource.trace.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
blueriq.hibernate.trace.hbm2ddl.auto=validate
blueriq.hibernate.trace.dialect=org.hibernate.dialect.SQLServerDialect
    2. Using JNDI datasource : this can be configured in the  application-jndidatasources.properties file When configuring JNDI datasources the jndidatasources profile should be enabled
    Link the datasource to the trace DAO plugin. This can be done by editing
Include Page
_PropertiesFileJava_PropertiesFileJava
Include Page
_HomeFolder_HomeFolder
Include Page
_PropertiesFileJava_PropertiesFileJava
Code Block
trace.dao.connection=tracedao_datasource_name
In the development plugin Settings page, go to Connections -> Trace engine database and select the correct datasource.

  • An additional properties file named tracedao.hibernate.properties can be used to set the Hibernate properties.

    Excerpt Include
    _HibernateProperties
    _HibernateProperties
    nopaneltrue

    •  

    ...