private static Collection<ExternalComponentConfiguration> getConfigurations(
Permission permission) {
Collection<ExternalComponentConfiguration> answer =
new ArrayList<ExternalComponentConfiguration>();
java.sql.Connection con = null;
PreparedStatement pstmt = null;
try {
con = DbConnectionManager.getConnection();
pstmt = con.prepareStatement(LOAD_CONFIGURATIONS);
pstmt.setString(1, permission.toString());
ResultSet rs = pstmt.executeQuery();
ExternalComponentConfiguration configuration;
while (rs.next()) {
configuration = new ExternalComponentConfiguration(rs.getString(1));
configuration.setSecret(rs.getString(2));
configuration.setPermission(permission);
answer.add(configuration);
}
rs.close();
} catch (SQLException sqle) {
Log.error(sqle);
} finally {
try {
if (pstmt != null) pstmt.close();
} catch (Exception e) {
Log.error(e);
}
try {
if (con != null) con.close();
} catch (Exception e) {
Log.error(e);
}
}
return answer;
}
/**
* Returns the configuration for an external component.
*
* @param subdomain the subdomain of the external component.
* @return the configuration for an external component.
*/
public static ExternalComponentConfiguration getConfiguration(String subdomain) {
ExternalComponentConfiguration configuration = null;
java.sql.Connection con = null;
PreparedStatement pstmt = null;
try {
con = DbConnectionManager.getConnection();
pstmt = con.prepareStatement(LOAD_CONFIGURATION);
pstmt.setString(1, subdomain);
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
configuration = new ExternalComponentConfiguration(subdomain);
configuration.setSecret(rs.getString(1));
configuration.setPermission(Permission.valueOf(rs.getString(2)));
}
rs.close();
} catch (SQLException sqle) {
Log.error(sqle);
} finally {
try {
if (pstmt != null) pstmt.close();
} catch (Exception e) {
Log.error(e);
}
try {
if (con != null) con.close();
} catch (Exception e) {
Log.error(e);
}
}
return configuration;
}