[jboss-user] [jBPM] - A problem when I use mysql instead of H2, my JBPM version is 5.3

yiCheng liu do-not-reply at jboss.com
Tue Jan 29 04:22:08 EST 2013 

yiCheng liu [https://community.jboss.org/people/yeyinveda] created the discussion

"A problem when I use mysql instead of H2,my JBPM version is 5.3"

To view the discussion, visit: https://community.jboss.org/message/794823#794823

--------------------------------------------------------------
I have change all the configuration of H2 to mysql's,and add hibernate.cfg.xml and orm.xml to META-INF directory.But ,when I run it ,I encounter a error:
    29/01 17:13:59,201[main] ERROR hibernate.hql.PARSER.reportError  -  Unable to locate appropriate constructor on class [org.jbpm.task.query.TaskSummary]
[cause=org.hibernate.PropertyNotFoundException: no appropriate constructor in class: org.jbpm.task.query.TaskSummary]
46   29/01 17:13:59,247[main] ERROR hibernate.hql.PARSER.reportError  -  Unable to locate appropriate constructor on class [org.jbpm.task.query.TaskSummary]
[cause=org.hibernate.PropertyNotFoundException: no appropriate constructor in class: org.jbpm.task.query.TaskSummary]
57   29/01 17:13:59,258[main] ERROR hibernate.hql.PARSER.reportError  -  Unable to locate appropriate constructor on class [org.jbpm.task.query.TaskSummary]
[cause=org.hibernate.PropertyNotFoundException: no appropriate constructor in class: org.jbpm.task.query.TaskSummary]
70   29/01 17:13:59,271[main] ERROR hibernate.hql.PARSER.reportError  -  Unable to locate appropriate constructor on class [org.jbpm.task.query.TaskSummary]
[cause=org.hibernate.PropertyNotFoundException: no appropriate constructor in class: org.jbpm.task.query.TaskSummary]
85   29/01 17:13:59,286[main] ERROR hibernate.hql.PARSER.reportError  -  Unable to locate appropriate constructor on class [org.jbpm.task.query.TaskSummary]
[cause=org.hibernate.PropertyNotFoundException: no appropriate constructor in class: org.jbpm.task.query.TaskSummary]
95   29/01 17:13:59,296[main] ERROR hibernate.hql.PARSER.reportError  -  Unable to locate appropriate constructor on class [org.jbpm.task.query.TaskSummary]
[cause=org.hibernate.PropertyNotFoundException: no appropriate constructor in class: org.jbpm.task.query.TaskSummary]
108  29/01 17:13:59,309[main] ERROR hibernate.hql.PARSER.reportError  -  Unable to locate appropriate constructor on class [org.jbpm.task.query.TaskSummary]
[cause=org.hibernate.PropertyNotFoundException: no appropriate constructor in class: org.jbpm.task.query.TaskSummary]
127  29/01 17:13:59,328[main] ERROR hibernate.hql.PARSER.reportError  -  Unable to locate appropriate constructor on class [org.jbpm.task.query.TaskSummary]
[cause=org.hibernate.PropertyNotFoundException: no appropriate constructor in class: org.jbpm.task.query.TaskSummary]
137  29/01 17:13:59,338[main] ERROR hibernate.hql.PARSER.reportError  -  Unable to locate appropriate constructor on class [org.jbpm.task.query.TaskSummary]
[cause=org.hibernate.PropertyNotFoundException: no appropriate constructor in class: org.jbpm.task.query.TaskSummary]
148  29/01 17:13:59,349[main] ERROR hibernate.hql.PARSER.reportError  -  Unable to locate appropriate constructor on class [org.jbpm.task.query.TaskSummary]
[cause=org.hibernate.PropertyNotFoundException: no appropriate constructor in class: org.jbpm.task.query.TaskSummary]
157  29/01 17:13:59,358[main] ERROR hibernate.hql.PARSER.reportError  -  Unable to locate appropriate constructor on class [org.jbpm.task.query.TaskSummary]
[cause=org.hibernate.PropertyNotFoundException: no appropriate constructor in class: org.jbpm.task.query.TaskSummary]
160  29/01 17:13:59,361[main] ERROR hibernate.impl.SessionFactoryImpl.<init>  - Error in named query: TasksAssignedAsPotentialOwner
org.hibernate.hql.ast.QuerySyntaxException: Unable to locate appropriate constructor on class [org.jbpm.task.query.TaskSummary] [select new org.jbpm.task.query.TaskSummary( t.id, t.taskData.processInstanceId, names.text, subject.text, descriptions.text, t.taskData.status, t.priority, t.taskData.skipable, t.taskData.actualOwner, t.taskData.createdBy, t.taskData.createdOn, t.taskData.activationTime, t.taskData.expirationTime) from org.jbpm.task.Task t left join t.taskData.createdBy left join t.taskData.actualOwner left join t.subjects as subject, org.jbpm.task.I18NText names, org.jbpm.task.I18NText descriptions, org.jbpm.task.OrganizationalEntity potentialOwners where potentialOwners.id = :userId and potentialOwners in elements ( t.peopleAssignments.potentialOwners ) and names.language = :language and names in elements( t.names) and ( subject.language = :language or t.subjects.size = 0 ) and ( descriptions.language = :language and descriptions in elements( t.descriptions) or t.descriptions.size = 0 ) and t.taskData.status in ('Created', 'Ready', 'Reserved', 'InProgress', 'Suspended') and t.taskData.expirationTime is null]
          at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:54)
          at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:47)
          at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:82)
          at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:261)
          at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:185)
          at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
          at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
          at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
          at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:94)
          at org.hibernate.impl.SessionFactoryImpl.checkNamedQueries(SessionFactoryImpl.java:484)
          at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:394)
          at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1341)
          at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:867)
          at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:669)
          at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:126)
          at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:52)
          at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:34)
          at ProcessTest.createKnowledgeSession(ProcessTest.java:152)
          at ProcessTest.main(ProcessTest.java:111)
161  29/01 17:13:59,362[main] ERROR hibernate.impl.SessionFactoryImpl.<init>  - Error in named query: UnescalatedDeadlines
org.hibernate.QueryException: Unable to render boolean literal value [select new org.jbpm.task.query.DeadlineSummary( t.id, d.id, d.date) from org.jbpm.task.Task t, org.jbpm.task.Deadline d where (d in elements( t.deadlines.startDeadlines ) or d in elements( t.deadlines.endDeadlines ) ) and d.escalated = false order by d.date]
          at org.hibernate.hql.ast.tree.BooleanLiteralNode.getRenderText(BooleanLiteralNode.java:71)
          at org.hibernate.hql.ast.SqlGenerator.out(SqlGenerator.java:131)
          at org.hibernate.hql.antlr.SqlGeneratorBase.simpleExpr(SqlGeneratorBase.java:2539)
          at org.hibernate.hql.antlr.SqlGeneratorBase.expr(SqlGeneratorBase.java:1443)
          at org.hibernate.hql.antlr.SqlGeneratorBase.binaryComparisonExpression(SqlGeneratorBase.java:2820)
          at org.hibernate.hql.antlr.SqlGeneratorBase.comparisonExpr(SqlGeneratorBase.java:1262)
          at org.hibernate.hql.antlr.SqlGeneratorBase.booleanExpr(SqlGeneratorBase.java:900)
          at org.hibernate.hql.antlr.SqlGeneratorBase.booleanOp(SqlGeneratorBase.java:2733)
          at org.hibernate.hql.antlr.SqlGeneratorBase.booleanExpr(SqlGeneratorBase.java:880)
          at org.hibernate.hql.antlr.SqlGeneratorBase.whereExpr(SqlGeneratorBase.java:762)
          at org.hibernate.hql.antlr.SqlGeneratorBase.selectStatement(SqlGeneratorBase.java:191)
          at org.hibernate.hql.antlr.SqlGeneratorBase.statement(SqlGeneratorBase.java:119)
          at org.hibernate.hql.ast.QueryTranslatorImpl.generate(QueryTranslatorImpl.java:238)
          at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:205)
          at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
          at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
          at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
          at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:94)
          at org.hibernate.impl.SessionFactoryImpl.checkNamedQueries(SessionFactoryImpl.java:484)
          at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:394)
          at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1341)
          at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:867)
          at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:669)
          at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:126)
          at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:52)
          at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:34)
          at ProcessTest.createKnowledgeSession(ProcessTest.java:152)
          at ProcessTest.main(ProcessTest.java:111)
Caused by: java.lang.ClassCastException: org.hibernate.type.ShortType cannot be cast to org.hibernate.type.BooleanType
          at org.hibernate.hql.ast.tree.BooleanLiteralNode.getTypeInternal(BooleanLiteralNode.java:46)
          at org.hibernate.hql.ast.tree.BooleanLiteralNode.getRenderText(BooleanLiteralNode.java:68)
          ... 27 more
162  29/01 17:13:59,363[main] ERROR hibernate.impl.SessionFactoryImpl.<init>  - Error in named query: TasksAssignedAsTaskStakeholder
org.hibernate.hql.ast.QuerySyntaxException: Unable to locate appropriate constructor on class [org.jbpm.task.query.TaskSummary] [select new org.jbpm.task.query.TaskSummary( t.id, t.taskData.processInstanceId, names.text, subjects.text, descriptions.text, t.taskData.status, t.priority, t.taskData.skipable, t.taskData.actualOwner, t.taskData.createdBy, t.taskData.createdOn, t.taskData.activationTime, t.taskData.expirationTime) from org.jbpm.task.Task t left join t.taskData.createdBy, org.jbpm.task.I18NText names, org.jbpm.task.I18NText subjects, org.jbpm.task.I18NText descriptions, org.jbpm.task.OrganizationalEntity taskStakeholder where taskStakeholder.id = :userId and taskStakeholder in elements ( t.peopleAssignments.taskStakeholders ) and names.language = :language and names in elements( t.names) and ( subjects.language = :language and subjects in elements( t.subjects) or t.subjects.size = 0 ) and ( descriptions.language = :language and descriptions in elements( t.descriptions) or t.descriptions.size = 0 ) and t.taskData.expirationTime is null]
          at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:54)
          at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:47)
          at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:82)
          at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:261)
          at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:185)
          at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
          at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
          at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
          at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:94)
          at org.hibernate.impl.SessionFactoryImpl.checkNamedQueries(SessionFactoryImpl.java:484)
          at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:394)
          at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1341)
          at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:867)
          at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:669)
          at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:126)
          at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:52)
          at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:34)
          at ProcessTest.createKnowledgeSession(ProcessTest.java:152)
          at ProcessTest.main(ProcessTest.java:111)
162  29/01 17:13:59,363[main] ERROR hibernate.impl.SessionFactoryImpl.<init>  - Error in named query: TasksAssignedAsRecipient
org.hibernate.hql.ast.QuerySyntaxException: Unable to locate appropriate constructor on class [org.jbpm.task.query.TaskSummary] [select new org.jbpm.task.query.TaskSummary( t.id, t.taskData.processInstanceId, names.text, subjects.text, descriptions.text, t.taskData.status, t.priority, t.taskData.skipable, t.taskData.actualOwner, t.taskData.createdBy, t.taskData.createdOn, t.taskData.activationTime, t.taskData.expirationTime) from org.jbpm.task.Task t left join t.taskData.createdBy, org.jbpm.task.I18NText names, org.jbpm.task.I18NText subjects, org.jbpm.task.I18NText descriptions, org.jbpm.task.OrganizationalEntity recipients where recipients.id = :userId and recipients in elements ( t.peopleAssignments.recipients ) and names.language = :language and names in elements( t.names) and ( subjects.language = :language and subjects in elements( t.subjects) or t.subjects.size = 0 ) and ( descriptions.language = :language and descriptions in elements( t.descriptions) or t.descriptions.size = 0 ) and t.taskData.expirationTime is null]
          at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:54)
          at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:47)
          at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:82)
          at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:261)
          at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:185)
          at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
          at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
          at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
          at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:94)
          at org.hibernate.impl.SessionFactoryImpl.checkNamedQueries(SessionFactoryImpl.java:484)
          at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:394)
          at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1341)
          at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:867)
          at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:669)
          at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:126)
          at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:52)
          at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:34)
          at ProcessTest.createKnowledgeSession(ProcessTest.java:152)
          at ProcessTest.main(ProcessTest.java:111)
162  29/01 17:13:59,363[main] ERROR hibernate.impl.SessionFactoryImpl.<init>  - Error in named query: TasksAssignedAsPotentialOwnerByGroup
org.hibernate.hql.ast.QuerySyntaxException: Unable to locate appropriate constructor on class [org.jbpm.task.query.TaskSummary] [select new org.jbpm.task.query.TaskSummary( t.id, t.taskData.processInstanceId, names.text, subjects.text, descriptions.text, t.taskData.status, t.priority, t.taskData.skipable, t.taskData.actualOwner, t.taskData.createdBy, t.taskData.createdOn, t.taskData.activationTime, t.taskData.expirationTime) from org.jbpm.task.Task t left join t.taskData.createdBy left join t.taskData.actualOwner, org.jbpm.task.I18NText names, org.jbpm.task.I18NText subjects, org.jbpm.task.I18NText descriptions, org.jbpm.task.OrganizationalEntity potentialOwners where potentialOwners.id = :groupId and potentialOwners in elements ( t.peopleAssignments.potentialOwners ) and names.language = :language and names in elements( t.names) and ( subjects.language = :language and subjects in elements( t.subjects) or t.subjects.size = 0 ) and ( descriptions.language = :language and descriptions in elements( t.descriptions) or t.descriptions.size = 0 ) and t.taskData.status in ('Created', 'Ready', 'Reserved', 'InProgress', 'Suspended') and t.taskData.expirationTime is null]
          at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:54)
          at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:47)
          at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:82)
          at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:261)
          at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:185)
          at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
          at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
          at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
          at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:94)
          at org.hibernate.impl.SessionFactoryImpl.checkNamedQueries(SessionFactoryImpl.java:484)
          at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:394)
          at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1341)
          at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:867)
          at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:669)
          at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:126)
          at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:52)
          at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:34)
          at ProcessTest.createKnowledgeSession(ProcessTest.java:152)
          at ProcessTest.main(ProcessTest.java:111)
163  29/01 17:13:59,364[main] ERROR hibernate.impl.SessionFactoryImpl.<init>  - Error in named query: TasksAssignedAsExcludedOwner
org.hibernate.hql.ast.QuerySyntaxException: Unable to locate appropriate constructor on class [org.jbpm.task.query.TaskSummary] [select new org.jbpm.task.query.TaskSummary( t.id, t.taskData.processInstanceId, names.text, subjects.text, descriptions.text, t.taskData.status, t.priority, t.taskData.skipable, t.taskData.actualOwner, t.taskData.createdBy, t.taskData.createdOn, t.taskData.activationTime, t.taskData.expirationTime) from org.jbpm.task.Task t left join t.taskData.createdBy, org.jbpm.task.I18NText names, org.jbpm.task.I18NText subjects, org.jbpm.task.I18NText descriptions, org.jbpm.task.OrganizationalEntity excludedOwners where excludedOwners.id = :userId and excludedOwners in elements ( t.peopleAssignments.excludedOwners ) and names.language = :language and names in elements( t.names) and ( subjects.language = :language and subjects in elements( t.subjects) or t.subjects.size = 0 ) and ( descriptions.language = :language and descriptions in elements( t.descriptions) or t.descriptions.size = 0 ) and t.taskData.expirationTime is null]
          at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:54)
          at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:47)
          at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:82)
          at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:261)
          at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:185)
          at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
          at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
          at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
          at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:94)
          at org.hibernate.impl.SessionFactoryImpl.checkNamedQueries(SessionFactoryImpl.java:484)
          at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:394)
          at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1341)
          at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:867)
          at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:669)
          at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:126)
          at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:52)
          at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:34)
          at ProcessTest.createKnowledgeSession(ProcessTest.java:152)
          at ProcessTest.main(ProcessTest.java:111)
163  29/01 17:13:59,364[main] ERROR hibernate.impl.SessionFactoryImpl.<init>  - Error in named query: TasksAssignedAsBusinessAdministrator
org.hibernate.hql.ast.QuerySyntaxException: Unable to locate appropriate constructor on class [org.jbpm.task.query.TaskSummary] [select new org.jbpm.task.query.TaskSummary( t.id, t.taskData.processInstanceId, names.text, subjects.text, descriptions.text, t.taskData.status, t.priority, t.taskData.skipable, t.taskData.actualOwner, t.taskData.createdBy, t.taskData.createdOn, t.taskData.activationTime, t.taskData.expirationTime) from org.jbpm.task.Task t left join t.taskData.createdBy, org.jbpm.task.I18NText names, org.jbpm.task.I18NText subjects, org.jbpm.task.I18NText descriptions, org.jbpm.task.OrganizationalEntity businessAdministrator where businessAdministrator.id = :userId and businessAdministrator in elements ( t.peopleAssignments.businessAdministrators ) and names.language = :language and names in elements( t.names) and ( subjects.language = :language and subjects in elements( t.subjects) or t.subjects.size = 0 ) and ( descriptions.language = :language and descriptions in elements( t.descriptions) or t.descriptions.size = 0 ) and t.taskData.expirationTime is null]
          at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:54)
          at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:47)
          at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:82)
          at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:261)
          at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:185)
          at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
          at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
          at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
          at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:94)
          at org.hibernate.impl.SessionFactoryImpl.checkNamedQueries(SessionFactoryImpl.java:484)
          at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:394)
          at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1341)
          at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:867)
          at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:669)
          at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:126)
          at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:52)
          at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:34)
          at ProcessTest.createKnowledgeSession(ProcessTest.java:152)
          at ProcessTest.main(ProcessTest.java:111)
164  29/01 17:13:59,365[main] ERROR hibernate.impl.SessionFactoryImpl.<init>  - Error in named query: SubTasksAssignedAsPotentialOwner
org.hibernate.hql.ast.QuerySyntaxException: Unable to locate appropriate constructor on class [org.jbpm.task.query.TaskSummary] [select new org.jbpm.task.query.TaskSummary( t.id, t.taskData.processInstanceId, names.text, subjects.text, descriptions.text, t.taskData.status, t.priority, t.taskData.skipable, t.taskData.actualOwner, t.taskData.createdBy, t.taskData.createdOn, t.taskData.activationTime, t.taskData.expirationTime) from org.jbpm.task.Task t left join t.taskData.createdBy left join t.taskData.actualOwner, org.jbpm.task.I18NText names, org.jbpm.task.I18NText subjects, org.jbpm.task.I18NText descriptions, org.jbpm.task.OrganizationalEntity potentialOwners where t.taskData.parentId = :parentId and potentialOwners.id = :userId and potentialOwners in elements ( t.peopleAssignments.potentialOwners ) and names.language = :language and names in elements( t.names) and ( subjects.language = :language and subjects in elements( t.subjects) or t.subjects.size = 0 ) and ( descriptions.language = :language and descriptions in elements( t.descriptions) or t.descriptions.size = 0 ) and t.taskData.status in ('Created', 'Ready', 'Reserved', 'InProgress', 'Suspended') and t.taskData.expirationTime is null]
          at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:54)
          at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:47)
          at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:82)
          at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:261)
          at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:185)
          at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
          at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
          at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
          at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:94)
          at org.hibernate.impl.SessionFactoryImpl.checkNamedQueries(SessionFactoryImpl.java:484)
          at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:394)
          at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1341)
          at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:867)
          at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:669)
          at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:126)
          at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:52)
          at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:34)
          at ProcessTest.createKnowledgeSession(ProcessTest.java:152)
          at ProcessTest.main(ProcessTest.java:111)
164  29/01 17:13:59,365[main] ERROR hibernate.impl.SessionFactoryImpl.<init>  - Error in named query: ProcessInstancesWaitingForEvent
org.hibernate.hql.ast.QuerySyntaxException: ProcessInstanceInfo is not mapped [select processInstanceInfo.processInstanceId from ProcessInstanceInfo processInstanceInfo where :type in elements(processInstanceInfo.eventTypes)]
          at org.hibernate.hql.ast.util.SessionFactoryHelper.requireClassPersister(SessionFactoryHelper.java:181)
          at org.hibernate.hql.ast.tree.FromElementFactory.addFromElement(FromElementFactory.java:110)
          at org.hibernate.hql.ast.tree.FromClause.addFromElement(FromClause.java:94)
          at org.hibernate.hql.ast.HqlSqlWalker.createFromElement(HqlSqlWalker.java:316)
          at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:3228)
          at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:3112)
          at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:720)
          at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:571)
          at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:288)
          at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:231)
          at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:254)
          at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:185)
          at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
          at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
          at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
          at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:94)
          at org.hibernate.impl.SessionFactoryImpl.checkNamedQueries(SessionFactoryImpl.java:484)
          at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:394)
          at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1341)
          at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:867)
          at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:669)
          at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:126)
          at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:52)
          at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:34)
          at ProcessTest.createKnowledgeSession(ProcessTest.java:152)
          at ProcessTest.main(ProcessTest.java:111)
164  29/01 17:13:59,365[main] ERROR hibernate.impl.SessionFactoryImpl.<init>  - Error in named query: TasksOwned
org.hibernate.hql.ast.QuerySyntaxException: Unable to locate appropriate constructor on class [org.jbpm.task.query.TaskSummary] [select new org.jbpm.task.query.TaskSummary( t.id, t.taskData.processInstanceId, names.text, subjects.text, descriptions.text, t.taskData.status, t.priority, t.taskData.skipable, t.taskData.actualOwner, t.taskData.createdBy, t.taskData.createdOn, t.taskData.activationTime, t.taskData.expirationTime) from org.jbpm.task.Task t left join t.taskData.createdBy, org.jbpm.task.I18NText names, org.jbpm.task.I18NText subjects, org.jbpm.task.I18NText descriptions where t.taskData.actualOwner.id = :userId and names in elements( t.names) and names.language = :language and ( subjects.language = :language and subjects in elements( t.subjects) or t.subjects.size = 0 ) and ( descriptions.language = :language and descriptions in elements( t.descriptions) or t.descriptions.size = 0 ) and t.taskData.expirationTime is null]
          at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:54)
          at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:47)
          at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:82)
          at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:261)
          at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:185)
          at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
          at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
          at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
          at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:94)
          at org.hibernate.impl.SessionFactoryImpl.checkNamedQueries(SessionFactoryImpl.java:484)
          at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:394)
          at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1341)
          at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:867)
          at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:669)
          at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:126)
          at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:52)
          at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:34)
          at ProcessTest.createKnowledgeSession(ProcessTest.java:152)
          at ProcessTest.main(ProcessTest.java:111)
164  29/01 17:13:59,365[main] ERROR hibernate.impl.SessionFactoryImpl.<init>  - Error in named query: TasksAssignedAsPotentialOwnerWithGroups
org.hibernate.hql.ast.QuerySyntaxException: Unable to locate appropriate constructor on class [org.jbpm.task.query.TaskSummary] [select new org.jbpm.task.query.TaskSummary( t.id, t.taskData.processInstanceId, names.text, subjects.text, descriptions.text, t.taskData.status, t.priority, t.taskData.skipable, t.taskData.actualOwner, t.taskData.createdBy, t.taskData.createdOn, t.taskData.activationTime, t.taskData.expirationTime) from org.jbpm.task.Task t left join t.taskData.createdBy left join t.taskData.actualOwner, org.jbpm.task.I18NText names, org.jbpm.task.I18NText subjects, org.jbpm.task.I18NText descriptions, org.jbpm.task.OrganizationalEntity potentialOwners where ( potentialOwners.id = :userId or potentialOwners.id in (:groupIds) ) and potentialOwners in elements ( t.peopleAssignments.potentialOwners ) and names.language = :language and names in elements( t.names) and ( subjects.language = :language and subjects in elements( t.subjects) or t.subjects.size = 0 ) and ( descriptions.language = :language and descriptions in elements( t.descriptions) or t.descriptions.size = 0 ) and t.taskData.status in ('Created', 'Ready', 'Reserved', 'InProgress', 'Suspended') and t.taskData.expirationTime is null]
          at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:54)
          at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:47)
          at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:82)
          at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:261)
          at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:185)
          at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
          at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
          at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
          at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:94)
          at org.hibernate.impl.SessionFactoryImpl.checkNamedQueries(SessionFactoryImpl.java:484)
          at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:394)
          at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1341)
          at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:867)
          at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:669)
          at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:126)
          at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:52)
          at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:34)
          at ProcessTest.createKnowledgeSession(ProcessTest.java:152)
          at ProcessTest.main(ProcessTest.java:111)
165  29/01 17:13:59,366[main] ERROR hibernate.impl.SessionFactoryImpl.<init>  - Error in named query: GetSubTasksByParentTaskId
org.hibernate.hql.ast.QuerySyntaxException: Unable to locate appropriate constructor on class [org.jbpm.task.query.TaskSummary] [select new org.jbpm.task.query.TaskSummary( t.id, t.taskData.processInstanceId, names.text, subjects.text, descriptions.text, t.taskData.status, t.priority, t.taskData.skipable, t.taskData.actualOwner, t.taskData.createdBy, t.taskData.createdOn, t.taskData.activationTime, t.taskData.expirationTime) from org.jbpm.task.Task t, org.jbpm.task.I18NText names, org.jbpm.task.I18NText subjects, org.jbpm.task.I18NText descriptions where t.taskData.parentId = :parentId and names.language = :language and names in elements( t.names) and ( subjects.language = :language and subjects in elements( t.subjects) or t.subjects.size = 0 ) and ( descriptions.language = :language and descriptions in elements( t.descriptions) or t.descriptions.size = 0 ) and t.taskData.status in ('Created', 'Ready', 'Reserved', 'InProgress', 'Suspended') and t.taskData.expirationTime is null]
          at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:54)
          at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:47)
          at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:82)
          at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:261)
          at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:185)
          at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
          at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
          at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
          at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:94)
          at org.hibernate.impl.SessionFactoryImpl.checkNamedQueries(SessionFactoryImpl.java:484)
          at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:394)
          at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1341)
          at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:867)
          at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:669)
          at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:126)
          at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:52)
          at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:34)
          at ProcessTest.createKnowledgeSession(ProcessTest.java:152)
          at ProcessTest.main(ProcessTest.java:111)
167  29/01 17:13:59,368[main] ERROR hibernate.impl.SessionFactoryImpl.<init>  - Error in named query: TasksAssignedAsTaskInitiator
org.hibernate.hql.ast.QuerySyntaxException: Unable to locate appropriate constructor on class [org.jbpm.task.query.TaskSummary] [select new org.jbpm.task.query.TaskSummary( t.id, t.taskData.processInstanceId, names.text, subjects.text, descriptions.text, t.taskData.status, t.priority, t.taskData.skipable, t.taskData.actualOwner, t.taskData.createdBy, t.taskData.createdOn, t.taskData.activationTime, t.taskData.expirationTime) from org.jbpm.task.Task t left join t.taskData.createdBy, org.jbpm.task.I18NText names, org.jbpm.task.I18NText subjects, org.jbpm.task.I18NText descriptions, org.jbpm.task.OrganizationalEntity taskInitiator where taskInitiator.id = :userId and taskInitiator = t.peopleAssignments.taskInitiator and names.language = :language and names in elements( t.names) and ( subjects.language = :language and subjects in elements( t.subjects) or t.subjects.size = 0 ) and ( descriptions.language = :language and descriptions in elements( t.descriptions) or t.descriptions.size = 0 ) and t.taskData.expirationTime is null]
          at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:54)
          at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:47)
          at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:82)
          at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:261)
          at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:185)
          at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
          at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
          at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
          at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:94)
          at org.hibernate.impl.SessionFactoryImpl.checkNamedQueries(SessionFactoryImpl.java:484)
          at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:394)
          at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1341)
          at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:867)
          at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:669)
          at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:126)
          at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:52)
          at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:34)
          at ProcessTest.createKnowledgeSession(ProcessTest.java:152)
          at ProcessTest.main(ProcessTest.java:111)
javax.persistence.PersistenceException: [PersistenceUnit: org.jbpm.persistence.jpa] Unable to build EntityManagerFactory
          at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:677)
          at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:126)
          at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:52)
          at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:34)
          at ProcessTest.createKnowledgeSession(ProcessTest.java:152)
          at ProcessTest.main(ProcessTest.java:111)
Caused by: org.hibernate.HibernateException: Errors in named queries: TasksAssignedAsPotentialOwner, UnescalatedDeadlines, TasksAssignedAsTaskStakeholder, TasksAssignedAsRecipient, TasksAssignedAsPotentialOwnerByGroup, TasksAssignedAsExcludedOwner, TasksAssignedAsBusinessAdministrator, SubTasksAssignedAsPotentialOwner, ProcessInstancesWaitingForEvent, TasksOwned, TasksAssignedAsPotentialOwnerWithGroups, GetSubTasksByParentTaskId, TasksAssignedAsTaskInitiator
          at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:407)
          at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1341)
          at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:867)
          at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:669)
          ... 5 more





h5.  

h5.
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/794823#794823]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20130129/88383b0f/attachment-0001.html

More information about the jboss-user mailing list