[
https://issues.jboss.org/browse/ELY-1456?page=com.atlassian.jira.plugin.s...
]
Darran Lofthouse commented on ELY-1456:
---------------------------------------
Generally for the sequence of calls during authentication we have a single RealmIdentity
instance triggering the queries, if there is no other bug identified where we are calling
a query we should not instead within the RealmIdentity we should be able to cache the
queries already executed for that identity and the result so it can be re-used in the
future. This may also help if a user defines multiple attributes backed by the same
query.
Two same SQL queries seen during one authentication attempt
------------------------------------------------------------
Key: ELY-1456
URL:
https://issues.jboss.org/browse/ELY-1456
Project: WildFly Elytron
Issue Type: Bug
Components: Realms
Affects Versions: 1.2.0.Beta10
Reporter: Martin Choma
Fix For: 1.2.0.Beta11
Two same sql queries are performed on authentication attempt using jdbc-realm.
{noformat}
2017-11-29T15:53:32.399596Z 338 Query select password from user where email =
'alberto(a)myapp.com'
2017-11-29T15:53:32.400879Z 338 Query select role, 'Roles' from user_role_auth
where email = 'alberto(a)myapp.com'
2017-11-29T15:53:32.402531Z 338 Query select password from user where email =
'alberto(a)myapp.com'
{noformat}
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)