I reported this issue at http://www.ja-sig.org/issues/browse/CAS-789
> My instance of CAS is used for a lot services. After logging in a bunch of > them, I try to log in to a new one, and I get this exception: > > java.sql.BatchUpdateException: Data truncation: Data too long for column > 'SERVICES_GRANTED_ACCESS_TO' at row 1 > > com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1666) > > com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1082) > > org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) > > org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48) > > org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246) > org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266) > org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:168) > > org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298) > > org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27) > org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000) > org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338) > > org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106) > org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:54) > > org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:456) > > org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:732) > > org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:701) > > org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321) > > org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116) > > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) > > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) > $Proxy98.grantServiceTicket(Unknown Source) > > org.jasig.cas.web.flow.GenerateServiceTicketAction.doExecute(GenerateServiceTicketAction.java:37) > > org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:192) > > org.springframework.webflow.engine.AnnotatedAction.execute(AnnotatedAction.java:146) > > org.springframework.webflow.engine.ActionExecutor.execute(ActionExecutor.java:59) > > org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:156) > org.springframework.webflow.engine.State.enter(State.java:191) > > org.springframework.webflow.engine.Transition.execute(Transition.java:212) > > org.springframework.webflow.engine.DecisionState.doEnter(DecisionState.java:54) > org.springframework.webflow.engine.State.enter(State.java:191) > > org.springframework.webflow.engine.Transition.execute(Transition.java:212) > > org.springframework.webflow.engine.DecisionState.doEnter(DecisionState.java:54) > org.springframework.webflow.engine.State.enter(State.java:191) > > org.springframework.webflow.engine.Transition.execute(Transition.java:212) > > org.springframework.webflow.engine.DecisionState.doEnter(DecisionState.java:54) > org.springframework.webflow.engine.State.enter(State.java:191) > > org.springframework.webflow.engine.Transition.execute(Transition.java:212) > > org.springframework.webflow.engine.TransitionableState.onEvent(TransitionableState.java:107) > org.springframework.webflow.engine.Flow.onEvent(Flow.java:534) > > org.springframework.webflow.engine.impl.RequestControlContextImpl.signalEvent(RequestControlContextImpl.java:205) > > org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:161) > org.springframework.webflow.engine.State.enter(State.java:191) > org.springframework.webflow.engine.Flow.start(Flow.java:521) > > org.springframework.webflow.engine.impl.RequestControlContextImpl.start(RequestControlContextImpl.java:193) > > org.springframework.webflow.engine.impl.FlowExecutionImpl.start(FlowExecutionImpl.java:177) > > org.springframework.webflow.executor.FlowExecutorImpl.launch(FlowExecutorImpl.java:187) > > org.springframework.webflow.executor.support.FlowRequestHandler.handleFlowRequest(FlowRequestHandler.java:125) > > org.springframework.webflow.executor.mvc.FlowController.handleRequestInternal(FlowController.java:165) > > org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153) > > org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48) > > org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875) > > org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807) > > org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571) > > org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:501) > javax.servlet.http.HttpServlet.service(HttpServlet.java:617) > javax.servlet.http.HttpServlet.service(HttpServlet.java:717) > > org.jasig.cas.web.init.SafeDispatcherServlet.service(SafeDispatcherServlet.java:115) > > org.inspektr.common.web.ClientInfoThreadLocalFilter.doFilterInternal(ClientInfoThreadLocalFilter.java:48) > > org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) > > The database server is running MySql 5.0. > > The data type of the SERVICES_GRANTED_ACCESS_TO is already blob... what > can I do to work around / fix this problem? > > Thanks, > ~Craig > > > -- > 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 > -- 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
