"SELECT id, serializedInstance FROM ReportletConfInstance");
for (Map<String, Object> row : reportletConfs) {
final String serializedInstance = (String) row.get("serializedInstance");
if (StringUtils.isNotBlank(serializedInstance)) {
LOG.info("Upgrading ReportletConf {} serializedInstance", row.get("id"));
final UserReportletConf set = XMLDeserializer.<UserReportletConf>deserialize(serializedInstance);
final String newSerializedInst = POJOHelper.serialize(set);
jdbcTemplate.update("UPDATE ReportletConfInstance set serializedInstance = ? WHERE id = ?",
new Object[] { newSerializedInst, row.get("id") });
}
}