org.hibernate.exception.ConstraintViolationException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Unique constraint under hibernate
    via by user565514,
  • 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!
    via by Juan Jos�� Vidal,
  • 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!
    via by Juan Jos�� Vidal,
  • 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
    via by Drew Wills,
  • 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
    via by Drew Wills,
  • Hibernate - Mapping to URITYPE?
    via Stack Overflow by Jonathan
    ,
    • 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:202) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:297) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:985) at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:333) at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106) at com.ericsson.pii.dataaccessor.AccessDaoHibernateImplSpringTest.testAggregateSingleAccesses(AccessDaoHibernateImplSpringTest.java:74) 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:585) at junit.framework.TestCase.runTest(TestCase.java:154) at junit.framework.TestCase.runBare(TestCase.java:127) at junit.framework.TestResult$1.protect(TestResult.java:106) at junit.framework.TestResult.runProtected(TestResult.java:124) at junit.framework.TestResult.run(TestResult.java:109) at junit.framework.TestCase.run(TestCase.java:118) at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:128) at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196) Caused by: java.sql.BatchUpdateException: ORA-00001: unique constraint (PIIUSER_JUNIT.SYS_C009305) violated at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:342) at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698) at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294) at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:58) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:195) ... 24 more

    Users with the same issue

    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,