stmt = tranDbConn.createStatement();
rows = stmt.executeQuery(sql);
long opId = -1;
while (rows.next()) {
opId = rows.getInt(1);
LocationProperties locationProperties = opToPropsMap.get(opId);
if (locationProperties == null) {
Map<String, String> props = Maps.newHashMap();
String messageSelector = rows.getString(2);
if (messageSelector != null) {
props.put("Jms.MessageSelector", messageSelector);
}
locationProperties = new LocationProperties(props);
opToPropsMap.put(opId, locationProperties);
}
locationProperties.addProperty(rows.getString(3), rows.getString(4));
}
} catch (SQLException ex) {
throw new JmsServerException("Failed to retrieve JMS location info", ex);
} finally {
KongaDbUtils.close(rows);