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

Apereo Issues | Juan Jos�� Vidal | 7 years ago
  1. 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
  2. 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. 0

    Unique constraint under hibernate

    Oracle Community | 10 years ago | user565514
    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

    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
  6. 0

    ConstraintViolationException doesn't rollback the transaction - Spring Forum

    spring.io | 12 months ago
    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-01400: cannot insert NULL into ("CAS"."REGISTEREDSERVICEIMPL"."EVALUATION_ORDER")

      at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException()
    2. Oracle jdbc
      OraclePreparedStatement.executeBatch
      1. oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:498)
      2. oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:12432)
      2 frames
    3. Commons DBCP
      DelegatingStatement.executeBatch
      1. org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
      1 frame
    4. Hibernate
      ActionQueue.executeActions
      1. org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
      2. org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
      3. org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
      4. org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
      4 frames
    5. Hibernate
      SessionImpl.managedFlush
      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:1000)
      4. org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
      4 frames
    6. Hibernate
      JDBCTransaction.commit
      1. org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
      1 frame
    7. Hibernate EJB
      TransactionImpl.commit
      1. org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:54)
      1 frame
    8. Spring ORM
      JpaTransactionManager.doCommit
      1. org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:456)
      1 frame
    9. Spring Tx
      TransactionInterceptor.invoke
      1. org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:732)
      2. org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:701)
      3. org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321)
      4. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116)
      4 frames
    10. 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
    11. Unknown
      $Proxy30.save
      1. $Proxy30.save(Unknown Source)
      1 frame
    12. Jasig CAS Core
      RegisteredServiceSimpleFormController.onSubmit
      1. org.jasig.cas.services.web.RegisteredServiceSimpleFormController.onSubmit(RegisteredServiceSimpleFormController.java:80)
      1 frame
    13. Spring MVC
      FrameworkServlet.doPost
      1. org.springframework.web.servlet.mvc.SimpleFormController.processFormSubmission(SimpleFormController.java:267)
      2. org.springframework.web.servlet.mvc.AbstractFormController.handleRequestInternal(AbstractFormController.java:265)
      3. org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
      4. org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
      5. org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)
      6. org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807)
      7. org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)
      8. org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511)
      8 frames
    14. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      2 frames
    15. Jasig CAS Core
      SafeDispatcherServlet.service
      1. org.jasig.cas.web.init.SafeDispatcherServlet.service(SafeDispatcherServlet.java:115)
      1 frame
    16. com.evermind.server
      ResourceFilterChain.doFilter
      1. com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65)
      1 frame
    17. org.inspektr.common
      ClientInfoThreadLocalFilter.doFilterInternal
      1. org.inspektr.common.web.ClientInfoThreadLocalFilter.doFilterInternal(ClientInfoThreadLocalFilter.java:48)
      1 frame
    18. Spring
      OncePerRequestFilter.doFilter
      1. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
      1 frame
    19. com.evermind.server
      EvermindFilterChain.doFilter
      1. com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
      1 frame
    20. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
      1 frame
    21. org.springframework.security
      FilterSecurityInterceptor.doFilter
      1. org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
      2. org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
      2 frames
    22. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      1 frame
    23. org.springframework.security
      SpringSecurityFilter.doFilter
      1. org.springframework.security.ui.SessionFixationProtectionFilter.doFilterHttp(SessionFixationProtectionFilter.java:67)
      2. org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
      2 frames
    24. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      1 frame
    25. org.springframework.security
      SpringSecurityFilter.doFilter
      1. org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
      2. org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
      2 frames
    26. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      1 frame
    27. org.springframework.security
      SpringSecurityFilter.doFilter
      1. org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)
      2. org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
      2 frames
    28. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      1 frame
    29. org.springframework.security
      SpringSecurityFilter.doFilter
      1. org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:277)
      2. org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
      2 frames
    30. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      1 frame
    31. org.springframework.security
      SpringSecurityFilter.doFilter
      1. org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89)
      2. org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
      2 frames
    32. spring-security-core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      1 frame
    33. Spring Security - Portlet support
      HttpSessionContextIntegrationFilter.doFilterHttp
      1. org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
      1 frame
    34. org.springframework.security
      SpringSecurityFilter.doFilter
      1. org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
      1 frame
    35. spring-security-core
      FilterChainProxy.doFilter
      1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      2. org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)
      2 frames
    36. Spring
      DelegatingFilterProxy.doFilter
      1. org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
      2. org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
      2 frames
    37. com.evermind.server
      AJPRequestHandler.run
      1. com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621)
      2. com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
      3. com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
      4. com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
      5. com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:302)
      6. com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:190)
      6 frames
    38. oracle.oc4j.network
      ServerSocketAcceptHandler$AcceptHandlerHorse.run
      1. oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
      2. oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:239)
      3. oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:34)
      4. oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:880)
      4 frames
    39. com.evermind.util
      ReleasableResourcePooledExecutor$MyWorker.run
      1. com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
      1 frame
    40. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:788)
      1 frame