org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update

Apereo Issues | Drew Wills | 6 years ago
  1. 0

    We're seeing an issue with a database constraint generated by hibernate on Oracle (see stack trace at bottom). It happens occasinally/infrequently (hard to reproduce) when a user first visits the AnnouncementsDisplay portlet. At that time, the TopicSubscriptionService evaluates the available topics, their subscription models, and user's group memberships to arrive at an initial/default set of TopicSubscription objects. Once it does, it persists those TopicSubscription entities in the DB using hibernate. The constraint violation is on the primary key for the SUBSCRIPTION table: the SUB_ID column, which holds the hibernate Id. Somehow the portlet is attempting to write records that violate uniqueness on the column (checked with DBA to verify which constraint is at issue). This is a new portal, and we believe the issue may be related to the number of new user accounts (several) that are currently being created. We also observe that the persistence code for the portlet does not appear to be transactional anywhere. And lastly, upon reviewing the persistence behavior in the portlet, it seems like many/most of these writes may be unnecessary. It seems like a good idea to persist users' topic selections only when they make them in the editDisplayPreferences view. Until they do, we can use the calculated set. So one possible fix for this issue is to change the behavior of the portlet so it doesn't save users' topic selections until they "override" the defaults in editDisplayPreferences. This will cut down dramatically on database writes, and [** IMPORTANT NOTE **] the change in strategy is fully backwards-compatible with existing data (created under the old strategy). ***** WARN [org.jasig.portal.ChannelManager#76] portlet.DispatcherPortlet.[] Jul/26 15:58:56 - Handler execution resulted in exception - forwarding to resolved error view org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:636) at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424) at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374) at org.springframework.orm.hibernate3.HibernateTemplate.flush(HibernateTemplate.java:890) at org.jasig.portlet.announcements.service.HibernateAnnouncementService.addOrSaveTopicSubscription(HibernateAnnouncementService.java:230) at org.jasig.portlet.announcements.service.TopicSubscriptionService.getTopicSubscription(TopicSubscriptionService.java:140) at org.jasig.portlet.announcements.service.TopicSubscriptionService.getTopicSubscription(TopicSubscriptionService.java:162) at org.jasig.portlet.announcements.controller.AnnouncementsViewController.mainView(AnnouncementsViewController.java:111) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.doInvokeMethod(HandlerMethodInvoker.java:421) at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:136) at org.springframework.web.portlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:271) at org.springframework.web.portlet.mvc.annotation.AnnotationMethodHandlerAdapter.doHandle(AnnotationMethodHandlerAdapter.java:259) at org.springframework.web.portlet.mvc.annotation.AnnotationMethodHandlerAdapter.handleRender(AnnotationMethodHandlerAdapter.java:218) at org.springframework.web.portlet.DispatcherPortlet.doRenderService(DispatcherPortlet.java:811) at org.springframework.web.portlet.FrameworkPortlet.processRequest(FrameworkPortlet.java:483) at org.springframework.web.portlet.FrameworkPortlet.doDispatch(FrameworkPortlet.java:453) at javax.portlet.GenericPortlet.render(GenericPortlet.java:175) at org.apache.pluto.core.PortletServlet.dispatch(PortletServlet.java:208) at org.apache.pluto.core.PortletServlet.doGet(PortletServlet.java:139) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646) at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:551) at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:488) at org.apache.pluto.core.DefaultPortletInvokerService.invoke(DefaultPortletInvokerService.java:167) at org.apache.pluto.core.DefaultPortletInvokerService.render(DefaultPortletInvokerService.java:101) at org.apache.pluto.core.PortletContainerImpl.doRender(PortletContainerImpl.java:172) at sun.reflect.GeneratedMethodAccessor194.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.beans.factory.config.AbstractFactoryBean$EarlySingletonInvocationHandler.invoke(AbstractFactoryBean.java:254) at $Proxy64.doRender(Unknown Source) at org.jasig.portal.portlet.rendering.PortletRendererImpl.doRender(PortletRendererImpl.java:232) at org.jasig.portal.channels.portlet.SpringPortletChannelImpl.render(SpringPortletChannelImpl.java:380) at org.jasig.portal.channels.portlet.CSpringPortletAdaptor.renderCharacters(CSpringPortletAdaptor.java:217) at org.jasig.portal.ChannelRenderer$Worker.execute(ChannelRenderer.java:631) at org.jasig.portal.utils.threading.BaseTask.run(BaseTask.java:41) at sun.reflect.GeneratedMethodAccessor178.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.orm.jpa.JpaInterceptor.invoke(JpaInterceptor.java:96) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at org.jasig.portal.$Proxy138.run(Unknown Source) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:619) Caused by: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:254) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1001) at org.springframework.orm.hibernate3.HibernateTemplate$28.doInHibernate(HibernateTemplate.java:892) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419) ... 57 more Caused by: java.sql.BatchUpdateException: ORA-00001: unique constraint (UPORTAL.SYS_C004883) violated at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343) at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10656) at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:247) ... 64 more

    Apereo Issues | 6 years ago | Drew Wills
    org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
  2. 0

    We're seeing an issue with a database constraint generated by hibernate on Oracle (see stack trace at bottom). It happens occasinally/infrequently (hard to reproduce) when a user first visits the AnnouncementsDisplay portlet. At that time, the TopicSubscriptionService evaluates the available topics, their subscription models, and user's group memberships to arrive at an initial/default set of TopicSubscription objects. Once it does, it persists those TopicSubscription entities in the DB using hibernate. The constraint violation is on the primary key for the SUBSCRIPTION table: the SUB_ID column, which holds the hibernate Id. Somehow the portlet is attempting to write records that violate uniqueness on the column (checked with DBA to verify which constraint is at issue). This is a new portal, and we believe the issue may be related to the number of new user accounts (several) that are currently being created. We also observe that the persistence code for the portlet does not appear to be transactional anywhere. And lastly, upon reviewing the persistence behavior in the portlet, it seems like many/most of these writes may be unnecessary. It seems like a good idea to persist users' topic selections only when they make them in the editDisplayPreferences view. Until they do, we can use the calculated set. So one possible fix for this issue is to change the behavior of the portlet so it doesn't save users' topic selections until they "override" the defaults in editDisplayPreferences. This will cut down dramatically on database writes, and [** IMPORTANT NOTE **] the change in strategy is fully backwards-compatible with existing data (created under the old strategy). ***** WARN [org.jasig.portal.ChannelManager#76] portlet.DispatcherPortlet.[] Jul/26 15:58:56 - Handler execution resulted in exception - forwarding to resolved error view org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:636) at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424) at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374) at org.springframework.orm.hibernate3.HibernateTemplate.flush(HibernateTemplate.java:890) at org.jasig.portlet.announcements.service.HibernateAnnouncementService.addOrSaveTopicSubscription(HibernateAnnouncementService.java:230) at org.jasig.portlet.announcements.service.TopicSubscriptionService.getTopicSubscription(TopicSubscriptionService.java:140) at org.jasig.portlet.announcements.service.TopicSubscriptionService.getTopicSubscription(TopicSubscriptionService.java:162) at org.jasig.portlet.announcements.controller.AnnouncementsViewController.mainView(AnnouncementsViewController.java:111) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.doInvokeMethod(HandlerMethodInvoker.java:421) at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:136) at org.springframework.web.portlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:271) at org.springframework.web.portlet.mvc.annotation.AnnotationMethodHandlerAdapter.doHandle(AnnotationMethodHandlerAdapter.java:259) at org.springframework.web.portlet.mvc.annotation.AnnotationMethodHandlerAdapter.handleRender(AnnotationMethodHandlerAdapter.java:218) at org.springframework.web.portlet.DispatcherPortlet.doRenderService(DispatcherPortlet.java:811) at org.springframework.web.portlet.FrameworkPortlet.processRequest(FrameworkPortlet.java:483) at org.springframework.web.portlet.FrameworkPortlet.doDispatch(FrameworkPortlet.java:453) at javax.portlet.GenericPortlet.render(GenericPortlet.java:175) at org.apache.pluto.core.PortletServlet.dispatch(PortletServlet.java:208) at org.apache.pluto.core.PortletServlet.doGet(PortletServlet.java:139) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646) at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:551) at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:488) at org.apache.pluto.core.DefaultPortletInvokerService.invoke(DefaultPortletInvokerService.java:167) at org.apache.pluto.core.DefaultPortletInvokerService.render(DefaultPortletInvokerService.java:101) at org.apache.pluto.core.PortletContainerImpl.doRender(PortletContainerImpl.java:172) at sun.reflect.GeneratedMethodAccessor194.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.beans.factory.config.AbstractFactoryBean$EarlySingletonInvocationHandler.invoke(AbstractFactoryBean.java:254) at $Proxy64.doRender(Unknown Source) at org.jasig.portal.portlet.rendering.PortletRendererImpl.doRender(PortletRendererImpl.java:232) at org.jasig.portal.channels.portlet.SpringPortletChannelImpl.render(SpringPortletChannelImpl.java:380) at org.jasig.portal.channels.portlet.CSpringPortletAdaptor.renderCharacters(CSpringPortletAdaptor.java:217) at org.jasig.portal.ChannelRenderer$Worker.execute(ChannelRenderer.java:631) at org.jasig.portal.utils.threading.BaseTask.run(BaseTask.java:41) at sun.reflect.GeneratedMethodAccessor178.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.orm.jpa.JpaInterceptor.invoke(JpaInterceptor.java:96) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at org.jasig.portal.$Proxy138.run(Unknown Source) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:619) Caused by: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:254) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1001) at org.springframework.orm.hibernate3.HibernateTemplate$28.doInHibernate(HibernateTemplate.java:892) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419) ... 57 more Caused by: java.sql.BatchUpdateException: ORA-00001: unique constraint (UPORTAL.SYS_C004883) violated at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343) at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10656) at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:247) ... 64 more

    Apereo Issues | 6 years ago | Drew Wills
    org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
  3. 0

    Oracle sequence grows by inconsistant number when persisting with Hibernate

    experts-exchange.com | 1 year ago
    org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    ConstraintViolationException doesn't rollback the transaction - Spring Forum

    spring.io | 12 months ago
    org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
  6. 0

    CAS works fine, and Service Manager DB tables was created by Hibernate successfully (well... we had to disable Toplink Libraries on OAS), but when I want to add a new service, I see this error: 10/03/16 19:06:15 Hibernate: select hibernate_sequence.nextval from dual 10/03/16 19:06:15 Hibernate: insert into RegisteredServiceImpl (allowedToProxy, anonymousAccess, description, enabled, ignoreAttributes, name, serviceId, ssoEnabled, theme, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 2010-03-16 19:06:15,863 WARN [org.hibernate.util.JDBCExceptionReporter] - <SQL Error: 1400, SQLState: 23000> 2010-03-16 19:06:15,863 ERROR [org.hibernate.util.JDBCExceptionReporter] - <ORA-01400: cannot insert NULL into ("CAS"."REGISTEREDSERVICEIMPL"."EVALUATION_ORDER") > 2010-03-16 19:06:15,864 WARN [org.hibernate.util.JDBCExceptionReporter] - <SQL Error: 1400, SQLState: 23000> 2010-03-16 19:06:15,864 ERROR [org.hibernate.util.JDBCExceptionReporter] - <ORA-01400: cannot insert NULL into ("CAS"."REGISTEREDSERVICEIMPL"."EVALUATION_ORDER") > 2010-03-16 19:06:15,866 ERROR [org.hibernate.event.def.AbstractFlushingEventListener] - <Could not synchronize database state with session> org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000) at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338) at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106) at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:54) at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:456) at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:732) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:701) at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy30.save(Unknown Source) at org.jasig.cas.services.web.RegisteredServiceSimpleFormController.onSubmit(RegisteredServiceSimpleFormController.java:80) at org.springframework.web.servlet.mvc.SimpleFormController.processFormSubmission(SimpleFormController.java:267) at org.springframework.web.servlet.mvc.AbstractFormController.handleRequestInternal(AbstractFormController.java:265) at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511) at javax.servlet.http.HttpServlet.service(HttpServlet.java:763) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at org.jasig.cas.web.init.SafeDispatcherServlet.service(SafeDispatcherServlet.java:115) at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65) at org.inspektr.common.web.ClientInfoThreadLocalFilter.doFilterInternal(ClientInfoThreadLocalFilter.java:48) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.SessionFixationProtectionFilter.doFilterHttp(SessionFixationProtectionFilter.java:67) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:277) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370) at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871) at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453) at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:302) at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:190) at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260) at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:239) at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:34) at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:880) at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303) at java.lang.Thread.run(Thread.java:788) Caused by: java.sql.BatchUpdateException: ORA-01400: cannot insert NULL into ("CAS"."REGISTEREDSERVICEIMPL"."EVALUATION_ORDER") at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:498) at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:12432) at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246) ... 69 more ==== 1) Only a cas-server-core: cas-server-core-3.3.5 Where is the evaluation_order in this insert???? 10/03/16 19:06:15 Hibernate: insert into RegisteredServiceImpl (allowedToProxy, anonymousAccess, description, enabled, ignoreAttributes, name, serviceId, ssoEnabled, theme, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ==== My Classpath: /opt/oracle/oas10g/jdk/jre/lib/vm.jar:/opt/oracle/oas10g/jdk/jre/lib/core.jar:/opt/oracle/oas10g/jdk/jre/lib/charsets.jar:/opt/oracle/oas10g/jdk/jre/lib/graphics.jar:/opt/oracle/oas10g/jdk/jre/lib/security.jar:/opt/oracle/oas10g/jdk/jre/lib/ibmpkcs.jar:/opt/oracle/oas10g/jdk/jre/lib/ibmorb.jar:/opt/oracle/oas10g/jdk/jre/lib/ibmcfw.jar:/opt/oracle/oas10g/jdk/jre/lib/ibmorbapi.jar:/opt/oracle/oas10g/jdk/jre/lib/ibmjcefw.jar:/opt/oracle/oas10g/jdk/jre/lib/ibmjgssprovider.jar:/opt/oracle/oas10g/jdk/jre/lib/ibmjsseprovider2.jar:/opt/oracle/oas10g/jdk/jre/lib/ibmjaaslm.jar:/opt/oracle/oas10g/jdk/jre/lib/ibmcertpathprovider.jar:/opt/oracle/oas10g/jdk/jre/lib/server.jar:/opt/oracle/oas10g/jdk/jre/lib/xml.jar:/opt/oracle/oas10g/jdk/jre/lib/ext/CmpCrmf.jar:/opt/oracle/oas10g/jdk/jre/lib/ext/gskikm.jar:/opt/oracle/oas10g/jdk/jre/lib/ext/ibmjcefips.jar:/opt/oracle/oas10g/jdk/jre/lib/ext/ibmjceprovider.jar:/opt/oracle/oas10g/jdk/jre/lib/ext/ibmpkcs11.jar:/opt/oracle/oas10g/jdk/jre/lib/ext/ibmpkcs11impl.jar:/opt/oracle/oas10g/jdk/jre/lib/ext/ibmsaslprovider.jar:/opt/oracle/oas10g/jdk/jre/lib/ext/indicim.jar:/opt/oracle/oas10g/jdk/jre/lib/ext/jaccess.jar:/opt/oracle/oas10g/jdk/jre/lib/ext/javaxcomm.jar:/opt/oracle/oas10g/jdk/jre/lib/ext/jdmpview.jar:/opt/oracle/oas10g/jdk/jre/lib/ext/jsse.jar:/opt/oracle/oas10g/jdk/jre/lib/ext/ldapsec.jar:/opt/oracle/oas10g/jdk/jre/lib/ext/security_ext.jar:/opt/oracle/oas10g/jdk/jre/lib/ext/sunjce_provider.jar:/opt/oracle/oas10g/j2ee/home/oc4j-api.jar:/opt/oracle/oas10g/j2ee/home/lib/oc4j-unsupported-api.jar:/opt/oracle/oas10g/j2ee/home/lib/activation.jar:/opt/oracle/oas10g/j2ee/home/lib/mail.jar:/opt/oracle/oas10g/j2ee/home/lib/persistence.jar:/opt/oracle/oas10g/j2ee/home/lib/ejb30.jar:/opt/oracle/oas10g/j2ee/home/lib/ejb.jar:/opt/oracle/oas10g/j2ee/home/lib/javax77.jar:/opt/oracle/oas10g/j2ee/home/lib/javax88.jar:/opt/oracle/oas10g/j2ee/home/lib/servlet.jar:/opt/oracle/oas10g/j2ee/home/lib/jms.jar:/opt/oracle/oas10g/j2ee/home/lib/jta.jar:/opt/oracle/oas10g/j2ee/home/lib/jacc-api.jar:/opt/oracle/oas10g/j2ee/home/lib/connector.jar:/opt/oracle/oas10g/j2ee/home/lib/jmx_remote_api.jar:/opt/oracle/oas10g/j2ee/home/lib/jax-qname-namespace.jar:/opt/oracle/oas10g/webservices/lib/jaxr-api.jar:/opt/oracle/oas10g/webservices/lib/jaxrpc-api.jar:/opt/oracle/oas10g/webservices/lib/saaj-api.jar:/opt/oracle/oas10g/webservices/lib/jws-api.jar:/opt/oracle/oas10g/j2ee/home/lib/oc4j-internal.jar:/opt/oracle/oas10g/j2ee/home/lib/oems-jms-oc4j.jar:/opt/oracle/oas10g/j2ee/home/lib/oems-jms-client.jar:/opt/oracle/oas10g/j2ee/home/lib/oems-jms-server.jar:/opt/oracle/oas10g/j2ee/home/lib/oc4j-schemas.jar:/opt/oracle/oas10g/j2ee/home/lib/ojsp.jar:/opt/oracle/oas10g/j2ee/home/lib/oc4j_orb.jar:/opt/oracle/oas10g/j2ee/home/lib/iiop_support.jar:/opt/oracle/oas10g/j2ee/home/lib/orbbase.jar:/opt/oracle/oas10g/j2ee/home/iiop_gen_bin.jar:/opt/oracle/oas10g/j2ee/home/lib/jmxcluster.jar:/opt/oracle/oas10g/j2ee/home/jaccprovider.jar:/opt/oracle/oas10g/javavm/lib/jasper.zip:/opt/oracle/oas10g/j2ee/home/lib/adminclient.jar:/opt/oracle/oas10g/opmn/lib/optic.jar:/opt/oracle/oas10g/j2ee/home/jacc-spi.jar:/opt/oracle/oas10g/j2ee/home/jazncore.jar:/opt/oracle/oas10g/j2ee/home/jazn.jar:/opt/oracle/oas10g/jlib/infratool.jar:/opt/oracle/oas10g/jlib/ospnego.jar:/opt/oracle/oas10g/jlib/ldapjclnt10.jar:/opt/oracle/oas10g/webservices/lib/wsserver.jar:/opt/oracle/oas10g/webservices/lib/wsif.jar:/opt/oracle/oas10g/webservices/lib/orawsmetadata.jar:/opt/oracle/oas10g/webservices/lib/orajaxr.jar:/opt/oracle/oas10g/jlib/jssl-1_1.jar:/opt/oracle/oas10g/jlib/repository.jar:/opt/oracle/oas10g/jlib/ojmisc.jar:/opt/oracle/oas10g/toplink/jlib/toplink-oc4j.jar:/opt/oracle/oas10g/diagnostics/lib/ojdl2.jar:/opt/oracle/oas10g/xqs/lib/xqs-api.jar:/opt/oracle/oas10g/xqs/lib/xds.jar:/opt/oracle/oas10g/j2ee/home/lib/pcl.jar:/opt/oracle/oas10g/j2ee/home/lib/ext:/opt/oracle/oas10g/j2ee/home/lib/ext/wsif-j2c.jar:/opt/oracle/oas10g/j2ee/home/lib/ext/adfperfhandler.jar:/opt/oracle/oas10g/webservices/lib/JMXSoapAdapterShared.jar:/opt/oracle/oas10g/lib/dmsapp.jar:/opt/oracle/oas10g/j2ee/home/applications/admin_ejb.jar:/opt/oracle/oas10g/j2ee/home/lib/scheduler.jar:/opt/oracle/oas10g/j2ee/OC4J_cas/connectors/datasources/datasources/datasources.jar:/opt/oracle/oas10g/j2ee/OC4J_cas/connectors/OracleASjms/OracleASjms/gjra.jar:/opt/oracle/oas10g/j2ee/home/applications/jmsrouter-ejb.jar:/opt/oracle/oas10g/BC4J/lib:/opt/oracle/oas10g/BC4J/lib/adfcm.jar:/opt/oracle/oas10g/BC4J/lib/adfm.jar:/opt/oracle/oas10g/BC4J/lib/adfmweb.jar:/opt/oracle/oas10g/BC4J/lib/adfshare.jar:/opt/oracle/oas10g/BC4J/lib/bc4jct.jar:/opt/oracle/oas10g/BC4J/lib/bc4jctejb.jar:/opt/oracle/oas10g/BC4J/lib/bc4jdomorcl.jar:/opt/oracle/oas10g/BC4J/lib/bc4jimdomains.jar:/opt/oracle/oas10g/BC4J/lib/bc4jmt.jar:/opt/oracle/oas10g/BC4J/lib/bc4jmtejb.jar:/opt/oracle/oas10g/BC4J/lib/collections.jar:/opt/oracle/oas10g/BC4J/lib/adfbinding.jar:/opt/oracle/oas10g/jlib/commons-cli-1.0.jar:/opt/oracle/oas10g/mds/lib/concurrent.jar:/opt/oracle/oas10g/mds/lib/mdsrt.jar:/opt/oracle/oas10g/jlib/share.jar:/opt/oracle/oas10g/jlib/regexp.jar:/opt/oracle/oas10g/jlib/xmlef.jar:/opt/oracle/oas10g/BC4J/jlib/adfmtl.jar:/opt/oracle/oas10g/BC4J/jlib/adfui.jar:/opt/oracle/oas10g/BC4J/jlib/adf-connections.jar:/opt/oracle/oas10g/BC4J/jlib/dc-adapters.jar:/opt/oracle/oas10g/ord/jlib/ordim.jar:/opt/oracle/oas10g/ord/jlib/ordhttp.jar:/opt/oracle/oas10g/jlib/ojmisc.jar:/opt/oracle/oas10g/jlib/jdev-cm.jar:/opt/oracle/oas10g/lib/xsqlserializers.jar:/opt/oracle/oas10g/diagnostics/lib/ojdl.jar:/opt/oracle/oas10g/lib/dms.jar:/opt/oracle/oas10g/j2ee/OC4J_cas/shared-lib/oracle.jdbc/10.2.0.3.0/ocrs12.jar:/opt/oracle/oas10g/j2ee/OC4J_cas/shared-lib/oracle.jdbc/10.2.0.3.0/ocrs12.zip:/opt/oracle/oas10g/j2ee/OC4J_cas/shared-lib/oracle.jdbc/10.2.0.3.0/ojdbc14_g.jar:/opt/oracle/oas10g/j2ee/OC4J_cas/shared-lib/oracle.jdbc/10.2.0.3.0/ojdbc14.jar:/opt/oracle/oas10g/j2ee/OC4J_cas/shared-lib/oracle.jdbc/10.2.0.3.0/ojdbc14dms_g.jar:/opt/oracle/oas10g/j2ee/OC4J_cas/shared-lib/oracle.jdbc/10.2.0.3.0/ojdbc14dms.jar:/opt/oracle/oas10g/j2ee/OC4J_cas/shared-lib/oracle.jdbc/10.2.0.3.0/orai18n.jar:/opt/oracle/oas10g/jdbc/lib/orai18n.jar:/opt/oracle/oas10g/lib/xmlparserv2.jar:/opt/oracle/oas10g/lib/xml.jar:/opt/oracle/oas10g/lib/xmlmesg.jar:/opt/oracle/oas10g/lib/xsu12.jar:/opt/oracle/oas10g/lib/xquery.jar:/opt/oracle/oas10g/jlib/osdt_core.jar:/opt/oracle/oas10g/jlib/osdt_cert.jar:/opt/oracle/oas10g/jlib/osdt_xmlsec.jar:/opt/oracle/oas10g/jlib/osdt_wss.jar:/opt/oracle/oas10g/jlib/osdt_saml.jar:/opt/oracle/oas10g/jlib/ojpse.jar:/opt/oracle/oas10g/jlib/oraclepki.jar:/opt/oracle/oas10g/toplink/jlib/toplink-essentials.jar:/opt/oracle/oas10g/webservices/lib/wsclient.jar:/opt/oracle/oas10g/webservices/lib/orasaaj.jar:/opt/oracle/oas10g/webservices/lib/xsdlib.jar:/opt/oracle/oas10g/webservices/lib/mdds.jar:/opt/oracle/oas10g/webservices/lib/relaxngDatatype.jar:/opt/oracle/oas10g/javacache/lib/cache.jar:/opt/oracle/oas10g/lib/xschema.jar:/opt/oracle/oas10g/webservices/lib/soap.jar:/opt/oracle/oas10g/sqlj/lib/runtime12.jar:/opt/oracle/oas10g/sqlj/lib/translator.jar:/opt/oracle/oas10g/webservices/lib/orawsdl.jar:/opt/oracle/oas10g/j2ee/OC4J_cas/applib:/opt/oracle/oas10g/j2ee/home/jsp/lib/taglib:/opt/oracle/oas10g/j2ee/home/jsp/lib/taglib/ojsputil.jar:/opt/oracle/oas10g/lib/dsv2.jar:/opt/oracle/oas10g/j2ee/home/lib/http_client.jar:/opt/oracle/oas10g/j2ee/home/lib/jgroups-core.jar:/www/cas/web_cas:/www/cas/web_cas/WEB-INF/classes:/www/cas/web_cas/WEB-INF/lib:/www/cas/web_cas/WEB-INF/lib/spring-context-2.5.6.SEC01.jar:/www/cas/web_cas/WEB-INF/lib/spring-webflow-1.0.6.jar:/www/cas/web_cas/WEB-INF/lib/cas-client-core-3.1.3.jar:/www/cas/web_cas/WEB-INF/lib/spring-beans-2.5.6.SEC01.jar:/www/cas/web_cas/WEB-INF/lib/jstl-1.1.2.jar:/www/cas/web_cas/WEB-INF/lib/spring-binding-1.0.6.jar:/www/cas/web_cas/WEB-INF/lib/jta-1.0.1B.jar:/www/cas/web_cas/WEB-INF/lib/spring-tx-2.5.6.SEC01.jar:/www/cas/web_cas/WEB-INF/lib/dom4j-1.6.1.jar:/www/cas/web_cas/WEB-INF/lib/spring-context-support-2.5.6.SEC01.jar:/www/cas/web_cas/WEB-INF/lib/hibernate-annotations-3.3.1.GA.jar:/www/cas/web_cas/WEB-INF/lib/inspektr-core-0.7.0.jar:/www/cas/web_cas/WEB-INF/lib/ejb3-persistence-1.0.1.GA.jar:/www/cas/web_cas/WEB-INF/lib/commons-collections-3.2.1.jar:/www/cas/web_cas/WEB-INF/lib/spring-security-cas-client-2.0.4.jar:/www/cas/web_cas/WEB-INF/lib/jaxb-impl-2.1.9.jar:/www/cas/web_cas/WEB-INF/lib/jaxb-api-2.1.jar:/www/cas/web_cas/WEB-INF/lib/spring-ldap-core-tiger-1.3.0.RELEASE.jar:/www/cas/web_cas/WEB-INF/lib/hibernate-3.2.6.ga.jar:/www/cas/web_cas/WEB-INF/lib/standard-1.1.2.jar:/www/cas/web_cas/WEB-INF/lib/activation-1.1.jar:/www/cas/web_cas/WEB-INF/lib/cglib-2.1_3.jar:/www/cas/web_cas/WEB-INF/lib/log4j-1.2.15.jar:/www/cas/web_cas/WEB-INF/lib/aspectjrt-1.5.3.jar:/www/cas/web_cas/WEB-INF/lib/xmldsig-1.0.jar:/www/cas/web_cas/WEB-INF/lib/aopalliance-1.0.jar:/www/cas/web_cas/WEB-INF/lib/cas-server-core-3.3.5.jar:/www/cas/web_cas/WEB-INF/lib/aspectjweaver-1.5.3.jar:/www/cas/web_cas/WEB-INF/lib/person-directory-api-1.5.0-RC5.jar:/www/cas/web_cas/WEB-INF/lib/cas-server-support-ldap-3.3.5.jar:/www/cas/web_cas/WEB-INF/lib/spring-core-2.5.6.SEC01.jar:/www/cas/web_cas/WEB-INF/lib/ognl-2.6.9.jar:/www/cas/web_cas/WEB-INF/lib/opensaml-1.1b.jar:/www/cas/web_cas/WEB-INF/lib/asm-attrs-1.5.3.jar:/www/cas/web_cas/WEB-INF/lib/spring-orm-2.5.6.SEC01.jar:/www/cas/web_cas/WEB-INF/lib/ehcache-1.2.3.jar:/www/cas/web_cas/WEB-INF/lib/stax-api-1.0-2.jar:/www/cas/web_cas/WEB-INF/lib/asm-1.5.3.jar:/www/cas/web_cas/WEB-INF/lib/spring-jdbc-2.5.6.SEC01.jar:/www/cas/web_cas/WEB-INF/lib/spring-ldap-core-1.3.0.RELEASE.jar:/www/cas/web_cas/WEB-INF/lib/jdom-1.0.jar:/www/cas/web_cas/WEB-INF/lib/commons-codec-1.3.jar:/www/cas/web_cas/WEB-INF/lib/persistence-api-1.0.jar:/www/cas/web_cas/WEB-INF/lib/hibernate-commons-annotations-3.0.0.ga.jar:/www/cas/web_cas/WEB-INF/lib/commons-collections-3.2.jar:/www/cas/web_cas/WEB-INF/lib/quartz-1.5.2.jar:/www/cas/web_cas/WEB-INF/lib/antlr-2.7.6.jar:/www/cas/web_cas/WEB-INF/lib/commons-lang-2.2.jar:/www/cas/web_cas/WEB-INF/lib/commons-logging-1.1.1.jar:/www/cas/web_cas/WEB-INF/lib/spring-security-core-2.0.4.jar:/www/cas/web_cas/WEB-INF/lib/xmlsec-1.4.3.jar:/www/cas/web_cas/WEB-INF/lib/person-directory-impl-1.5.0-RC5.jar:/www/cas/web_cas/WEB-INF/lib/spring-web-2.5.6.SEC01.jar:/www/cas/web_cas/WEB-INF/lib/spring-aop-2.5.6.SEC01.jar:/www/cas/web_cas/WEB-INF/lib/spring-webmvc-2.5.6.SEC01.jar:/www/cas/web_cas/WEB-INF/lib/servlet-api-2.4.jar:/www/cas/web_cas/WEB-INF/lib/hibernate-validator-3.0.0.ga.jar:/www/cas/web_cas/WEB-INF/lib/concurrent-1.3.4.jar:/www/cas/web_cas/WEB-INF/lib/commons-collections-2.1.1.jar:/www/cas/web_cas/WEB-INF/lib/spring-support-2.0.8.jar:/www/cas/web_cas/WEB-INF/lib/commons-dbcp-1.2.2.jar:/www/cas/web_cas/WEB-INF/lib/javassist-3.3.ga.jar:/www/cas/web_cas/WEB-INF/lib/hibernate-entitymanager-3.3.1.ga.jar:/www/cas/web_cas/WEB-INF/lib/jboss-common-core-2.0.4.GA.jar:/www/cas/web_cas/WEB-INF/lib/commons-pool-1.3.jar:/www/cas/web_cas/WEB-INF/lib/hibernate-3.2.5.ga.jar:/www/cas/web_cas/WEB-INF/lib/ojdbc14-10.2.0.3.0.jar:/www/cas/web_cas/WEB-INF/lib/spring-dao-2.0.8.jar:/www/cas/web_cas/WEB-INF/lib/spring-aop-2.0.8.jar:/www/cas/web_cas/WEB-INF/lib/cas-client-core-3.1.1.jar:/www/cas/web_cas/WEB-INF/lib/spring-security-cas-client-2.0.1.jar:/www/cas/web_cas/WEB-INF/lib/spring-security-core-2.0.1.jar I think that's a bug... Thanks in advance!

    Apereo Issues | 7 years ago | Juan Jos�� Vidal
    org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update

    3 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.BatchUpdateException

      ORA-00001: unique constraint (UPORTAL.SYS_C004883) violated

      at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException()
    2. Oracle jdbc
      OraclePreparedStatement.executeBatch
      1. oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
      2. oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10656)
      2 frames
    3. Commons DBCP
      DelegatingStatement.executeBatch
      1. org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
      2. org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
      2 frames
    4. Hibernate
      ActionQueue.executeActions
      1. org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
      2. org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:247)
      3. org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
      4. org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
      4 frames
    5. Hibernate
      SessionImpl.flush
      1. org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
      2. org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
      3. org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1001)
      3 frames
    6. Hibernate
      HibernateTemplate.flush
      1. org.springframework.orm.hibernate3.HibernateTemplate$28.doInHibernate(HibernateTemplate.java:892)
      2. org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419)
      3. org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
      4. org.springframework.orm.hibernate3.HibernateTemplate.flush(HibernateTemplate.java:890)
      4 frames
    7. org.jasig.portlet
      AnnouncementsViewController.mainView
      1. org.jasig.portlet.announcements.service.HibernateAnnouncementService.addOrSaveTopicSubscription(HibernateAnnouncementService.java:230)
      2. org.jasig.portlet.announcements.service.TopicSubscriptionService.getTopicSubscription(TopicSubscriptionService.java:140)
      3. org.jasig.portlet.announcements.service.TopicSubscriptionService.getTopicSubscription(TopicSubscriptionService.java:162)
      4. org.jasig.portlet.announcements.controller.AnnouncementsViewController.mainView(AnnouncementsViewController.java:111)
      4 frames
    8. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    9. Spring
      HandlerMethodInvoker.invokeHandlerMethod
      1. org.springframework.web.bind.annotation.support.HandlerMethodInvoker.doInvokeMethod(HandlerMethodInvoker.java:421)
      2. org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:136)
      2 frames
    10. Spring Web Portlet
      FrameworkPortlet.doDispatch
      1. org.springframework.web.portlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:271)
      2. org.springframework.web.portlet.mvc.annotation.AnnotationMethodHandlerAdapter.doHandle(AnnotationMethodHandlerAdapter.java:259)
      3. org.springframework.web.portlet.mvc.annotation.AnnotationMethodHandlerAdapter.handleRender(AnnotationMethodHandlerAdapter.java:218)
      4. org.springframework.web.portlet.DispatcherPortlet.doRenderService(DispatcherPortlet.java:811)
      5. org.springframework.web.portlet.FrameworkPortlet.processRequest(FrameworkPortlet.java:483)
      6. org.springframework.web.portlet.FrameworkPortlet.doDispatch(FrameworkPortlet.java:453)
      6 frames
    11. Java Portlet Specification V2.0
      GenericPortlet.render
      1. javax.portlet.GenericPortlet.render(GenericPortlet.java:175)
      1 frame
    12. Pluto Portlet Container
      PortletServlet.doGet
      1. org.apache.pluto.core.PortletServlet.dispatch(PortletServlet.java:208)
      2. org.apache.pluto.core.PortletServlet.doGet(PortletServlet.java:139)
      2 frames
    13. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
      2 frames
    14. Glassfish Core
      ApplicationDispatcher.include
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      3. org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
      4. org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:551)
      5. org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:488)
      5 frames
    15. Pluto Portlet Container
      PortletContainerImpl.doRender
      1. org.apache.pluto.core.DefaultPortletInvokerService.invoke(DefaultPortletInvokerService.java:167)
      2. org.apache.pluto.core.DefaultPortletInvokerService.render(DefaultPortletInvokerService.java:101)
      3. org.apache.pluto.core.PortletContainerImpl.doRender(PortletContainerImpl.java:172)
      3 frames
    16. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor194.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      3. java.lang.reflect.Method.invoke(Method.java:597)
      3 frames
    17. Spring Beans
      AbstractFactoryBean$EarlySingletonInvocationHandler.invoke
      1. org.springframework.beans.factory.config.AbstractFactoryBean$EarlySingletonInvocationHandler.invoke(AbstractFactoryBean.java:254)
      1 frame
    18. Unknown
      $Proxy64.doRender
      1. $Proxy64.doRender(Unknown Source)
      1 frame
    19. org.jasig.portal
      BaseTask.run
      1. org.jasig.portal.portlet.rendering.PortletRendererImpl.doRender(PortletRendererImpl.java:232)
      2. org.jasig.portal.channels.portlet.SpringPortletChannelImpl.render(SpringPortletChannelImpl.java:380)
      3. org.jasig.portal.channels.portlet.CSpringPortletAdaptor.renderCharacters(CSpringPortletAdaptor.java:217)
      4. org.jasig.portal.ChannelRenderer$Worker.execute(ChannelRenderer.java:631)
      5. org.jasig.portal.utils.threading.BaseTask.run(BaseTask.java:41)
      5 frames
    20. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor178.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      3. java.lang.reflect.Method.invoke(Method.java:597)
      3 frames
    21. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
      2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
      3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
      3 frames
    22. Spring ORM
      JpaInterceptor.invoke
      1. org.springframework.orm.jpa.JpaInterceptor.invoke(JpaInterceptor.java:96)
      1 frame
    23. Spring AOP
      JdkDynamicAopProxy.invoke
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
      2 frames
    24. org.jasig.portal
      $Proxy138.run
      1. org.jasig.portal.$Proxy138.run(Unknown Source)
      1 frame
    25. Java RT
      Thread.run
      1. java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
      2. java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
      3. java.util.concurrent.FutureTask.run(FutureTask.java:138)
      4. java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
      5. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
      6. java.lang.Thread.run(Thread.java:619)
      6 frames