_paramPlaceHolderName = putParamPlaceHolder(_paramPlaceHolders, attribute.getKey()); attributeConstraint = " a" + cnt + ".PRINCIPAL_ID=SECURITY_PRINCIPAL.PRINCIPAL_ID AND a" + cnt + ".ATTR_NAME = " + _paramPlaceHolderName; _paramPlaceHolderName = putParamPlaceHolder(_paramPlaceHolders, convertWildcardsForLike(attribute.getValue())); attributeConstraint += " AND a" + cnt + ".ATTR_VALUE LIKE " + _paramPlaceHolderName; } else { _paramPlaceHolderName = putParamPlaceHolder(_paramPlaceHolders, attribute.getKey()); attributeConstraint += " AND a" + cnt + ".PRINCIPAL_ID=SECURITY_PRINCIPAL.PRINCIPAL_ID AND a" + cnt + ".ATTR_NAME = " + _paramPlaceHolderName; _paramPlaceHolderName = putParamPlaceHolder(_paramPlaceHolders, convertWildcardsForLike(attribute.getValue())); attributeConstraint += " AND a" + cnt + ".ATTR_VALUE LIKE " + _paramPlaceHolderName; _paramPlaceHolderName = putParamPlaceHolder(_paramPlaceHolders, convertWildcardsForLike(queryContext.getNameFilter())); constraint = "SECURITY_PRINCIPAL.PRINCIPAL_NAME LIKE " + _paramPlaceHolderName; _paramPlaceHolderName = putParamPlaceHolder(_paramPlaceHolders, convertWildcardsForLike(roleName)); _paramPlaceHolderName = putParamPlaceHolder(_paramPlaceHolders, convertWildcardsForLike(groupName)); _paramPlaceHolderName = putParamPlaceHolder(_paramPlaceHolders, convertWildcardsForLike(userName)); String sql = getPagingSql(preparedSqlStr, queryContext); String countSql = convertToCountQueryStatement(preparedSqlStr);
PreparedStatement [] pstmts = createPagingPreparedStatementAndCountPreparedStatement(conn, queryContext); pstmtForPaging = pstmts[0]; pstmtForCount = pstmts[1]; scrollToOffset(conn, rsForPaging, queryContext.getOffset()); for (int i = 0; i < queryContext.getLength(); i++) {