Juan: You need to determine two things:
1) Do you truly intend to insert NULL using the SQL? 2) If so, you need to remove the NULL constraints from the table in Oracle. David 2010/2/9 Juan José Vidal <[email protected]>: > Hi, > > I've a problem adding a service in the CAS Service Manager, and I don't > know how can I solve this... > > Our environment: > > - CAS 3.3.4 > - Oracle9i (9.2.0.6) > - JDK 1.5 > - OAS 10G (10.1.3) > > CAS works fine, and Service Manager DB tables was created by Hibernate > successfully (well... we had to disable Toplink Libraries on OAS :P), > but when I want to add a new service, I see this error... > > Ideas? > Thanks in advance! > > 10/02/09 11:01:35 Hibernate: insert into RegisteredServiceImpl > (allowedToProxy, anonymousAccess, description, enabled, > ignoreAttributes, name, serviceId, ssoEnabled, theme, id) values > (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) > 2010-02-09 11:01:35,983 ERROR [org.hibernate.util.JDBCExceptionReporter] - > <ORA-01400: cannot insert NULL into > ("CAS"."REGISTEREDSERVICEIMPL"."EVALUATION_ORDER") >> > 2010-02-09 11:01:35,983 ERROR [org.hibernate.util.JDBCExceptionReporter] - > <ORA-01400: cannot insert NULL into > ("CAS"."REGISTEREDSERVICEIMPL"."EVALUATION_ORDER") >> > 2010-02-09 11:01:35,985 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 $Proxy31.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:380) > at > oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9145) > 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 > > -- > Juan José Vidal Agustín > ATICA - Sección de Telemática > Universidad de Murcia > Tlf: +34 868888742 > Fax: +34 868888337 > [email protected] > > > -- > You are currently subscribed to [email protected] as: > [email protected] > To unsubscribe, change settings or access archives, see > http://www.ja-sig.org/wiki/display/JSG/cas-user > -- David L. Whitehurst http://www.capehenrytech.com … Providing software instruction through a sea of Technology. -- You are currently subscribed to [email protected] as: [email protected] To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/cas-user
