In line with the error message, it can hopefully be tackled by rewriting the schema LOCKS.LOCKVER as integer.
I would issue ALTER TABLE <SCHEMA>.LOCKS MODIFY LOCKVER NUMBER(19, 0); Best, Uxío Prego Madiva Soluciones CL / SERRANO GALVACHE 56 BLOQUE ABEDUL PLANTA 4 28033 MADRID +34 917 56 84 94 www.madiva.com www.bbva.com The activity of email inboxes can be systematically tracked by colleagues, business partners and third parties. Turn off automatic loading of images to hamper it. 2018-03-29 6:09 GMT+00:00 yashwanth chowdary < [email protected]>: > My Properties: > > > cas.ticket.registry.jpa.dialect=org.hibernate.dialect.Oracle10gDialect > cas.ticket.registry.jpa.url=********* > cas.ticket.registry.jpa.driverClass=oracle.jdbc.driver.OracleDriver > cas.ticket.registry.jpa.user=********* > cas.ticket.registry.jpa.password=******** > cas.ticket.registry.jpa.ddlAuto=validate > cas.ticket.registry.jpa.defaultSchema=**** > cas.ticket.registry.jpa.batchSize=1 > cas.ticket.registry.jpa.healthQuery=SELECT 1 FROM DUAL > > Dependency in pom: > > > <dependency> > <groupId>org.apereo.cas</groupId> > <artifactId>cas-server-support-jpa-ticket-registry</artifactId> > <version>5.3.0-RC2</version> > </dependency> > > Getting an sql exception on locks table, you can find the logs in the > screenshots attached. > > As Definitions of the tables have been changed please provide the > structure or scripts for the tables > > -- > - Website: https://apereo.github.io/cas > - Gitter Chatroom: https://gitter.im/apereo/cas > - List Guidelines: https://goo.gl/1VRrw7 > - Contributions: https://goo.gl/mh7qDG > --- > You received this message because you are subscribed to the Google Groups > "CAS Community" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit https://groups.google.com/a/ > apereo.org/d/msgid/cas-user/6223302a-d936-4058-9f3e- > 89bfaae39dcd%40apereo.org > <https://groups.google.com/a/apereo.org/d/msgid/cas-user/6223302a-d936-4058-9f3e-89bfaae39dcd%40apereo.org?utm_medium=email&utm_source=footer> > . > -- - Website: https://apereo.github.io/cas - Gitter Chatroom: https://gitter.im/apereo/cas - List Guidelines: https://goo.gl/1VRrw7 - Contributions: https://goo.gl/mh7qDG --- You received this message because you are subscribed to the Google Groups "CAS Community" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/CANidDKYFUxazDd-SQ1x29C6CeTnqEBH3ghYN5-qHB3dcYs%3DvkQ%40mail.gmail.com.
