37 PreparedStatement statement =
jdbcConnection.prepareStatement(
"select ID, PRIVATE_KEY, CERTIFICATE from " +
getTableName(
"REALM"));
40 ResultSet resultSet = statement.executeQuery();
42 while (resultSet.next()) {
43 String realmId = resultSet.getString(1);
44 String privateKeyPem = resultSet.getString(2);
45 String certificatePem = resultSet.getString(3);
47 String componentId = KeycloakModelUtils.generateId();
49 InsertStatement insertComponent =
new InsertStatement(null, null,
database.correctObjectName(
"COMPONENT", Table.class))
50 .addColumnValue(
"ID", componentId)
51 .addColumnValue(
"REALM_ID", realmId)
52 .addColumnValue(
"PARENT_ID", realmId)
53 .addColumnValue(
"NAME",
"rsa")
54 .addColumnValue(
"PROVIDER_ID",
"rsa")
55 .addColumnValue(
"PROVIDER_TYPE", KeyProvider.class.getName());
71 }
catch (Exception e) {
72 throw new CustomChangeException(
getTaskId() +
": Exception when updating data from previous version", e);
String getTaskId()
Definition: ExtractRealmKeysFromRealmTable.java:85
InsertStatement componentConfigStatement(String componentId, String name, String value)
Definition: ExtractRealmKeysFromRealmTable.java:76
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