0 Replies Latest reply on Aug 16, 2016 11:31 AM by mariaprabudass Edwin

    Error performing load command: org.hibernate.exception.GenericJDBCException

    mariaprabudass Edwin Newbie

      Hi Dev,

       

      In JBoss have found an exception which relates to JDBC Exception. Only in production environment can we reproduce this error not in development. We confused whether it relates to timeout of jboss connection or something else. Your help is much appreciated. Given below the error message:

       

      Stacktrace:-

      INFO  [org.hibernate.event.def.DefaultLoadEventListener] (http--192.168.0.175-8080-78) Error performing load command: org.hibernate.exception.GenericJDBCException: could not load an entity: [org.jbpm.task.Task#1351234]

      at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140) [hibernate-core-3.6.9.Final.jar:]

      at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128) [hibernate-core-3.6.9.Final.jar:]

      at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) [hibernate-core-3.6.9.Final.jar:]

      at org.hibernate.loader.Loader.loadEntity(Loader.java:2041) [hibernate-core-3.6.9.Final.jar:]

      at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:86) [hibernate-core-3.6.9.Final.jar:]

      at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:76) [hibernate-core-3.6.9.Final.jar:]

      at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3293) [hibernate-core-3.6.9.Final.jar:]

      at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:496) [hibernate-core-3.6.9.Final.jar:]

      at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:477) [hibernate-core-3.6.9.Final.jar:]

      at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:227) [hibernate-core-3.6.9.Final.jar:]

      at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:285) [hibernate-core-3.6.9.Final.jar:]

      at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:152) [hibernate-core-3.6.9.Final.jar:]

      at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:1090) [hibernate-core-3.6.9.Final.jar:]

      at org.hibernate.impl.SessionImpl.get(SessionImpl.java:1005) [hibernate-core-3.6.9.Final.jar:]

      at org.hibernate.impl.SessionImpl.get(SessionImpl.java:998) [hibernate-core-3.6.9.Final.jar:]

      at org.hibernate.ejb.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:779) [hibernate-entitymanager-3.6.9.Final.jar:]

      at org.hibernate.ejb.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:754) [hibernate-entitymanager-3.6.9.Final.jar:]

      at org.jbpm.task.service.persistence.TaskPersistenceManager.findEntity(TaskPersistenceManager.java:212) [jbpm-human-task-core-5.4.0.Final.jar:]

      at org.jbpm.task.service.TaskServiceSession$15.doOperation(TaskServiceSession.java:1071) [jbpm-human-task-core-5.4.0.Final.jar:]

      at org.jbpm.task.service.TaskServiceSession.doOperationInTransaction(TaskServiceSession.java:1115) [jbpm-human-task-core-5.4.0.Final.jar:]

      at org.jbpm.task.service.TaskServiceSession.getEntity(TaskServiceSession.java:1069) [jbpm-human-task-core-5.4.0.Final.jar:]

      at org.jbpm.task.service.TaskServiceSession.getTask(TaskServiceSession.java:605) [jbpm-human-task-core-5.4.0.Final.jar:]

      at org.jbpm.task.service.local.LocalTaskService.getTask(LocalTaskService.java:157) [jbpm-human-task-core-5.4.0.Final.jar:]

      at com.workflow.engine.BaseTaskManagement.getTask(BaseTaskManagement.java:718) [APICore-5.2.jar:]

      at com.workflow.engine.TaskManagementImpl.getTask(TaskManagementImpl.java:203) [classes:]

      at com.workflow.engine.TaskManagementImpl$$FastClassByCGLIB$$ade224e9.invoke() [cglib-2.2.jar:]

      at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191) [cglib-2.2.jar:]

      at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689) [spring-aop-3.1.1.RELEASE.jar:]

      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) [spring-aop-3.1.1.RELEASE.jar:]

      at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90) [spring-aop-3.1.1.RELEASE.jar:]

      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [spring-aop-3.1.1.RELEASE.jar:]

      at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622) [spring-aop-3.1.1.RELEASE.jar:]

      at com.workflow.engine.TaskManagementImpl$$EnhancerByCGLIB$$67bea14e.getTask() [cglib-2.2.jar:]

      at com.workflow.services.TaskServiceImpl.produceMessage(TaskServiceImpl.java:898) [classes:]

      at com.workflow.services.TaskServiceImpl$$FastClassByCGLIB$$89eef3ab.invoke() [cglib-2.2.jar:]

      at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191) [cglib-2.2.jar:]

      at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689) [spring-aop-3.1.1.RELEASE.jar:]

      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) [spring-aop-3.1.1.RELEASE.jar:]

      at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90) [spring-aop-3.1.1.RELEASE.jar:]

      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [spring-aop-3.1.1.RELEASE.jar:]

      at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622) [spring-aop-3.1.1.RELEASE.jar:]

      at com.workflow.services.TaskServiceImpl$$EnhancerByCGLIB$$68451db7.produceMessage() [cglib-2.2.jar:]

      at com.aspects.TaskNotificationAspect.notifyCompleteTask(TaskNotificationAspect.java:156) [classes:]

      at sun.reflect.GeneratedMethodAccessor4011.invoke(Unknown Source) [:1.7.0_40]

      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [:1.7.0_40]

      at java.lang.reflect.Method.invoke(Method.java:606) [:1.7.0_40]

      at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621) [spring-aop-3.1.1.RELEASE.jar:]

      at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(Abstracxtract(VarcharTypeDescriptor.java:61) [hibernate-core-3.6.9.Final.jar:]

      at org.hibernate.type.descriptor.sql.BasicExtractor.extract(BasicExtractor.java:64) [hibernate-core-3.6.9.Final.jar:]

      at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:254) [hibernate-core-3.6.9.Final.jar:]

      at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:250) [hibernate-core-3.6.9.Final.jar:]

      at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:230) [hibernate-core-3.6.9.Final.jar:]

      at org.hibernate.type.AbstractStandardBasicType.hydrate(AbstractStandardBasicType.java:331) [hibernate-core-3.6.9.Final.jar:]

      at org.hibernate.loader.Loader.extractKeysFromResultSet(Loader.java:668) [hibernate-core-3.6.9.Final.jar:]

      at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:606) [hibernate-core-3.6.9.Final.jar:]

      at org.hibernate.loader.Loader.doQuery(Loader.java:829) [hibernate-core-3.6.9.Final.jar:]

      at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274) [hibernate-core-3.6.9.Final.jar:]

      at org.hibernate.loader.Loader.loadEntity(Loader.java:2037) [hibernate-core-3.6.9.Final.jar:]tAspectJAdvice.java:610) [spring-aop-3.1.1.RELEASE.jar:]

      at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:65) [spring-aop-3.1.1.RELEASE.jar:]

      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [spring-aop-3.1.1.RELEASE.jar:]

      at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) [spring-tx-3.1.1.RELEASE.jar:]

      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [spring-aop-3.1.1.RELEASE.jar:]

      at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90) [spring-aop-3.1.1.RELEASE.jar:]

      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [spring-aop-3.1.1.RELEASE.jar:]

      at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622) [spring-aop-3.1.1.RELEASE.jar:]

      at com.workflow.services.TaskServiceImpl$$EnhancerByCGLIB$$68451db7.completeTask() [cglib-2.2.jar:]

      at com.workflow.web.controllers.TasksController.completeTask(TasksController.java:115) [classes:]

      at sun.reflect.GeneratedMethodAccessor3877.invoke(Unknown Source) [:1.7.0_40]

      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [:1.7.0_40]

      at java.lang.reflect.Method.invoke(Method.java:606) [:1.7.0_40]

      at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:213) [spring-web-3.1.1.RELEASE.jar:]

      at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:126) [spring-web-3.1.1.RELEASE.jar:]

      at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:96) [spring-webmvc-3.1.1.RELEASE.jar:]

      at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:617) [spring-webmvc-3.1.1.RELEASE.jar:]

      at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:578) [spring-webmvc-3.1.1.RELEASE.jar:]

      at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80) [spring-webmvc-3.1.1.RELEASE.jar:]

      at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:923) [spring-webmvc-3.1.1.RELEASE.jar:]

      at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852) [spring-webmvc-3.1.1.RELEASE.jar:]

      at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882) [spring-webmvc-3.1.1.RELEASE.jar:]

      at org.springframework.web.servlet.FrameworkServlet.doPut(FrameworkServlet.java:800) [spring-webmvc-3.1.1.RELEASE.jar:]

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:757) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) [jbossweb-7.0.1.Final.jar:7.0.2.Final]

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.1.Final.jar:7.0.2.Final]

      at com.thetransactioncompany.cors.CORSFilter.doFilter(Unknown Source) [cors-filter-1.2.1.jar:]

      at com.thetransactioncompany.cors.CORSFilter.doFilter(Unknown Source) [cors-filter-1.2.1.jar:]

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) [jbossweb-7.0.1.Final.jar:7.0.2.Final]

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.1.Final.jar:7.0.2.Final]

      at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198) [spring-orm-3.1.1.RELEASE.jar:]

      at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) [spring-web-3.1.1.RELEASE.jar:]

      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) [jbossweb-7.0.1.Final.jar:7.0.2.Final]

      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.1.Final.jar:7.0.2.Final]

      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [jbossweb-7.0.1.Final.jar:7.0.2.Final]

      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.1.Final.jar:7.0.2.Final]

      at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:139) [jboss-as-web-7.0.2.Final.jar:7.0.2.Final]

      at org.jboss.as.web.NamingValve.invoke(NamingValve.java:57) [jboss-as-web-7.0.2.Final.jar:7.0.2.Final]

      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:154) [jbossweb-7.0.1.Final.jar:7.0.2.Final]

      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.1.Final.jar:7.0.2.Final]

      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.1.Final.jar:7.0.2.Final]

      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:362) [jbossweb-7.0.1.Final.jar:7.0.2.Final]

      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [jbossweb-7.0.1.Final.jar:7.0.2.Final]

      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:667) [jbossweb-7.0.1.Final.jar:7.0.2.Final]

      at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:952) [jbossweb-7.0.1.Final.jar:7.0.2.Final]

      at java.lang.Thread.run(Thread.java:724) [:1.7.0_40]

      Caused by: java.sql.SQLException: The result set is closed.

      at org.jboss.jca.adapters.jdbc.WrappedResultSet.checkState(WrappedResultSet.java:4059)

      at org.jboss.jca.adapters.jdbc.WrappedResultSet.getString(WrappedResultSet.java:1351)

      at org.hibernate.type.descriptor.sql.VarcharTypeDescriptor$2.doExtract(VarcharTypeDescriptor.java:61) [hibernate-core-3.6.9.Final.jar:]

      at org.hibernate.type.descriptor.sql.BasicExtractor.extract(BasicExtractor.java:64) [hibernate-core-3.6.9.Final.jar:]

      at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:254) [hibernate-core-3.6.9.Final.jar:]

      at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:250) [hibernate-core-3.6.9.Final.jar:]

      at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:230) [hibernate-core-3.6.9.Final.jar:]

      at org.hibernate.type.AbstractStandardBasicType.hydrate(AbstractStandardBasicType.java:331) [hibernate-core-3.6.9.Final.jar:]

      at org.hibernate.loader.Loader.extractKeysFromResultSet(Loader.java:668) [hibernate-core-3.6.9.Final.jar:]

      at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:606) [hibernate-core-3.6.9.Final.jar:]

      at org.hibernate.loader.Loader.doQuery(Loader.java:829) [hibernate-core-3.6.9.Final.jar:]

      at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274) [hibernate-core-3.6.9.Final.jar:]

      at org.hibernate.loader.Loader.loadEntity(Loader.java:2037) [hibernate-core-3.6.9.Final.jar:]