Dear Lars, I have not encountered your issue, but I encountered a similar issue before (Not able to insert row to JDBC in another component)
I found that setting *autocommit *to *true *seems to fix my issue, not sure about the root cause since JDBC is not my strong suit. https://apereo.github.io/cas/6.3.x/configuration/Configuration-Properties-Common.html#database-settings Might not fix you issue, but you can try see if it helps. Cheers. - Andy On Thursday, 25 February 2021 at 22:06:15 UTC+8 Lars Feistner wrote: > Dear all, > > I am experirncing something weird. I set up Password Management, > pm-webflow and pm-jdbc. I turned off security questions. > > Everything works as expected. I can reset my password, get the email, > setting my new password after clicking the link in the email. But after a > successful message that I changed my password the value in the column in > the database is still the old one. > > I debugged the code, the update count was 1. I turned on debug logging for > spring. The log files says 'SQL update affected 1 rows'. > > I attached the log. > > It seems as if some kind of transaction is not commited or rolled back but > nothing appears in the log file. Can anyone think of anything that I missed? > > I am using cas version 5.3.16. > > 2021-02-25 14:59:19,007 DEBUG > [org.springframework.beans.factory.support.DefaultListableBeanFactory] - > <Returning cached instance of singleton bean 'passwordChangeAction'> > 2021-02-25 14:59:19,007 DEBUG > [org.apereo.cas.pm.web.flow.actions.PasswordChangeAction] - <Retrieved the > current credential from webflow [UsernamePasswordCredential(username=ucan)]> > 2021-02-25 14:59:19,007 DEBUG > [org.apereo.cas.pm.web.flow.actions.PasswordChangeAction] - <Attempting to > validate the provided password> > 2021-02-25 14:59:19,008 DEBUG > [org.apereo.cas.pm.web.flow.actions.PasswordChangeAction] - <Attempting to > update the password> > 2021-02-25 14:59:19,008 DEBUG > [org.apereo.cas.authentication.support.password.PasswordEncoderUtils] - > <Creating BCRYPT password encoder given the strength [14] and secret in the > configuration> > 2021-02-25 14:59:19,008 DEBUG > [org.apereo.cas.authentication.support.password.PasswordEncoderUtils] - > <Creating BCRYPT encoder without secret> > 2021-02-25 14:59:19,560 DEBUG > [org.springframework.core.env.PropertySourcesPropertyResolver] - <Could not > find key 'config.client.state' in any property source> > 2021-02-25 14:59:19,931 DEBUG [org.springframework.jdbc.core.JdbcTemplate] > - <Executing prepared SQL update> > 2021-02-25 14:59:19,932 DEBUG [org.springframework.jdbc.core.JdbcTemplate] > - <Executing prepared SQL statement [UPDATE cus_auth_method SET password=? > WHERE account_id=(SELECT id from cus_account where login = ?)]> > 2021-02-25 14:59:19,932 DEBUG > [org.springframework.jdbc.datasource.DataSourceUtils] - <Fetching JDBC > Connection from DataSource> > 2021-02-25 14:59:19,934 DEBUG [org.springframework.jdbc.core.JdbcTemplate] > - <SQL update affected 1 rows> > 2021-02-25 14:59:19,935 INFO > [org.apereo.inspektr.audit.support.Slf4jLoggingAuditTrailManager] - <Audit > trail record BEGIN > ============================================================= > WHO: audit:unknown > WHAT: UsernamePasswordCredential(username=ucan) > ACTION: CHANGE_PASSWORD_SUCCESS > APPLICATION: CAS > WHEN: Thu Feb 25 14:59:19 CET 2021 > CLIENT IP ADDRESS: 192.168.1.125 > SERVER IP ADDRESS: 192.168.1.199 > ============================================================= > > Best regards, > Lars > -- > *Lars Feistner* > Entwicklungsleitung > Phone: +49 6221/186749-5 > Mail: [email protected] > *Institut für Kommunikations- und Prüfungsforschung gGmbH* > Institute for Communication and Assessment Research > Wieblinger Weg 92a > 69123 Heidelberg, Germany > Web: www.ucan-assess.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 [email protected]. To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/dd8f1038-b331-412b-a57f-df3f3c7fff9fn%40apereo.org.
