CAS 4.2.2 Hibernate catalina.out logging

[Tom O'Neill]

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

 

[Ray Bon]

Tom,

Set database.show.sql to false.

Ray

--
- 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 cas-user+u...@apereo.org.
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.

-- 
Ray Bon
Programmer Analyst
Development Services, University Systems
2507218831 | CLE C023 | rb...@uvic.ca

[Tom O'Neill]

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

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.