* @param configId
* @return Configuration
*/
private Configuration getConfigByIdAux(Integer configId) throws SQLException {
Configuration configuration = null;
String query = "SELECT configid, name, type, data, directoryid, timestamp FROM config WHERE configid="
+ configId;
if (stmt != null) {
ResultSet rs = stmt.executeQuery(query);
while (rs.next()) {
configuration = new Configuration();
configuration.setId(rs.getInt("configid"));
configuration.setName(rs.getString("name"));
configuration.setType(rs.getString("type"));
configuration.setData(rs.getString("data"));
int directoryid = rs.getInt("directoryid");
configuration.setDirectoryId(directoryid);
configuration.setTimestamp(rs.getTimestamp("timestamp"));
}
rs.close();
stmt.clearBatch();
if (configuration != null) {
configuration.setChartProperties(getChartPropertiesByIdAux(configId));
configuration.setPlotPropertiesMap(getPlotPropertiesByIdAux(configId));
int directoryid = configuration.getDirectoryId();
// System.out.println("directoryid=" + directoryid);
IDirectory directory = getDirectoryById(directoryid, true);
if (directory != null) {
// IDirectory parent = directory.getDirectory();
configuration.setDirectory(directory);
}
}
}
return configuration;