Attachment 904621 Details for Bug 1105868 – mysql stacktrace

mysql stacktrace

file_1105868.txt (text/plain), 14.69 KB, created by Radovan Synek on 2014-06-09 12:05:41 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Radovan Synek

Created: 2014-06-09 12:05:41 UTC

Size: 14.69 KB

patch

obsolete

>[6/9/14 10:49:11:092 CEST] 000000af ProcessReques W org.kie.remote.services.cdi.ProcessRequestBean processCommand Unable to execute GetTaskAssignedAsPotentialOwnerCommand/0
>                                 javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
>	at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387)
>	at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310)
>	at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:273)
>	at org.jbpm.services.task.persistence.JPATaskPersistenceContext.queryStringWithParameters(JPATaskPersistenceContext.java:475)
>	at org.jbpm.services.task.persistence.JPATaskPersistenceContext.queryWithParametersInTransaction(JPATaskPersistenceContext.java:344)
>	at org.jbpm.services.task.impl.TaskQueryServiceImpl.getTasksAssignedAsPotentialOwner(TaskQueryServiceImpl.java:80)
>	at org.jbpm.services.task.commands.GetTaskAssignedAsPotentialOwnerCommand.execute(GetTaskAssignedAsPotentialOwnerCommand.java:76)
>	at org.jbpm.services.task.commands.GetTaskAssignedAsPotentialOwnerCommand.execute(GetTaskAssignedAsPotentialOwnerCommand.java:15)
>	at org.jbpm.services.task.commands.TaskCommandExecutorImpl$SelfExecutionCommandService.execute(TaskCommandExecutorImpl.java:65)
>	at org.drools.core.command.impl.AbstractInterceptor.executeNext(AbstractInterceptor.java:41)
>	at org.jbpm.services.task.persistence.TaskTransactionInterceptor.execute(TaskTransactionInterceptor.java:54)
>	at org.jbpm.services.task.commands.TaskCommandExecutorImpl.execute(TaskCommandExecutorImpl.java:40)
>	at org.jbpm.services.task.impl.command.CommandBasedTaskService.execute(CommandBasedTaskService.java:128)
>	at org.kie.remote.services.cdi.ProcessRequestBean.doTaskOperation(ProcessRequestBean.java:249)
>	at org.kie.remote.services.cdi.ProcessRequestBean.processCommand(ProcessRequestBean.java:121)
>	at sun.reflect.GeneratedMethodAccessor174.invoke(Unknown Source)
>	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
>	at java.lang.reflect.Method.invoke(Method.java:611)
>	at org.apache.webbeans.intercept.InterceptorHandler.invoke(InterceptorHandler.java:297)
>	at org.apache.webbeans.intercept.NormalScopedBeanInterceptorHandler.invoke(NormalScopedBeanInterceptorHandler.java:98)
>	at org.kie.remote.services.cdi.ProcessRequestBean_$$_javassist_136.processCommand(ProcessRequestBean_$$_javassist_136.java)
>	at org.kie.remote.services.rest.ResourceBase.restProcessJaxbCommandsRequest(ResourceBase.java:69)
>	at org.kie.remote.services.rest.RuntimeResource.execute(RuntimeResource.java:95)
>	at sun.reflect.GeneratedMethodAccessor143.invoke(Unknown Source)
>	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
>	at java.lang.reflect.Method.invoke(Method.java:611)
>	at org.apache.webbeans.intercept.InterceptorHandler.invoke(InterceptorHandler.java:297)
>	at org.apache.webbeans.intercept.NormalScopedBeanInterceptorHandler.invoke(NormalScopedBeanInterceptorHandler.java:98)
>	at org.kie.remote.services.rest.RuntimeResource_$$_javassist_135.execute(RuntimeResource_$$_javassist_135.java)
>	at sun.reflect.GeneratedMethodAccessor143.invoke(Unknown Source)
>	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
>	at java.lang.reflect.Method.invoke(Method.java:611)
>	at org.apache.wink.server.internal.handlers.InvokeMethodHandler.handleRequest(InvokeMethodHandler.java:63)
>	at org.apache.wink.server.handlers.AbstractHandler.handleRequest(AbstractHandler.java:33)
>	at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:26)
>	at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:22)
>	at org.apache.wink.server.handlers.AbstractHandlersChain.doChain(AbstractHandlersChain.java:75)
>	at org.apache.wink.server.internal.handlers.CreateInvocationParametersHandler.handleRequest(CreateInvocationParametersHandler.java:54)
>	at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:26)
>	at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:22)
>	at org.apache.wink.server.handlers.AbstractHandlersChain.doChain(AbstractHandlersChain.java:75)
>	at org.apache.wink.server.handlers.AbstractHandler.handleRequest(AbstractHandler.java:34)
>	at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:26)
>	at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:22)
>	at org.apache.wink.server.handlers.AbstractHandlersChain.doChain(AbstractHandlersChain.java:75)
>	at org.apache.wink.server.internal.handlers.FindResourceMethodHandler.handleSubResourceMethod(FindResourceMethodHandler.java:188)
>	at org.apache.wink.server.internal.handlers.FindResourceMethodHandler.handleRequest(FindResourceMethodHandler.java:110)
>	at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:26)
>	at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:22)
>	at org.apache.wink.server.handlers.AbstractHandlersChain.doChain(AbstractHandlersChain.java:75)
>	at org.apache.wink.server.internal.handlers.FindRootResourceHandler.handleRequest(FindRootResourceHandler.java:95)
>	at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:26)
>	at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:22)
>	at org.apache.wink.server.handlers.AbstractHandlersChain.doChain(AbstractHandlersChain.java:75)
>	at org.apache.wink.server.internal.handlers.HeadMethodHandler.handleRequest(HeadMethodHandler.java:53)
>	at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:26)
>	at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:22)
>	at org.apache.wink.server.handlers.AbstractHandlersChain.doChain(AbstractHandlersChain.java:75)
>	at org.apache.wink.server.internal.handlers.OptionsMethodWADLHandler.handleRequest(OptionsMethodWADLHandler.java:51)
>	at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:26)
>	at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:22)
>	at org.apache.wink.server.handlers.AbstractHandlersChain.doChain(AbstractHandlersChain.java:75)
>	at org.apache.wink.server.internal.handlers.SearchResultHandler.handleRequest(SearchResultHandler.java:33)
>	at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:26)
>	at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:22)
>	at org.apache.wink.server.handlers.AbstractHandlersChain.doChain(AbstractHandlersChain.java:75)
>	at org.apache.wink.server.internal.log.ResourceInvocation.handleRequest(ResourceInvocation.java:92)
>	at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:26)
>	at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:22)
>	at org.apache.wink.server.handlers.AbstractHandlersChain.doChain(AbstractHandlersChain.java:75)
>	at org.apache.wink.server.internal.log.Requests.handleRequest(Requests.java:76)
>	at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:26)
>	at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:22)
>	at org.apache.wink.server.handlers.AbstractHandlersChain.doChain(AbstractHandlersChain.java:75)
>	at org.apache.wink.server.handlers.AbstractHandlersChain.run(AbstractHandlersChain.java:60)
>	at org.apache.wink.server.internal.RequestProcessor.handleRequestWithoutFaultBarrier(RequestProcessor.java:207)
>	at org.apache.wink.server.internal.RequestProcessor.handleRequest(RequestProcessor.java:154)
>	at org.apache.wink.server.internal.servlet.RestServlet.service(RestServlet.java:124)
>	at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
>	at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1230)
>	at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:779)
>	at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:478)
>	at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
>	at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:136)
>	at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:97)
>	at org.jboss.solder.servlet.exception.CatchExceptionFilter.doFilter(CatchExceptionFilter.java:62)
>	at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)
>	at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)
>	at org.jboss.solder.servlet.event.ServletEventBridgeFilter.doFilter(ServletEventBridgeFilter.java:74)
>	at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)
>	at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)
>	at org.kie.remote.services.rest.jaxb.DynamicJaxbContextFilter.doFilter(DynamicJaxbContextFilter.java:29)
>	at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)
>	at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)
>	at org.jbpm.designer.web.filter.impl.PluggableFilter.doFilter(PluggableFilter.java:70)
>	at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)
>	at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)
>	at org.uberfire.security.server.UberFireSecurityFilter.doFilter(UberFireSecurityFilter.java:266)
>	at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)
>	at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)
>	at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:960)
>	at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1064)
>	at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:87)
>	at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:914)
>	at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1662)
>	at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:200)
>	at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:459)
>	at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:526)
>	at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:312)
>	at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:88)
>	at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175)
>	at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
>	at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
>	at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
>	at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
>	at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
>	at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
>	at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1864)
>Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
>	at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:82)
>	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
>	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
>	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
>	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:61)
>	at org.hibernate.loader.Loader.getResultSet(Loader.java:2031)
>	at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1832)
>	at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1811)
>	at org.hibernate.loader.Loader.doQuery(Loader.java:899)
>	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:341)
>	at org.hibernate.loader.Loader.doList(Loader.java:2516)
>	at org.hibernate.loader.Loader.doList(Loader.java:2502)
>	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2332)
>	at org.hibernate.loader.Loader.list(Loader.java:2327)
>	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:490)
>	at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:355)
>	at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:195)
>	at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1269)
>	at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)
>	at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:264)
>	... 115 more
>Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) and (organizati6_.id in (select potentialo7_.entity_id from PeopleAssignments' at line 1
>	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
>	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:56)
>	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:39)
>	at java.lang.reflect.Constructor.newInstance(Constructor.java:527)
>	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
>	at com.mysql.jdbc.Util.getInstance(Util.java:386)
>	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053)
>	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
>	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
>	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
>	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
>	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2794)
>	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
>	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2322)
>	at com.mysql.jdbc.jdbc2.optional.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:846)
>	at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteQuery(WSJdbcPreparedStatement.java:1112)
>	at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery(WSJdbcPreparedStatement.java:714)
>	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:56)
>	... 130 more

Actions: View

Attachments on bug 1105868: 903274 | 904621