I havent tried adding the lockver column On Wed, Mar 21, 2018 at 8:04 PM, rachepalli yashwanth kumar chowdary < [email protected]> wrote:
> 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 < >> [email protected]>: >> >>> 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/ap >> ereo.org/d/msgid/cas-user/CANidDKbR5pFLjS22haeMsGn6AuGkSXfFe >> %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/CAFBPyPRv4fx2Uo-NWiL-iL93gaz3D3TDFgad65EuRzwWPNj4OQ%40mail.gmail.com.
