Uploaded image for project: 'WildFly Elytron'
  1. WildFly Elytron
  2. ELY-1456

JDBC SecurityRealm executing single principal query multiple times.

    Details

    • Type: Bug
    • Status: Resolved (View Workflow)
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: 1.2.0.Beta10
    • Fix Version/s: 1.2.0.Beta11
    • Component/s: Realms
    • Labels:
      None

      Description

      Two same sql queries are performed on authentication attempt using jdbc-realm.

      2017-11-29T15:53:32.399596Z   338 Query select password from user where email = 'alberto@myapp.com'
      2017-11-29T15:53:32.400879Z   338 Query select role, 'Roles' from user_role_auth where email = 'alberto@myapp.com'
      2017-11-29T15:53:32.402531Z   338 Query select password from user where email = 'alberto@myapp.com'
      

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                dlofthouse Darran Lofthouse
                Reporter:
                mchoma Martin Choma
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: