Manfredo, Hibernate is not posting to my logs. Turned on cas.jdbc.showSql and cas.jdbc.genDdl. Also added org.hibernate, org.hibernate.SQL and org.hibernate.type.descriptor.sql to the log4j2.xml for both debug and trace. Nothing.
This is built using Maven and our own Tomcat server. Bill On Saturday, February 24, 2018 at 3:28:23 PM UTC-5, Manfredo Hopp wrote: > > Send the same with hibernate debug > > El sábado, 24 de febrero de 2018, William Jojo <[email protected] > <javascript:>> escribió: > >> My question is very simple. Why on Earth are there two separate calls for >> validating PM questions? There is a query to get the question(s) followed >> by what seems like another query to get the answer(s). The format requires >> the query to be in the form of: >> >> select question, answer from table name where user=? >> >> Fine. But if you are trying to randomly select a question with say a view >> or procedure, the functionality is effective broken because you cannot >> guarantee the question/answer pair will match. See below: >> >> 2018-02-24 12:26:56,529 DEBUG >> [org.springframework.jdbc.datasource.DataSourceUtils] - <Fetching JDBC >> Connection from DataSource> >> 2018-02-24 12:26:56,546 TRACE >> [org.springframework.jdbc.core.StatementCreatorUtils] - <Setting SQL >> statement parameter value: column index 1, parameter value [THEUSER], value >> class [java.lang.String], SQL type unknown> >> 2018-02-24 12:26:56,562 DEBUG >> [org.springframework.jdbc.datasource.DataSourceUtils] - <Returning JDBC >> Connection to DataSource> >> 2018-02-24 12:26:56,563 DEBUG >> [org.apereo.cas.pm.jdbc.JdbcPasswordManagementService] - <Found [1] >> security questions for [THEUSER]> >> >> 2018-02-24 12:26:59,489 DEBUG >> [org.springframework.jdbc.core.JdbcTemplate] - <Executing prepared SQL >> query> >> 2018-02-24 12:26:59,490 DEBUG >> [org.springframework.jdbc.core.JdbcTemplate] - <Executing prepared SQL >> statement [SELECT question,answer from GENERAL.vTestQA where userid=?]> >> 2018-02-24 12:26:59,490 DEBUG >> [org.springframework.jdbc.datasource.DataSourceUtils] - <Fetching JDBC >> Connection from DataSource> >> 2018-02-24 12:26:59,506 TRACE >> [org.springframework.jdbc.core.StatementCreatorUtils] - <Setting SQL >> statement parameter value: column index 1, parameter value [THEUSER], value >> class [java.lang.String], SQL type unknown> >> 2018-02-24 12:26:59,523 DEBUG >> [org.springframework.jdbc.datasource.DataSourceUtils] - <Returning JDBC >> Connection to DataSource> >> 2018-02-24 12:26:59,523 DEBUG >> [org.apereo.cas.pm.jdbc.JdbcPasswordManagementService] - <Found [1] >> security questions for [THEUSER]> >> >> >> There is also the concern that the database is not required to return the >> values in the same order every time. >> >> Bill >> >> -- >> - 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] <javascript:>. >> To view this discussion on the web visit >> https://groups.google.com/a/apereo.org/d/msgid/cas-user/6a6e6fab-f5c3-4c98-8a92-72079c0cc412%40apereo.org >> >> <https://groups.google.com/a/apereo.org/d/msgid/cas-user/6a6e6fab-f5c3-4c98-8a92-72079c0cc412%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/apereo.org/d/msgid/cas-user/32e639e7-28d9-436e-a744-416287d15489%40apereo.org.
