Page History
...
Add the artifact with groupId com.blueriq
and artifactId blueriq-component-tracetimeline-sql-store
as a dependency to your Blueriq runtime POM file if you want to depend on it.
...
UI Text Box | ||
---|---|---|
| ||
Please make sure the trace-sql-store has a separate datasource. Using the same datasource for other components is known to cause errors. |
Use the following steps to configure the datasource:
- If necessary, create a new datasource. See Configuring JDBC database drivers for information on how to do this.
- Timeline SQL Store component is using the timeline-sql-store datasource to store data. The timeline-sql-store datasource can be configured using JDBC or JNDI.
Using JDBC datasource: this can be configured in the
application-externaldatasources.properties
file. When configuring external datasources, theexternaldatasources
profile should be enabled.Code Block language powershell title Example application-externaldatasources.properties blueriq.datasource.timeline-sql-store.url=jdbc:sqlserver://<database_url>:<port>;databaseName=bq_commentstimeline;instance=SQL_EXPRESS blueriq.datasource.timeline-sql-store.username=<username> blueriq.datasource.timeline-sql-store.password=<password> blueriq.datasource.timeline-sql-store.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver blueriq.hibernate.timeline-sql-store.hbm2ddl.auto=validate blueriq.hibernate.timeline-sql-store.dialect=org.hibernate.dialect.SQLServer2012Dialect
Using JNDI datasource: this can be configured in the
application-jndidatasources.properties
file When configuring JNDI datasources thejndidatasources
profile should be enabled.Code Block language powershell title Example application-jndidatasources.properties blueriq.datasource.timeline-sql-store.jndiName=java:/comp/env/jdbc/blueriqTimeline blueriq.hibernate.timeline-sql-store.hbm2ddl.auto=validate blueriq.hibernate.timeline-sql-store.dialect=org.hibernate.dialect.SQLServer2012Dialect
- Hibernate settings
These settings are done for each datasource type in the corresponding properties file, as in the examples above.
Supported dialects:
- org.hibernate.dialect.SQLServer2012Dialect (for SQL Server)
- org.hibernate.dialect.Oracle12cDialect (for Oracle)
- org.hibernate.dialect.H2Dialect (for H2) (we do not recommend using a H2 database in production environments)
Supported hbm2ddl.auto values:
- none
- validate
...