I actually tried that Jonathan and it solved some other problems that I was having earlier, but it hasn't fixed the issue that I having below.
On Wed, May 16, 2012 at 2:19 PM, Jonathan Windle < [email protected]> wrote: > Hello, > > You might try changing > > <prop > key="hibernate.dialect">org.hibernate.dialect.MySQLInnoDBDialect</prop> > > to > > <prop > key="hibernate.dialect">org.hibernate.dialect.MySQL5InnoDBDialect</prop> > > In the ticketRegistry.xml file. > > I also recently experienced some problems with CAS and MySQL 5 although > I was getting slightly different errors. Setting the correct dialect for > MySQL 5 fix my problem. > > Thanks, > Jonathan > > ------------------------------ > *From:* Karl Nielsen [[email protected]] > *Sent:* Wednesday, May 16, 2012 13:02 > *To:* [email protected] > *Subject:* [cas-user] Hibernate generated schema not liking the ticket > registry > > I have been following the End to end example on the wiki here: > https://wiki.jasig.org/display/CASUM/End-to-end+Windows+Example and the > JpaTicketRegistry https://wiki.jasig.org/display/CASUM/JpaTicketRegistry > > I am using MySQL 5 > > I have upgraded things to use the 3.4.12 release of CAS > > When I go to test my login I get this error thrown. Any idea as to why? > > Hibernate: > insert > into > casadm.SERVICETICKET > (NUMBER_OF_TIMES_USED, CREATION_TIME, EXPIRATION_POLICY, > LAST_TIME_USED, PREVIOUS_LAST_TIME_USED, ticketGrantingTicket_ID, > FROM_NEW_LOGIN, TICKET_ALREADY_GRANTED, SERVICE, ID) > values > (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) > 2012-05-16 13:53:51,373 ERROR [org.hibernate.util.JDBCExceptionReporter] - > <Cannot add or update a child row: a foreign key constraint fails > (`casadm`.`serviceticket`, CONSTRAINT `FK7645ADE132A2C0E5` FOREIGN KEY > (`ticketGrantingTicket_ID`) REFERENCES `TICKETGRANTINGTICKET` (`ID`))> > 2012-05-16 13:53:51,374 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:96) > at > org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) > at > org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275) > at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263) > at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:179) > at > org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321) > at > org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51) > at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1206) > at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:375) > at > org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137) > at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:76) > at > org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:467) > at > org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:754) > at > org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:723) > at > org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:393) > at > org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:120) > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) > at > org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89) > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) > at > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) > at $Proxy68.grantServiceTicket(Unknown Source) > at > org.jasig.cas.web.flow.GenerateServiceTicketAction.doExecute(GenerateServiceTicketAction.java:39) > at > org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:188) > at > org.springframework.webflow.execution.ActionExecutor.execute(ActionExecutor.java:51) > at > org.springframework.webflow.action.EvaluateAction.doExecute(EvaluateAction.java:77) > at > org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:188) > at > org.springframework.webflow.execution.AnnotatedAction.execute(AnnotatedAction.java:145) > at > org.springframework.webflow.execution.ActionExecutor.execute(ActionExecutor.java:51) > at > org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:101) > at org.springframework.webflow.engine.State.enter(State.java:194) > at > org.springframework.webflow.engine.Transition.execute(Transition.java:227) > at > org.springframework.webflow.engine.DecisionState.doEnter(DecisionState.java:51) > at org.springframework.webflow.engine.State.enter(State.java:194) > at > org.springframework.webflow.engine.Transition.execute(Transition.java:227) > at > org.springframework.webflow.engine.impl.FlowExecutionImpl.execute(FlowExecutionImpl.java:391) > at > org.springframework.webflow.engine.impl.RequestControlContextImpl.execute(RequestControlContextImpl.java:214) > at > org.springframework.webflow.engine.TransitionableState.handleEvent(TransitionableState.java:119) > at org.springframework.webflow.engine.Flow.handleEvent(Flow.java:555) > at > org.springframework.webflow.engine.impl.FlowExecutionImpl.handleEvent(FlowExecutionImpl.java:386) > at > org.springframework.webflow.engine.impl.RequestControlContextImpl.handleEvent(RequestControlContextImpl.java:210) > at > org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:105) > at org.springframework.webflow.engine.State.enter(State.java:194) > at > org.springframework.webflow.engine.Transition.execute(Transition.java:227) > at > org.springframework.webflow.engine.impl.FlowExecutionImpl.execute(FlowExecutionImpl.java:391) > at > org.springframework.webflow.engine.impl.RequestControlContextImpl.execute(RequestControlContextImpl.java:214) > at > org.springframework.webflow.engine.TransitionableState.handleEvent(TransitionableState.java:119) > at org.springframework.webflow.engine.Flow.handleEvent(Flow.java:555) > at > org.springframework.webflow.engine.impl.FlowExecutionImpl.handleEvent(FlowExecutionImpl.java:386) > at > org.springframework.webflow.engine.impl.RequestControlContextImpl.handleEvent(RequestControlContextImpl.java:210) > at > org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:105) > at org.springframework.webflow.engine.State.enter(State.java:194) > at > org.springframework.webflow.engine.Transition.execute(Transition.java:227) > at > org.springframework.webflow.engine.impl.FlowExecutionImpl.execute(FlowExecutionImpl.java:391) > at > org.springframework.webflow.engine.impl.RequestControlContextImpl.execute(RequestControlContextImpl.java:214) > at > org.springframework.webflow.engine.TransitionableState.handleEvent(TransitionableState.java:119) > at org.springframework.webflow.engine.Flow.handleEvent(Flow.java:555) > at > org.springframework.webflow.engine.impl.FlowExecutionImpl.handleEvent(FlowExecutionImpl.java:386) > at > org.springframework.webflow.engine.impl.RequestControlContextImpl.handleEvent(RequestControlContextImpl.java:210) > at > org.springframework.webflow.engine.ViewState.handleEvent(ViewState.java:254) > at org.springframework.webflow.engine.ViewState.resume(ViewState.java:218) > at org.springframework.webflow.engine.Flow.resume(Flow.java:545) > at > org.springframework.webflow.engine.impl.FlowExecutionImpl.resume(FlowExecutionImpl.java:259) > at > org.springframework.webflow.executor.FlowExecutorImpl.resumeExecution(FlowExecutorImpl.java:169) > at > org.springframework.webflow.mvc.servlet.FlowHandlerAdapter.handle(FlowHandlerAdapter.java:183) > at > org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790) > at > org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719) > at > org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644) > at > org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:560) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:641) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) > at > org.jasig.cas.web.init.SafeDispatcherServlet.service_aroundBody2(SafeDispatcherServlet.java:115) > at > org.jasig.cas.web.init.SafeDispatcherServlet.service_aroundBody3$advice(SafeDispatcherServlet.java:44) > at > org.jasig.cas.web.init.SafeDispatcherServlet.service(SafeDispatcherServlet.java:1) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) > at > com.github.inspektr.common.web.ClientInfoThreadLocalFilter.doFilter(ClientInfoThreadLocalFilter.java:63) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) > at > org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) > at > org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) > at > org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237) > at > org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) > at > org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) > at > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) > at > org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:999) > at > org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:565) > at > org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309) > 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:680) > Caused by: java.sql.BatchUpdateException: Cannot add or update a child > row: a foreign key constraint fails (`casadm`.`serviceticket`, CONSTRAINT > `FK7645ADE132A2C0E5` FOREIGN KEY (`ticketGrantingTicket_ID`) REFERENCES > `TICKETGRANTINGTICKET` (`ID`)) > at > com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2035) > at > com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1458) > at > org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70) > at > org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268) > ... 95 more > Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: > Cannot add or update a child row: a foreign key constraint fails > (`casadm`.`serviceticket`, CONSTRAINT `FK7645ADE132A2C0E5` FOREIGN KEY > (`ticketGrantingTicket_ID`) REFERENCES `TICKETGRANTINGTICKET` (`ID`)) > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) > at java.lang.reflect.Constructor.newInstance(Constructor.java:513) > at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) > at com.mysql.jdbc.Util.getInstance(Util.java:386) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1039) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4098) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4030) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2677) > at > com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2134) > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2434) > at > com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1987) > ... 98 more > > -- > 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 > > -- 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
