if (log.isDebugEnabled()) {
log.debug("Executing query: " + sql);
}
resultSet = statement.executeQuery();
while (resultSet.next()) {
PortMapping portMapping = new PortMapping();
portMapping.setPrimaryPort(resultSet.getString("PRIMARY_PORT"));
portMapping.setProxyPort(resultSet.getString("PROXY_PORT"));
portMapping.setType(resultSet.getString("TYPE"));
portMappingList.add(portMapping);
}
} catch (Exception s) {
String msg = "Error while sql connection :" + s.getMessage();
log.error(msg, s);