I recently set up a JDBC attributeRepository and my SQL query expects the
username passed from CAS to be lowercase. Does anyone know how to either
override the "WHERE {0}" or make sure the username being passed is
lowercase?
The problem we have is people entering their username in mixed case like
"UserName" instead of "username" and "UserName" is being passed to the
"SELECT * FROM user_table WHERE {0}"
>From the logs:
DEBUG
[org.apereo.services.persondir.support.jdbc.SingleRowJdbcPersonAttributeDao]
- <Generated query builder 'sql=[username = ?] args=[UserName]' from query
Map {username=[UserName]}.>
--
- 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/cec07f47-18f4-44da-b0f1-089bc7008335n%40apereo.org.
