[jboss-user] [jBPM] - Query task with variables

Thomas Victor do-not-reply at jboss.com
Wed May 19 13:18:58 EDT 2010


Thomas Victor [http://community.jboss.org/people/tvictor] replied to the discussion

"Query task with variables"

To view the discussion, visit: http://community.jboss.org/message/543909#543909

--------------------------------------------------------------
I tried another query 
entityManager.createQuery("SELECT task.execution.variables from org.jbpm.api.task.Task task where index(task.execution.variables[0])='invoiceId' and task.execution.variables[0].l=23").getResultList()

Which gives me no results. That is expected because there is no varialbe with value 23

But when I changed the value to 16 it is giving me the following error. The value 16 is actually existing in the database. Can anyone help to correct this query?

Thanks
Thomas


12:15:51,422 WARN  [JDBCExceptionReporter] SQL Error: 245, SQLState: S0001
12:15:51,422 ERROR [JDBCExceptionReporter] Conversion failed when converting the varchar value 'invoiceId' to data type int.
12:15:51,422 ERROR [STDERR] javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query
12:15:51,422 ERROR [STDERR]      at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:614)
12:15:51,422 ERROR [STDERR]      at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:76)
12:15:51,422 ERROR [STDERR]      at com.imagitek.prodagioap.workflow.TaskService.getGroupTasks(TaskService.java:72)
12:15:51,422 ERROR [STDERR]      at sun.reflect.GeneratedMethodAccessor601.invoke(Unknown Source)
12:15:51,422 ERROR [STDERR]      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
12:15:51,422 ERROR [STDERR]      at java.lang.reflect.Method.invoke(Method.java:597)
12:15:51,422 ERROR [STDERR]      at org.jboss.seam.util.Reflections.invoke(Reflections.java:22)
12:15:51,422 ERROR [STDERR]      at org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:32)
12:15:51,422 ERROR [STDERR]      at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56)
12:15:51,422 ERROR [STDERR]      at org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:28)
12:15:51,422 ERROR [STDERR]      at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
12:15:51,422 ERROR [STDERR]      at org.jboss.seam.core.BijectionInterceptor.aroundInvoke(BijectionInterceptor.java:77)
12:15:51,422 ERROR [STDERR]      at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
12:15:51,422 ERROR [STDERR]      at org.jboss.seam.bpm.BusinessProcessInterceptor.aroundInvoke(BusinessProcessInterceptor.java:51)
12:15:51,422 ERROR [STDERR]      at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
12:15:51,422 ERROR [STDERR]      at org.jboss.seam.transaction.TransactionInterceptor$1.work(TransactionInterceptor.java:97)
12:15:51,422 ERROR [STDERR]      at org.jboss.seam.util.Work.workInTransaction(Work.java:61)
12:15:51,422 ERROR [STDERR]      at org.jboss.seam.transaction.TransactionInterceptor.aroundInvoke(TransactionInterceptor.java:91)
12:15:51,422 ERROR [STDERR]      at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
12:15:51,422 ERROR [STDERR]      at org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:44)
12:15:51,422 ERROR [STDERR]      at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
12:15:51,422 ERROR [STDERR]      at org.jboss.seam.core.SynchronizationInterceptor.aroundInvoke(SynchronizationInterceptor.java:32)
12:15:51,422 ERROR [STDERR]      at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
12:15:51,422 ERROR [STDERR]      at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107)
12:15:51,422 ERROR [STDERR]      at org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:185)
12:15:51,422 ERROR [STDERR]      at org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:103)
12:15:51,422 ERROR [STDERR]      at com.imagitek.prodagioap.workflow.invoice.InvoiceTaskService_$_javassist_seam_13.getGroupTasks(InvoiceTaskService_$_javassist_seam_13.java)
12:15:51,422 ERROR [STDERR]      at sun.reflect.GeneratedMethodAccessor600.invoke(Unknown Source)
12:15:51,422 ERROR [STDERR]      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
12:15:51,422 ERROR [STDERR]      at java.lang.reflect.Method.invoke(Method.java:597)
12:15:51,422 ERROR [STDERR]      at javax.el.BeanELResolver.getValue(BeanELResolver.java:261)
12:15:51,422 ERROR [STDERR]      at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:143)
12:15:51,422 ERROR [STDERR]      at com.sun.faces.el.FacesCompositeELResolver.getValue(FacesCompositeELResolver.java:72)
12:15:51,422 ERROR [STDERR]      at org.jboss.el.parser.AstPropertySuffix.getValue(AstPropertySuffix.java:53)
12:15:51,422 ERROR [STDERR]      at org.jboss.el.parser.AstValue.getValue(AstValue.java:67)
12:15:51,422 ERROR [STDERR]      at org.jboss.el.parser.AstEmpty.getValue(AstEmpty.java:29)
12:15:51,422 ERROR [STDERR]      at org.jboss.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:186)
12:15:51,422 ERROR [STDERR]      at com.sun.facelets.el.TagValueExpression.getValue(TagValueExpression.java:71)
12:15:51,422 ERROR [STDERR]      at javax.faces.component.UIComponentBase.isRendered(UIComponentBase.java:390)
12:15:51,422 ERROR [STDERR]      at org.ajax4jsf.renderkit.RendererBase.renderChild(RendererBase.java:271)
12:15:51,422 ERROR [STDERR]      at org.ajax4jsf.renderkit.RendererBase.renderChildren(RendererBase.java:258)
12:15:51,422 ERROR [STDERR]      at org.richfaces.renderkit.html.PanelRenderer.doEncodeChildren(PanelRenderer.java:200)
12:15:51,422 ERROR [STDERR]      at org.richfaces.renderkit.html.PanelRenderer.doEncodeChildren(PanelRenderer.java:195)
12:15:51,422 ERROR [STDERR]      at org.ajax4jsf.renderkit.RendererBase.encodeChildren(RendererBase.java:120)
12:15:51,422 ERROR [STDERR]      at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:837)
12:15:51,422 ERROR [STDERR]      at javax.faces.component.UIComponent.encodeAll(UIComponent.java:930)
12:15:51,422 ERROR [STDERR]      at javax.faces.render.Renderer.encodeChildren(Renderer.java:148)
12:15:51,422 ERROR [STDERR]      at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:837)
12:15:51,422 ERROR [STDERR]      at javax.faces.component.UIComponent.encodeAll(UIComponent.java:930)
12:15:51,422 ERROR [STDERR]      at javax.faces.component.UIComponent.encodeAll(UIComponent.java:933)
12:15:51,422 ERROR [STDERR]      at com.sun.facelets.FaceletViewHandler.renderView(FaceletViewHandler.java:592)
12:15:51,422 ERROR [STDERR]      at org.ajax4jsf.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:100)
12:15:51,422 ERROR [STDERR]      at org.ajax4jsf.application.AjaxViewHandler.renderView(AjaxViewHandler.java:176)
12:15:51,422 ERROR [STDERR]      at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:110)
12:15:51,422 ERROR [STDERR]      at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100)
12:15:51,422 ERROR [STDERR]      at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:139)
12:15:51,422 ERROR [STDERR]      at javax.faces.webapp.FacesServlet.service(FacesServlet.java:266)
12:15:51,422 ERROR [STDERR]      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
12:15:51,422 ERROR [STDERR]      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
12:15:51,422 ERROR [STDERR]      at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:83)
12:15:51,422 ERROR [STDERR]      at org.jboss.seam.web.IdentityFilter.doFilter(IdentityFilter.java:40)
12:15:51,422 ERROR [STDERR]      at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
12:15:51,422 ERROR [STDERR]      at org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:90)
12:15:51,422 ERROR [STDERR]      at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
12:15:51,422 ERROR [STDERR]      at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:64)
12:15:51,422 ERROR [STDERR]      at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
12:15:51,422 ERROR [STDERR]      at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:45)
12:15:51,422 ERROR [STDERR]      at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
12:15:51,422 ERROR [STDERR]      at org.jboss.seam.web.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:42)
12:15:51,422 ERROR [STDERR]      at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
12:15:51,422 ERROR [STDERR]      at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:206)
12:15:51,422 ERROR [STDERR]      at org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:290)
12:15:51,422 ERROR [STDERR]      at org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:388)
12:15:51,422 ERROR [STDERR]      at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:515)
12:15:51,422 ERROR [STDERR]      at org.jboss.seam.web.Ajax4jsfFilter.doFilter(Ajax4jsfFilter.java:56)
12:15:51,422 ERROR [STDERR]      at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
12:15:51,422 ERROR [STDERR]      at org.jboss.seam.web.LoggingFilter.doFilter(LoggingFilter.java:60)
12:15:51,422 ERROR [STDERR]      at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
12:15:51,422 ERROR [STDERR]      at org.jboss.seam.web.HotDeployFilter.doFilter(HotDeployFilter.java:53)
12:15:51,422 ERROR [STDERR]      at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
12:15:51,422 ERROR [STDERR]      at org.jboss.seam.servlet.SeamFilter.doFilter(SeamFilter.java:158)
12:15:51,422 ERROR [STDERR]      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
12:15:51,422 ERROR [STDERR]      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
12:15:51,422 ERROR [STDERR]      at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
12:15:51,422 ERROR [STDERR]      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
12:15:51,422 ERROR [STDERR]      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
12:15:51,422 ERROR [STDERR]      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
12:15:51,422 ERROR [STDERR]      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
12:15:51,422 ERROR [STDERR]      at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)
12:15:51,422 ERROR [STDERR]      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
12:15:51,422 ERROR [STDERR]      at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)
12:15:51,422 ERROR [STDERR]      at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
12:15:51,422 ERROR [STDERR]      at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
12:15:51,422 ERROR [STDERR]      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
12:15:51,422 ERROR [STDERR]      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
12:15:51,422 ERROR [STDERR]      at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
12:15:51,422 ERROR [STDERR]      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
12:15:51,422 ERROR [STDERR]      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
12:15:51,422 ERROR [STDERR]      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
12:15:51,422 ERROR [STDERR]      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)
12:15:51,422 ERROR [STDERR]      at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
12:15:51,422 ERROR [STDERR]      at java.lang.Thread.run(Thread.java:619)
12:15:51,422 ERROR [STDERR] Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
12:15:51,422 ERROR [STDERR]      at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)
12:15:51,422 ERROR [STDERR]      at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
12:15:51,422 ERROR [STDERR]      at org.hibernate.loader.Loader.doList(Loader.java:2235)
12:15:51,422 ERROR [STDERR]      at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129)
12:15:51,422 ERROR [STDERR]      at org.hibernate.loader.Loader.list(Loader.java:2124)
12:15:51,422 ERROR [STDERR]      at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)
12:15:51,422 ERROR [STDERR]      at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
12:15:51,422 ERROR [STDERR]      at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
12:15:51,422 ERROR [STDERR]      at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1149)
12:15:51,422 ERROR [STDERR]      at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
12:15:51,422 ERROR [STDERR]      at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:67)
12:15:51,422 ERROR [STDERR]      ... 100 more
12:15:51,422 ERROR [STDERR] Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Conversion failed when converting the varchar value 'invoiceId' to data type int.
12:15:51,422 ERROR [STDERR]      at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)
12:15:51,422 ERROR [STDERR]      at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer.nextRow(SQLServerResultSet.java:4700)
12:15:51,422 ERROR [STDERR]      at com.microsoft.sqlserver.jdbc.SQLServerResultSet.fetchBufferNext(SQLServerResultSet.java:1683)
12:15:51,422 ERROR [STDERR]      at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:956)
12:15:51,422 ERROR [STDERR]      at org.jboss.resource.adapter.jdbc.WrappedResultSet.next(WrappedResultSet.java:1196)
12:15:51,422 ERROR [STDERR]      at org.hibernate.loader.Loader.doQuery(Loader.java:720)
12:15:51,422 ERROR [STDERR]      at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
12:15:51,422 ERROR [STDERR]      at org.hibernate.loader.Loader.doList(Loader.java:2232)
12:15:51,422 ERROR [STDERR]      ... 108 more

--------------------------------------------------------------

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

Start a new discussion in jBPM at Community
[http://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/20100519/1c0bfb49/attachment-0001.html 


More information about the jboss-user mailing list