[jboss-jira] [JBoss JIRA] (ELY-1456) JDBC SecurityRealm executing single principal query multiple times.

[Darran Lofthouse (JIRA)]

     [ https://issues.jboss.org/browse/ELY-1456?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Darran Lofthouse updated ELY-1456:
----------------------------------
    Summary: JDBC SecurityRealm executing single principal query multiple times.  (was: Two same SQL queries seen during one authentication attempt )


> JDBC SecurityRealm executing single principal query multiple times.
> -------------------------------------------------------------------
>
>                 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
>            Assignee: Darran Lofthouse
>            Priority: Critical
>             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 at myapp.com'
> 2017-11-29T15:53:32.400879Z   338 Query select role, 'Roles' from user_role_auth where email = 'alberto at myapp.com'
> 2017-11-29T15:53:32.402531Z   338 Query select password from user where email = 'alberto at myapp.com'
> {noformat}



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)