I am facing error when generating schema manually instead for generating automatically from hbm files.
Error:
16:44:37,838 ERROR [org.dashbuilder.dataprovider.sql.JDBCUtils] (http-0.0.0.0:8080-6) SELECT * FROM ProcessInstanceLog
16:44:37,839 ERROR [org.dashbuilder.dataprovider.sql.JDBCUtils] (http-0.0.0.0:8080-6) SELECT * FROM ProcessInstanceLog
16:44:37,840 ERROR [org.dashbuilder.dataprovider.sql.JDBCUtils] (http-0.0.0.0:8080-6) SELECT TOP 1 * FROM ProcessInstanceLog
16:44:37,841 ERROR [org.dashbuilder.exception.ExceptionManager] (http-0.0.0.0:8080-6) Can't get metadata on specified data set: jbpmProcessInstances: org.dashbuilder.dataset.exception.DataSetLookupException: Can't get metadata on specified data set: jbpmProcessInstances
at org.dashbuilder.dataset.DataSetManagerImpl.getDataSetMetadata(DataSetManagerImpl.java:181)
I have create schema manually from the DDL scripts and made below configuration changes,
Changes in Persistance.xml ({JBOSS_HOME}\standalone\deployments\business-central.war\WEB-INF\classes\META-INF):
1)Update dialect to <property name="hibernate.dialect" value="org.hibernate.dialect.SQLServerDialect" />. {I am using MS SQL SERVER 2014}
2)Added <property name="hibernate.default_schema" value="jbpm" /> all tables are created under jbpm schema.
3) Changed value from update to validate in "<property name="hibernate.hbm2ddl.auto" value="validate" />"
Changes in hibernate.cfg.xml ({JBOSS_HOME}\standalone\deployments\dashbuilder.war\WEB-INF\etc) :
Added new property "<property name="hibernate.default_schema">jbpm</property> " under <session-factory>
After clicking on Processintance Instances tab i am facing error. I am attaching full trace .
Note :I am not facing issue if hbm generates tables own its own.