Insert into TICKETGRANTINGTICKET not working

[Robert James]

Hello,

I've been having issues with getting my MSSQL JPA Ticket Registry to work properly with CAS 4.2.x. I can authenticate as a user, however I am then redirected to the 'CAS is unavailable' screen. 

Here below is a snippet of the log file where I can see the error occur (I've updated the log4j file to output more than usual):

2017-11-14 14:38:11,832 DEBUG [org.hibernate.SQL] - insert into TICKETGRANTINGTICKET (NUMBER_OF_TIMES_USED, CREATION_TIME, EXPIRATION_POLICY, LAST_TIME_USED, PREVIOUS_LAST_TIME_USED, ticketGrantingTicket_ID, AUTHENTICATION, EXPIRED, PROXIED_BY, SERVICES_GRANTED_ACCESS_TO, SUPPLEMENTAL_AUTHENTICATIONS, TYPE, ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'TGT', ?)

2017-11-14 14:38:11,926 DEBUG [org.hibernate.engine.transaction.internal.TransactionImpl] - rolling back

2017-11-14 14:38:11,929 DEBUG [org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl] - HHH000420: Closing un-released batch

2017-11-14 14:38:11,929 INFO [org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl] - HHH000010: On release of batch it still contained JDBC statements

2017-11-14 14:38:11,932 ERROR [org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl] - HHH000352: Unable to release batch statement...

2017-11-14 14:38:11,933 DEBUG [org.hibernate.resource.jdbc.internal.ResourceRegistryStandardImpl] - HHH000387: ResultSet's statement was not registered

2017-11-14 14:38:11,934 DEBUG [org.hibernate.resource.jdbc.internal.ResourceRegistryStandardImpl] - Exception clearing maxRows/queryTimeout [You can't operate on a closed Statement!!!]

2017-11-14 14:38:11,934 DEBUG [org.springframework.webflow.execution.AnnotatedAction] - Clearing action execution attributes map[[empty]]

2017-11-14 14:38:11,935 DEBUG [org.springframework.webflow.engine.impl.FlowExecutionImpl] - Attempting to handle [org.springframework.webflow.execution.ActionExecutionException: Exception thrown executing [AnnotatedAction@32b9e0ee targetAction = [EvaluateAction@26479ad0 expression = authenticationViaFormAction.submit(flowRequestContext, flowScope.credential, messageContext), resultExpression = [null]], attributes = map[[empty]]] in state 'realSubmit' of flow 'login' -- action execution attributes were 'map[[empty]]'] with root cause [java.lang.AbstractMethodError]

2017-11-14 14:38:11,935 DEBUG [org.springframework.webflow.engine.impl.FlowExecutionImpl] - Rethrowing unhandled flow execution exception

2017-11-14 14:38:11,935 TRACE [org.jasig.cas.web.FlowExecutionExceptionResolver] - Entering method [resolveException] with arguments [[org.apache.catalina.connector.RequestFacade@296ae340, org.apache.catalina.connector.ResponseFacade@59ff0df8, [FlowHandlerMapping.DefaultFlowHandler@d85db66], org.springframework.webflow.execution.ActionExecutionException: Exception thrown executing [AnnotatedAction@32b9e0ee targetAction = [EvaluateAction@26479ad0 expression = authenticationViaFormAction.submit(flowRequestContext, flowScope.credential, messageContext), resultExpression = [null]], attributes = map[[empty]]] in state 'realSubmit' of flow 'login' -- action execution attributes were 'map[[empty]]']]

2017-11-14 14:38:11,936 DEBUG [org.jasig.cas.web.FlowExecutionExceptionResolver] - Ignoring the received exception due to a type mismatch

org.springframework.webflow.execution.ActionExecutionException: Exception thrown executing [AnnotatedAction@32b9e0ee targetAction = [EvaluateAction@26479ad0 expression = authenticationViaFormAction.submit(flowRequestContext, flowScope.credential, messageContext), resultExpression = [null]], attributes = map[[empty]]] in state 'realSubmit' of flow 'login' -- action execution attributes were 'map[[empty]]'

at org.springframework.webflow.execution.ActionExecutor.execute(ActionExecutor.java:60)

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:228)

at org.springframework.webflow.engine.impl.FlowExecutionImpl.execute(FlowExecutionImpl.java:395)

at org.springframework.webflow.engine.impl.RequestControlContextImpl.execute(RequestControlContextImpl.java:214)

at org.springframework.webflow.engine.TransitionableState.handleEvent(TransitionableState.java:116)

at org.springframework.webflow.engine.Flow.handleEvent(Flow.java:547)

at org.springframework.webflow.engine.impl.FlowExecutionImpl.handleEvent(FlowExecutionImpl.java:390)

at org.springframework.webflow.engine.impl.RequestControlContextImpl.handleEvent(RequestControlContextImpl.java:210)

at org.springframework.webflow.engine.ViewState.handleEvent(ViewState.java:231)

at org.springframework.webflow.engine.ViewState.resume(ViewState.java:195)

at org.springframework.webflow.engine.Flow.resume(Flow.java:537)

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:228)

at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959)

at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893)

at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)

at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)

at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)

at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)

at org.jasig.cas.security.ResponseHeadersEnforcementFilter.doFilter(ResponseHeadersEnforcementFilter.java:227)

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)

at org.jasig.cas.security.RequestParameterPolicyEnforcementFilter.doFilter(RequestParameterPolicyEnforcementFilter.java:250)

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)

at org.jasig.inspektr.common.web.ClientInfoThreadLocalFilter.doFilter(ClientInfoThreadLocalFilter.java:62)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)

at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:121)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:108)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)

at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349)

at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:784)

at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)

at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:802)

at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1452)

at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Thread.java:745)

Caused by: org.springframework.expression.ExpressionInvocationTargetException: A problem occurred when trying to execute method 'submit' on object of type [org.jasig.cas.web.flow.AuthenticationViaFormAction]

at org.springframework.expression.spel.ast.MethodReference.throwSimpleExceptionIfPossible(MethodReference.java:227)

at org.springframework.expression.spel.ast.MethodReference.getValueInternal(MethodReference.java:133)

at org.springframework.expression.spel.ast.MethodReference.access$000(MethodReference.java:49)

at org.springframework.expression.spel.ast.MethodReference$MethodValueRef.getValue(MethodReference.java:342)

at org.springframework.expression.spel.ast.CompoundExpression.getValueInternal(CompoundExpression.java:88)

at org.springframework.expression.spel.ast.SpelNodeImpl.getTypedValue(SpelNodeImpl.java:131)

at org.springframework.expression.spel.standard.SpelExpression.getValue(SpelExpression.java:299)

at org.springframework.binding.expression.spel.SpringELExpression.getValue(SpringELExpression.java:84)

at org.springframework.webflow.action.EvaluateAction.doExecute(EvaluateAction.java:75)

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)

... 63 more

Caused by: java.lang.AbstractMethodError

at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.setBinaryStream(JtdsPreparedStatement.java:1234)

at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.setBinaryStream(NewProxyPreparedStatement.java:722)

at org.hibernate.type.descriptor.sql.BlobTypeDescriptor$5$1.doBind(BlobTypeDescriptor.java:130)

at org.hibernate.type.descriptor.sql.BlobTypeDescriptor$2$1.doBind(BlobTypeDescriptor.java:86)

at org.hibernate.type.descriptor.sql.BasicBinder.bind(BasicBinder.java:73)

at org.hibernate.type.AbstractStandardBasicType.nullSafeSet(AbstractStandardBasicType.java:260)

at org.hibernate.type.AbstractStandardBasicType.nullSafeSet(AbstractStandardBasicType.java:255)

at org.hibernate.type.AbstractSingleColumnStandardBasicType.nullSafeSet(AbstractSingleColumnStandardBasicType.java:39)

at org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:2597)

at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2881)

at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3384)

at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:89)

at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:451)

at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:336)

at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:335)

at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39)

at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1224)

at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:464)

at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:2905)

at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2281)

at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:485)

at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:146)

at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$100(JdbcResourceLocalTransactionCoordinatorImpl.java:38)

at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:230)

at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:65)

at org.hibernate.jpa.internal.TransactionImpl.commit(TransactionImpl.java:61)

at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:517)

at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:761)

at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:730)

at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:485)

at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:291)

at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)

at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)

at com.ryantenney.metrics.spring.MeteredMethodInterceptor.invoke(MeteredMethodInterceptor.java:45)

at com.ryantenney.metrics.spring.MeteredMethodInterceptor.invoke(MeteredMethodInterceptor.java:32)

at com.ryantenney.metrics.spring.AbstractMetricMethodInterceptor.invoke(AbstractMetricMethodInterceptor.java:59)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)

at com.ryantenney.metrics.spring.TimedMethodInterceptor.invoke(TimedMethodInterceptor.java:48)

at com.ryantenney.metrics.spring.TimedMethodInterceptor.invoke(TimedMethodInterceptor.java:34)

at com.ryantenney.metrics.spring.AbstractMetricMethodInterceptor.invoke(AbstractMetricMethodInterceptor.java:59)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)

at com.ryantenney.metrics.spring.CountedMethodInterceptor.invoke(CountedMethodInterceptor.java:46)

at com.ryantenney.metrics.spring.CountedMethodInterceptor.invoke(CountedMethodInterceptor.java:32)

at com.ryantenney.metrics.spring.AbstractMetricMethodInterceptor.invoke(AbstractMetricMethodInterceptor.java:59)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)

at com.sun.proxy.$Proxy78.createTicketGrantingTicket(Unknown Source)

at org.jasig.cas.web.flow.AuthenticationViaFormAction.createTicketGrantingTicket(AuthenticationViaFormAction.java:205)

at org.jasig.cas.web.flow.AuthenticationViaFormAction.submit_aroundBody0(AuthenticationViaFormAction.java:96)

at org.jasig.cas.web.flow.AuthenticationViaFormAction$AjcClosure1.run(AuthenticationViaFormAction.java:1)

at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149)

at org.jasig.inspektr.aspect.TraceLogAspect.traceMethod(TraceLogAspect.java:44)

at org.jasig.cas.web.flow.AuthenticationViaFormAction.submit(AuthenticationViaFormAction.java:86)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at org.springframework.expression.spel.support.ReflectiveMethodExecutor.execute(ReflectiveMethodExecutor.java:113)

at org.springframework.expression.spel.ast.MethodReference.getValueInternal(MethodReference.java:129)

... 73 more

Here is my TicketRegistry.xml settings:

<?xml version="1.0" encoding="UTF-8"?>

<!--

    Licensed to Apereo under one or more contributor license

    agreements. See the NOTICE file distributed with this work

    for additional information regarding copyright ownership.

    Apereo licenses this file to you under the Apache License,

    Version 2.0 (the "License"); you may not use this file

    except in compliance with the License.  You may obtain a

    copy of the License at the following location:

      http://www.apache.org/licenses/LICENSE-2.0

    Unless required by applicable law or agreed to in writing,

    software distributed under the License is distributed on an

    "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY

    KIND, either express or implied.  See the License for the

    specific language governing permissions and limitations

    under the License.

-->

<beans xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

       xmlns:p="http://www.springframework.org/schema/p"

       xmlns:c="http://www.springframework.org/schema/c"

       xmlns="http://www.springframework.org/schema/beans"

       xmlns:util="http://www.springframework.org/schema/util"

       xmlns:tx="http://www.springframework.org/schema/tx"

       xmlns:aop="http://www.springframework.org/schema/aop"

       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd">

    <description>

        Configuration for the default TicketRegistry which stores the tickets in database and cleans them out as specified

        intervals.

    </description>

    <bean

            id="dataSource"

            class="com.mchange.v2.c3p0.ComboPooledDataSource"

            p:driverClass="${database.driverClass:net.sourceforge.jtds.jdbc.Driver}"

            p:jdbcUrl="${database.url:jdbc:jtds:sqlserver://MSSQLserver}"

            p:user="${database.user:USERNAME}"

            p:password="${database.password:PASSWORD}"

            p:initialPoolSize="${database.pool.minSize:6}"

            p:minPoolSize="${database.pool.minSize:6}"

            p:maxPoolSize="${database.pool.maxSize:18}"

            p:maxIdleTimeExcessConnections="${database.pool.maxIdleTime:1000}"

            p:checkoutTimeout="${database.pool.maxWait:2000}"

            p:acquireIncrement="${database.pool.acquireIncrement:16}"

            p:acquireRetryAttempts="${database.pool.acquireRetryAttempts:5}"

            p:acquireRetryDelay="${database.pool.acquireRetryDelay:2000}"

            p:idleConnectionTestPeriod="${database.pool.idleConnectionTestPeriod:30}"

            p:preferredTestQuery="${database.pool.connectionHealthQuery:select 1}"

            />

    <!-- Ticket Registry -->

    <bean id="ticketRegistry" class="org.jasig.cas.ticket.registry.JpaTicketRegistry" />

    <bean class="org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor"/>

    <util:list id="packagesToScan">

        <value>org.jasig.cas.ticket</value>

        <value>org.jasig.cas.adaptors.jdbc</value>

    </util:list>

    <bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter"

          id="jpaVendorAdapter"

          p:generateDdl="true"

          p:showSql="true" />

    <bean id="entityManagerFactory"

          class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean"

          p:dataSource-ref="dataSource"

          p:jpaVendorAdapter-ref="jpaVendorAdapter"

          p:packagesToScan-ref="packagesToScan">

        <property name="jpaProperties">

            <props>

                <prop key="hibernate.dialect">${database.dialect:org.hibernate.dialect.SQLServer2012Dialect}</prop>

                <prop key="hibernate.hbm2ddl.auto">create-drop</prop>

                <prop key="hibernate.jdbc.batch_size">${database.batchSize:1}</prop>

            </props>

        </property>

    </bean>

    <bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager"

          p:entityManagerFactory-ref="entityManagerFactory" />

    <tx:advice id="txAdvice" transaction-manager="transactionManager">

        <tx:attributes>

            <tx:method name="delete*" read-only="false"/>

            <tx:method name="save*" read-only="false"/>

            <tx:method name="update*" read-only="false"/>

            <tx:method name="get*" read-only="true"/>

            <tx:method name="*" />

        </tx:attributes>

    </tx:advice>

    <aop:config>

        <aop:pointcut id="ticketRegistryOperations" expression="execution(* org.jasig.cas.ticket.registry.JpaTicketRegistry.*(..))"/>

        <aop:pointcut id="ticketRegistryLockingOperations" expression="execution(* org.jasig.cas.ticket.registry.support.JpaLockingStrategy.*(..))"/>

        <aop:advisor advice-ref="txAdvice" pointcut-ref="ticketRegistryOperations"/>

        <aop:advisor advice-ref="txAdvice" pointcut-ref="ticketRegistryLockingOperations"/>

    </aop:config>

</beans>

Also the updated configurations in the cas.properties file:

##

# JPA Ticket Registry Database Configuration

#

 

 ticketreg.database.ddl.auto=create-drop

 ticketreg.database.dialect=org.hibernate.dialect.SQLServer2012Dialect

 ticketreg.database.batchSize=10

 ticketreg.database.driverClass=net.sourceforge.jtds.jdbc.Driver

 ticketreg.database.url=jdbc:jtds:sqlserver://SQLSERVERURL

 ticketreg.database.user=XXX

 ticketreg.database.password=XXX

 ticketreg.database.pool.minSize=6

 ticketreg.database.pool.maxSize=18

 ticketreg.database.pool.maxWait=10000

 ticketreg.database.pool.maxIdleTime=120

 ticketreg.database.pool.acquireIncrement=6

 ticketreg.database.pool.idleConnectionTestPeriod=30

 ticketreg.database.pool.acquireRetryAttempts=5

 ticketreg.database.pool.acquireRetryDelay=2000

 ticketreg.database.pool.connectionHealthQuery=select 1

Has anyone else experienced this issue. It seems the insert statement is causing some underlying issue that I am unable to see via debugging in the logger.

Any assistance would be GREATLY appreciated.

Thanks in advance.