Ray,
That was very helpful - thanks so much! I am familiar with the Hibernate
setting and was hoping I wouldn’t have to dig through the 4.2.2 source to find
a property.
The catalina.out was growing at a ridiculous rate logging all the SQL
statements…
Thanks,
Tom O’Neill
From: [email protected] [mailto:[email protected]] On Behalf Of Ray Bon
Sent: Wednesday, January 11, 2017 7:12 PM
To: [email protected]
Subject: Re: [cas-user] CAS 4.2.2 Hibernate catalina.out logging
Tom,
Set database.show.sql to false.
Ray
On 2017-01-11 15:49, Tom O'Neill wrote:
Hi All,
After recently deploying a CAS 4.2.2 instance, we noticed that there are
Hibernate statements getting logged to the catalina.out.
I reviewed the log4j.xml configuration and confirmed that the root logger is
set to ‘error’ and the org.hibernate entry was commented out (attached)
Here is an example of what we are seeing:
Hibernate: insert into SERVICETICKET (NUMBER_OF_TIMES_USED, CREATION_TIME,
EXPIRATION_POLICY, LAST_TIME_USED, PREVIOUS_LAST_TIME_USED,
ticketGrantingTicket_ID, FROM_NEW_LOGIN, TICKET_ALREADY_GRANTED, SERVICE, TYPE,
ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, 'ST', ?)
Hibernate: update TICKETGRANTINGTICKET set NUMBER_OF_TIMES_USED=?,
CREATION_TIME=?, EXPIRATION_POLICY=?, LAST_TIME_USED=?,
PREVIOUS_LAST_TIME_USED=?, ticketGrantingTicket_ID=?, AUTHENTICATION=?,
EXPIRED=?, PROXIED_BY=?, SERVICES_GRANTED_ACCESS_TO=?,
SUPPLEMENTAL_AUTHENTICATIONS=? where ID=?
I may be missing something obvious (hopefully) but would appreciate any
feedback.
Thanks!!
Tom O’Neill
--
- CAS gitter chatroom: https://gitter.im/apereo/cas
- CAS mailing list guidelines: https://apereo.github.io/cas/Mailing-Lists.html
- CAS documentation website: https://apereo.github.io/cas
- CAS project website: https://github.com/apereo/cas
---
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]<mailto:[email protected]>.
To view this discussion on the web visit
https://groups.google.com/a/apereo.org/d/msgid/cas-user/CY4PR02MB2773D37927C7CEA0ADE35E2BCB660%40CY4PR02MB2773.namprd02.prod.outlook.com<https://groups.google.com/a/apereo.org/d/msgid/cas-user/CY4PR02MB2773D37927C7CEA0ADE35E2BCB660%40CY4PR02MB2773.namprd02.prod.outlook.com?utm_medium=email&utm_source=footer>.
--
Ray Bon
Programmer Analyst
Development Services, University Systems
2507218831 | CLE C023 | [email protected]<mailto:[email protected]>
--
- CAS gitter chatroom: https://gitter.im/apereo/cas
- CAS mailing list guidelines: https://apereo.github.io/cas/Mailing-Lists.html
- CAS documentation website: https://apereo.github.io/cas
- CAS project website: https://github.com/apereo/cas
---
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]<mailto:[email protected]>.
To view this discussion on the web visit
https://groups.google.com/a/apereo.org/d/msgid/cas-user/043d7e6f-d3ab-ed25-6ebe-3710333685ef%40uvic.ca<https://groups.google.com/a/apereo.org/d/msgid/cas-user/043d7e6f-d3ab-ed25-6ebe-3710333685ef%40uvic.ca?utm_medium=email&utm_source=footer>.
--
- CAS gitter chatroom: https://gitter.im/apereo/cas
- CAS mailing list guidelines: https://apereo.github.io/cas/Mailing-Lists.html
- CAS documentation website: https://apereo.github.io/cas
- CAS project website: https://github.com/apereo/cas
---
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/CY4PR02MB277375A55E3E47D7088E5188CB790%40CY4PR02MB2773.namprd02.prod.outlook.com.
