Error In Named Query Processinstanceswaitingforevent
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Drools flow persistence - Named query not found: ProcessInstancesWaitingForEvent up vote 0 down vote favorite I have a problem with drools flow persistence (MySQL), I get the following exception: 2011-04-15 14:38:27,244 INFO [STDOUT] (http-0.0.0.0-8000-5) Hibernate: insert into ProcessInstanceInfo (externalVariables, lastModificationDate, lastReadDate, processId, processInstanceByteArray, startDate, state, OPTLOCK) values (?, ?, ?, ?, ?, ?, ?, ?) 2011-04-15 14:38:27,244 INFO [STDOUT] (http-0.0.0.0-8000-5) Hello World 2011-04-15 14:38:27,244 ERROR [STDERR] (http-0.0.0.0-8000-5) java.lang.RuntimeException: Could not commit session 2011-04-15 14:38:27,244 ERROR [STDERR] (http-0.0.0.0-8000-5) at org.drools.persistence.session.SingleSessionCommandService.execute(SingleSessionCommandService.java:292) 2011-04-15 14:38:27,244 ERROR [STDERR] (http-0.0.0.0-8000-5) at org.drools.command.impl.CommandBasedStatefulKnowledgeSession.startProcess(CommandBasedStatefulKnowledgeSession.java:193) 2011-04-15 14:38:27,244 ERROR [STDERR] (http-0.0.0.0-8000-5) at org.drools.command.impl.CommandBasedStatefulKnowledgeSession.startProcess(CommandBasedStatefulKnowledgeSession.java:184) 2011-04-15 14:38:27,244 ERROR [STDERR] (http-0.0.0.0-8000-5) at com.servlet.Servlet.doGet(Servlet.java:101) 2011-04-15 14:38:27,244 ERROR [STDERR] (http-0.0.0.0-8000-5) at javax.servlet.http.HttpServlet.service(HttpServlet.java:734) 2011-04-15 14:38:27,244 ERROR [STDERR] (http-0.0.0.0-8000-5) at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) 2011-04-15 14:38:27,244 ERROR [STDERR] (http-0.0.0.0-8000-5) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:324) 2011-04-15 14:38:27,244 ERROR [STDERR] (http-0.0.0.0-8000-5) at org.apache.catalina.core.Ap
the discussion"Re: Error in named query: ProcessInstancesWaitingForEvent"To view the discussion, visit: https://community.jboss.org/message/752033#752033--------------------------------------------------------------what's your persistence.xml file configuration, maybe it is missing one of the mapping files that defines ProcessInstanceInfo entity? make sure that your persistance.xml contains this mapping file as http://stackoverflow.com/questions/5676940/drools-flow-persistence-named-query-not-found-processinstanceswaitingforevent well:
ProcessInstancesWaitingForEvent Newsgroups: gmane.comp.java.drools.user Date: error in Friday 24th September 2010 22:16:23 UTC (over 6 years ago) Hi, I'm using drools 5.1.1 with persistent error in named flow and Human Task. In orm.xml are queries Flow and HT. But among this error initializing JPA: ERROR 24-09 17:20:36,375 - Error in named query: ProcessInstancesWaitingForEvent org.hibernate.QueryException: cannot dereference scalar collection element: name [select processInstanceInfo.processInstanceId from org.drools.persistence.processinstance.ProcessInstanceInfo processInstanceInfo where :type in (processInstanceInfo.eventTypes.name<http://processinstanceinfo.eventtypes.name/> )] thanks CD: 14ms