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