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] -- - 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/043d7e6f-d3ab-ed25-6ebe-3710333685ef%40uvic.ca.
