JPA Ticket Registry

yashwanth chowdary

unread,

Mar 21, 2018, 9:12:42 AM3/21/18

to CAS Community

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

log1.PNG

log2.PNG

Uxío Prego

unread,

Mar 21, 2018, 9:47:54 AM3/21/18

to CAS Community

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.

--
- 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/3767a389-36b1-4fff-a502-13c3a9921451%40apereo.org.

Message has been deleted

rachepalli yashwanth kumar chowdary

unread,

Mar 21, 2018, 11:39:31 AM3/21/18

to cas-...@apereo.org

I havent tried adding the lockver column

On Wed, Mar 21, 2018 at 8:04 PM, rachepalli yashwanth kumar chowdary <ryashwanthk...@gmail.com> 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 <upr...@madiva.com> 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.

To unsubscribe from this group and stop receiving emails from it, send an email to cas-user+u...@apereo.org.

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.

--
- 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+u...@apereo.org.
To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/CANidDKbR5pFLjS22haeMsGn6AuGkSXfFe%2B%3DXeBxEDr%3DZyQLz4A%40mail.gmail.com.

rachepalli yashwanth kumar chowdary

unread,

Mar 21, 2018, 11:39:31 AM3/21/18

to cas-...@apereo.org

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 <upr...@madiva.com> 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.

To unsubscribe from this group and stop receiving emails from it, send an email to cas-user+u...@apereo.org.

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.

--
- 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/CANidDKbR5pFLjS22haeMsGn6AuGkSXfFe%2B%3DXeBxEDr%3DZyQLz4A%40mail.gmail.com.

Uxío Prego

unread,

Mar 21, 2018, 12:07:03 PM3/21/18

to CAS Community

When using Oracle and JPA you can upgrade CAS 3.4 to 3.x | x > 4 just by schema increases. I don't know if that is applicable to CAS 3 to 5, but I encourage you to research it. If so it might have a good outcome in the form of fewer needs of downtime or other convenient migration easing.

Good luck with the migration,

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 14:37 GMT+00:00 yashwanth chowdary <ryashwanthk...@gmail.com>:

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

To unsubscribe from this group and stop receiving emails from it, send an email to cas-user+u...@apereo.org.

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.

--
- 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/d4c81f7b-d5a9-4858-a00d-9ab873b216b3%40apereo.org.

Reply all

Reply to author

Forward