The default SQLAttributeFilter in OpenIG doesn’t handle result sets very well: it doesn’t allow to browse the results in any direction.
To workaround this problem, simply modify the following line in the SQLFilter source code, this way:
PreparedStatement ps = c.prepareStatement(preparedStatement,ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
The original code lies below:
PreparedStatement ps = c.prepareStatement(preparedStatement);
See this URL for full details ..
- New Keycloak online training - 19 janvier 2022
- Sizing Keycloak or Redhat SSO projects - 8 juin 2021
- Keycloak.X Distribution - 28 janvier 2021