Hi Prego, we are migrating from cas3.5 to cas 5.3.0 , whatever the scheema we have for cas3.5 contains locks but it doesnt contain lockver column, what i need to know is, Is structure for locks is changed in cas 5.3 version or for the other tables too.what is struture of the tables i need to maintain in my scheema. As we have to raise a request to change our db, if i have structure of the tables i can request them to change the tables at a time.
I havent tried changing the db On Wednesday, March 21, 2018 at 7:17:54 PM UTC+5:30, Uxío Prego wrote: > > Do you need to support CAS 3 and 5 at the same time for a while, or can > you afford a *migration*? Can you afford CAS downtime when migrating the > users to CAS 5? Have you tried to add LOCKVER to CAS_OWN.LOCKS? > > 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-21 13:12 GMT+00:00 yashwanth chowdary <[email protected] > <javascript:>>: > >> For Jpa ticket registry these are the properties i was using: >> >> cas.ticket.registry.jpa.dialect=org.hibernate.dialect.Oracle10gDialect >> cas.ticket.registry.jpa.url=XXXXXXXX >> cas.ticket.registry.jpa.driverClass=oracle.jdbc.driver.OracleDriver >> cas.ticket.registry.jpa.user=xxxxxx >> cas.ticket.registry.jpa.password=xxxxx >> cas.ticket.registry.jpa.ddlAuto=validate >> cas.ticket.registry.jpa.defaultSchema=xxxxx >> cas.ticket.registry.jpa.batchSize=1 >> cas.ticket.registry.jpa.healthQuery=SELECT 1 FROM DUAL >> >> My schema tables >> locks,tgt,rs_attributes,serviceticket,registeredticketimpl are structured >> in such a way that they support cas3.5 version.Is there any change in >> structure of tables >> >> Dependencies: >> <dependency> >> <groupId>org.apereo.cas</groupId> >> <artifactId>cas-server-support-jpa-ticket-registry</artifactId> >> <version>5.3.0-RC2</version> >> </dependency> >> <dependency> >> <groupId>com.oracle</groupId> >> <artifactId>ojdbc6</artifactId> >> <version>11.2.0.1.0</version> >> </dependency> >> >> And when i try to run the cas application observing these issues >> unsatisfied dependency exception,unable to create hibernate session >> factory,.. You can observe the logs in below attached files >> >> -- >> - 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] <javascript:>. >> To view this discussion on the web visit >> https://groups.google.com/a/apereo.org/d/msgid/cas-user/3767a389-36b1-4fff-a502-13c3a9921451%40apereo.org >> >> <https://groups.google.com/a/apereo.org/d/msgid/cas-user/3767a389-36b1-4fff-a502-13c3a9921451%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/d4c81f7b-d5a9-4858-a00d-9ab873b216b3%40apereo.org.
