17 PreparedStatement statement =
jdbcConnection.prepareStatement(
"select ID,URI from " +
getTableName(
"RESOURCE_SERVER_RESOURCE") +
" where URI is not null");
20 ResultSet resultSet = statement.executeQuery();
22 while (resultSet.next()) {
23 String resourceId = resultSet.getString(1);
24 String resourceUri = resultSet.getString(2);
26 InsertStatement insertComponent =
new InsertStatement(null, null,
database.correctObjectName(
"RESOURCE_URIS", Table.class))
27 .addColumnValue(
"RESOURCE_ID", resourceId)
28 .addColumnValue(
"VALUE", resourceUri);
40 }
catch (Exception e) {
41 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
Database database
Definition: CustomKeycloakTask.java:51
String getTaskId()
Definition: AuthzResourceUseMoreURIs.java:46
StringBuilder confirmationMessage
Definition: CustomKeycloakTask.java:54