org.hibernate.exception.DataException: Could not execute JDBC batch update

Stack Overflow | Geo Thomas | 5 months ago
  1. 0

    How to find the class that throws an exception in Java using Eclipse

    Stack Overflow | 5 months ago | Geo Thomas
    org.hibernate.exception.DataException: Could not execute JDBC batch update
  2. 0

    how do I fix Could not synchronize database state with session error while trying to get dat afrom database

    Stack Overflow | 2 years ago
    org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update
  3. 0

    How to save a string containing single quotes to a text column in PostgreSQL

    Stack Overflow | 1 year ago | Geo Thomas
    org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.postgresql.jdbc2.PBatchUpdateException

      Batch entry 0 update public.wc_content_definition set web_content_desc= was aborted. Call getNextException() to see the cause.

      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch()
    2. PostgreSQL JDBC Driver
      AbstractJdbc2Statement.executeBatch
      1. org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:107)[postgresql-7.4.1-jdbc3.jar:na]
      1 frame
    3. Hibernate
      ActionQueue.executeActions
      1. org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)[hibernate-core-3.5.1-Final.jar:3.5.1-Final]
      2. org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)[hibernate-core-3.5.1-Final.jar:3.5.1-Final]
      3. org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)[hibernate-core-3.5.1-Final.jar:3.5.1-Final]
      4. org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:180)[hibernate-core-3.5.1-Final.jar:3.5.1-Final]
      4 frames
    4. Hibernate
      QueryImpl.list
      1. org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)[hibernate-core-3.5.1-Final.jar:3.5.1-Final]
      2. org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:64)[hibernate-core-3.5.1-Final.jar:3.5.1-Final]
      3. org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1175)[hibernate-core-3.5.1-Final.jar:3.5.1-Final]
      4. org.hibernate.impl.SessionImpl.list(SessionImpl.java:1251)[hibernate-core-3.5.1-Final.jar:3.5.1-Final]
      5. org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)[hibernate-core-3.5.1-Final.jar:3.5.1-Final]
      5 frames
    5. com.smartwcm.core
      WebContentDefinitionServiceImpl.saveOrUpdateWebContentDefinition
      1. com.smartwcm.core.userprofile.dao.impl.UserProfileDaoImpl.getUserProfile(UserProfileDaoImpl.java:40)[UserProfileDaoImpl.class:na]
      2. com.smartwcm.core.wc.service.impl.WebContentDefinitionServiceImpl.setViewUrlForProfile(WebContentDefinitionServiceImpl.java:1098)[WebContentDefinitionServiceImpl.class:na]
      3. com.smartwcm.core.wc.service.impl.WebContentDefinitionServiceImpl.setWebcontentUrls(WebContentDefinitionServiceImpl.java:1086)[WebContentDefinitionServiceImpl.class:na]
      4. com.smartwcm.core.wc.service.impl.WebContentDefinitionServiceImpl.saveOrUpdateWebContentDefinition(WebContentDefinitionServiceImpl.java:222)[WebContentDefinitionServiceImpl.class:na]
      4 frames
    6. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[na:1.8.0_31]
      2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)[na:1.8.0_31]
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)[na:1.8.0_31]
      4. java.lang.reflect.Method.invoke(Unknown Source)[na:1.8.0_31]
      4 frames
    7. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)[spring-aop-4.1.4.RELEASE.jar:4.1.4.RELEASE]
      2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)[spring-aop-4.1.4.RELEASE.jar:4.1.4.RELEASE]
      3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)[spring-aop-4.1.4.RELEASE.jar:4.1.4.RELEASE]
      3 frames
    8. Spring Tx
      TransactionInterceptor.invoke
      1. org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)[spring-tx-4.1.4.RELEASE.jar:4.1.4.RELEASE]
      2. org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)[spring-tx-4.1.4.RELEASE.jar:4.1.4.RELEASE]
      3. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)[spring-tx-4.1.4.RELEASE.jar:4.1.4.RELEASE]
      3 frames
    9. Spring AOP
      JdkDynamicAopProxy.invoke
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)[spring-aop-4.1.4.RELEASE.jar:4.1.4.RELEASE]
      2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)[spring-aop-4.1.4.RELEASE.jar:4.1.4.RELEASE]
      2 frames
    10. com.sun.proxy
      $Proxy32.saveOrUpdateWebContentDefinition
      1. com.sun.proxy.$Proxy32.saveOrUpdateWebContentDefinition(Unknown Source)[na:na]
      1 frame
    11. com.smartwcm.core
      UserCollectionServiceImpl.addUsersToUserCollection
      1. com.smartwcm.core.usercollection.service.impl.UserCollectionServiceImpl.saveDefaultUserProfiles(UserCollectionServiceImpl.java:239)[UserCollectionServiceImpl.class:na]
      2. com.smartwcm.core.usercollection.service.impl.UserCollectionServiceImpl.addUsersToUserCollection(UserCollectionServiceImpl.java:147)[UserCollectionServiceImpl.class:na]
      2 frames
    12. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[na:1.8.0_31]
      2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)[na:1.8.0_31]
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)[na:1.8.0_31]
      4. java.lang.reflect.Method.invoke(Unknown Source)[na:1.8.0_31]
      4 frames
    13. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)[spring-aop-4.1.4.RELEASE.jar:4.1.4.RELEASE]
      2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)[spring-aop-4.1.4.RELEASE.jar:4.1.4.RELEASE]
      3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)[spring-aop-4.1.4.RELEASE.jar:4.1.4.RELEASE]
      3 frames
    14. Spring Tx
      TransactionInterceptor.invoke
      1. org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)[spring-tx-4.1.4.RELEASE.jar:4.1.4.RELEASE]
      2. org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)[spring-tx-4.1.4.RELEASE.jar:4.1.4.RELEASE]
      3. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)[spring-tx-4.1.4.RELEASE.jar:4.1.4.RELEASE]
      3 frames
    15. Spring AOP
      JdkDynamicAopProxy.invoke
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)[spring-aop-4.1.4.RELEASE.jar:4.1.4.RELEASE]
      2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)[spring-aop-4.1.4.RELEASE.jar:4.1.4.RELEASE]
      2 frames
    16. com.sun.proxy
      $Proxy44.addUsersToUserCollection
      1. com.sun.proxy.$Proxy44.addUsersToUserCollection(Unknown Source)[na:na]
      1 frame
    17. com.smartwcm.admin
      UserCollectionController.addUsersToCollection
      1. com.smartwcm.admin.usercollection.controller.UserCollectionController.addUsersToCollection(UserCollectionController.java:481)[UserCollectionController.class:na]
      1 frame
    18. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[na:1.8.0_31]
      2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)[na:1.8.0_31]
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)[na:1.8.0_31]
      4. java.lang.reflect.Method.invoke(Unknown Source)[na:1.8.0_31]
      4 frames
    19. Spring
      InvocableHandlerMethod.invokeForRequest
      1. org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)[spring-web-4.1.4.RELEASE.jar:4.1.4.RELEASE]
      2. org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)[spring-web-4.1.4.RELEASE.jar:4.1.4.RELEASE]
      2 frames
    20. Spring MVC
      FrameworkServlet.doPost
      1. org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)[spring-webmvc-4.1.4.RELEASE.jar:4.1.4.RELEASE]
      2. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:777)[spring-webmvc-4.1.4.RELEASE.jar:4.1.4.RELEASE]
      3. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:706)[spring-webmvc-4.1.4.RELEASE.jar:4.1.4.RELEASE]
      4. org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)[spring-webmvc-4.1.4.RELEASE.jar:4.1.4.RELEASE]
      5. org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:943)[spring-webmvc-4.1.4.RELEASE.jar:4.1.4.RELEASE]
      6. org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:877)[spring-webmvc-4.1.4.RELEASE.jar:4.1.4.RELEASE]
      7. org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:966)[spring-webmvc-4.1.4.RELEASE.jar:4.1.4.RELEASE]
      8. org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:868)[spring-webmvc-4.1.4.RELEASE.jar:4.1.4.RELEASE]
      8 frames
    21. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:644)[servlet-api.jar:na]
      1 frame
    22. Spring MVC
      FrameworkServlet.service
      1. org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842)[spring-webmvc-4.1.4.RELEASE.jar:4.1.4.RELEASE]
      1 frame
    23. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:725)[servlet-api.jar:na]
      1 frame
    24. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)[catalina.jar:8.0.18]
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)[catalina.jar:8.0.18]
      2 frames
    25. Tomcat WS
      WsFilter.doFilter
      1. org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)[tomcat-websocket.jar:8.0.18]
      1 frame
    26. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)[catalina.jar:8.0.18]
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)[catalina.jar:8.0.18]
      2 frames
    27. Spring Security
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
      2. org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
      3. org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
      4. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
      5. org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
      6. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
      7. org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
      8. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
      9. org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
      10. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
      11. org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:154)[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
      12. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
      13. org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
      14. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
      15. org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
      16. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
      17. org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199)[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
      18. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
      19. org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:110)[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
      20. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
      20 frames
    28. org.springframework.security
      WebAsyncManagerIntegrationFilter.doFilterInternal
      1. org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:50)[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
      1 frame
    29. Spring
      OncePerRequestFilter.doFilter
      1. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)[spring-web-4.1.4.RELEASE.jar:4.1.4.RELEASE]
      1 frame
    30. Spring Security
      FilterChainProxy.doFilter
      1. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
      2. org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
      3. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
      4. org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
      5. org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)[spring-security-web-3.2.5.RELEASE.jar:3.2.5.RELEASE]
      5 frames
    31. Spring
      DelegatingFilterProxy.doFilter
      1. org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:344)[spring-web-4.1.4.RELEASE.jar:4.1.4.RELEASE]
      2. org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:261)[spring-web-4.1.4.RELEASE.jar:4.1.4.RELEASE]
      2 frames
    32. Glassfish Core
      CoyoteAdapter.service
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)[catalina.jar:8.0.18]
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)[catalina.jar:8.0.18]
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)[catalina.jar:8.0.18]
      4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)[catalina.jar:8.0.18]
      5. org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)[catalina.jar:8.0.18]
      6. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)[catalina.jar:8.0.18]
      7. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)[catalina.jar:8.0.18]
      8. org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:610)[catalina.jar:8.0.18]
      9. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)[catalina.jar:8.0.18]
      10. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:516)[catalina.jar:8.0.18]
      10 frames
    33. Grizzly HTTP
      NioEndpoint$SocketProcessor.run
      1. org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1086)[tomcat-coyote.jar:8.0.18]
      2. org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:659)[tomcat-coyote.jar:8.0.18]
      3. org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:223)[tomcat-coyote.jar:8.0.18]
      4. org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1558)[tomcat-coyote.jar:8.0.18]
      5. org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1515)[tomcat-coyote.jar:8.0.18]
      5 frames
    34. Java RT
      ThreadPoolExecutor$Worker.run
      1. java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)[na:1.8.0_31]
      2. java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)[na:1.8.0_31]
      2 frames
    35. Tomcat Util
      TaskThread$WrappingRunnable.run
      1. org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)[tomcat-util.jar:8.0.18]
      1 frame
    36. Java RT
      Thread.run
      1. java.lang.Thread.run(Unknown Source)[na:1.8.0_31]
      1 frame