private void insertExperimentStatus(
String experimentID, String status, String requestXML, String hostname, String us3DB)
throws Exception {
Connection connection = null;
PreparedStatement statement = null;
try {
connection =
ConnectionManager.getConnection(
ServiceConstants.JDBC_DRIVER,
properties.getProperty(ServiceConstants.PROPERTY_JDBC_URL));
statement = connection.prepareStatement(ServiceConstants.INSERT_NOTIFICATION_INFO);
statement.setString(1, experimentID);
statement.setString(2, status);
statement.setString(3, requestXML);
statement.setString(4, hostname);
statement.setString(5, us3DB);
statement.executeUpdate();
} finally {
if (statement != null) {
statement.close();
}
if (connection != null) {
connection.close();
}
}
}
private void updateExperimentStatus(String experimentID, String status, String description)
throws Exception {
Connection connection = null;
PreparedStatement statement = null;
try {
connection =
ConnectionManager.getConnection(
ServiceConstants.JDBC_DRIVER,
properties.getProperty(ServiceConstants.PROPERTY_JDBC_URL));
statement = connection.prepareStatement(ServiceConstants.UPDATE_NOTIFICATION_INFO);
statement.setString(1, status);
statement.setString(2, description);
statement.setString(3, experimentID);
statement.executeUpdate();
} finally {
if (statement != null) {
statement.close();
}
if (connection != null) {
connection.close();
}
}
}