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.
On Wed, Mar 21, 2018 at 7:17 PM, Uxío Prego <[email protected]> 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 > <https://maps.google.com/?q=CL+/+SERRANO+GALVACHE+56&entry=gmail&source=g> > 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 <ryashwanthkumarchowdary@ > gmail.com>: > >> 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]. >> To view this discussion on the web visit https://groups.google.com/a/ap >> ereo.org/d/msgid/cas-user/3767a389-36b1-4fff-a502-13c3a99214 >> 51%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/CANidDKbR5pFLjS22haeMsGn6AuGkS > XfFe%2B%3DXeBxEDr%3DZyQLz4A%40mail.gmail.com > <https://groups.google.com/a/apereo.org/d/msgid/cas-user/CANidDKbR5pFLjS22haeMsGn6AuGkSXfFe%2B%3DXeBxEDr%3DZyQLz4A%40mail.gmail.com?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/CAFBPyPTCU%3D%2B6SBB%3DxDTgwaSLKNKg2hiCJD4iqA-nOfc2tAeapQ%40mail.gmail.com.
