JPA Ticket Registry

[yashwanth chowdary]

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

[Uxío Prego]

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.

--
- 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 cas-user+unsubscribe@apereo.org.
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.