35         String realmClientTableName = 
database.correctObjectName(
"REALM_CLIENT", Table.class);
    38             String trueValue = DataTypeFactory.getInstance().getTrueBooleanValue(
database);
    39             PreparedStatement statement = 
jdbcConnection.prepareStatement(
"select CLIENT.REALM_ID, CLIENT.ID CLIENT_ID from " + 
getTableName(
"CLIENT") + 
" CLIENT where CLIENT.CONSENT_REQUIRED = " + trueValue);
    42                 ResultSet resultSet = statement.executeQuery();
    44                     while (resultSet.next()) {
    45                         String realmId = resultSet.getString(
"REALM_ID");
    46                         String oauthClientId = resultSet.getString(
"CLIENT_ID");
    48                         InsertStatement realmClientInsert = 
new InsertStatement(null, null, realmClientTableName)
    49                                 .addColumnValue(
"REALM_ID", realmId)
    50                                 .addColumnValue(
"CLIENT_ID", oauthClientId);
    61         } 
catch (Exception e) {
    62             throw new CustomChangeException(
getTaskId() + 
": Exception when updating data from previous version", e);
 JdbcConnection jdbcConnection
Definition: CustomKeycloakTask.java:52
 
String getTableName(String tableName)
Definition: CustomKeycloakTask.java:132
 
List< SqlStatement > statements
Definition: CustomKeycloakTask.java:55
 
String getTaskId()
Definition: JpaUpdate1_2_0_CR1.java:67
 
Database database
Definition: CustomKeycloakTask.java:51
 
StringBuilder confirmationMessage
Definition: CustomKeycloakTask.java:54