Paged queries not supported in oracle db

[sjsong]

hello. I am testing your singular-keycloak-database-federation program.

but I am failing to import users with the error message below.

java.lang.UnsupportedOperationException: Paged queries not supported by org.hibernate.dialect.pagination.Oracle12LimitHandler

Keycloak 24.0.5
java 17

How do I fix it?

thank you.

[sjsong]

I solve this Error.

first. PagingUtil.java modify

    } catch (SQLException e) {
        throw new DBUserStorageException(e.getMessage(), e);
    } catch (UnsupportedOperationException e) {
        // LimitHandler not support Pagination 
       // resolve ManualPagination
        return applyManualPagination(query, pageable);
    }

2. modify other code

private static String replaceQuestionMarks(String query, Map<Integer, Object> parameters) {
StringBuilder processedSQL = new StringBuilder(query);
for (int i = 1; i <= parameters.size(); i++) {
Matcher matcher = SINGLE_QUESTION_MARK_REGEX.matcher(processedSQL);
if (matcher.find()) {
String str = String.valueOf(parameters.get(i));
processedSQL.replace(matcher.start(2), matcher.end(2), str);
}
}
return processedSQL.toString();
}

private static String applyManualPagination(String query, Pageable pageable) {
    int offset = pageable.firstResult;
    int limit = pageable.maxResults;

    return "SELECT * FROM (SELECT a.*, ROWNUM rnum FROM (" + query + ") a WHERE ROWNUM <= " + (offset + limit) +
            ") WHERE rnum > " + offset;
}