34 String userFederationProviderTableName =
database.correctObjectName(
"USER_FEDERATION_PROVIDER", Table.class);
37 PreparedStatement statement =
jdbcConnection.prepareStatement(
"select REALM_ID, USERFEDERATIONPROVIDERS_ID from " +
getTableName(
"FED_PROVIDERS"));
40 ResultSet resultSet = statement.executeQuery();
42 while (resultSet.next()) {
43 String realmId = resultSet.getString(1);
44 String userFederationProviderId = resultSet.getString(2);
46 UpdateStatement updateStatement =
new UpdateStatement(null, null, userFederationProviderTableName)
47 .addNewColumnValue(
"REALM_ID", realmId)
48 .setWhereClause(
"ID='" + userFederationProviderId +
"'");
59 }
catch (Exception e) {
60 throw new CustomChangeException(
getTaskId() +
": Exception when updating data from previous version", e);
String getTaskId()
Definition: JpaUpdate1_9_0_Final.java:65
JdbcConnection jdbcConnection
Definition: CustomKeycloakTask.java:52
String getTableName(String tableName)
Definition: CustomKeycloakTask.java:132
List< SqlStatement > statements
Definition: CustomKeycloakTask.java:55
Database database
Definition: CustomKeycloakTask.java:51
StringBuilder confirmationMessage
Definition: CustomKeycloakTask.java:54