}
Calendar calendar = DateUtils.getCurrentLocalTime();
stmt.execute("UPDATE transactions SET transaction_date = '" + DateUtils.toString(calendar) + "' WHERE transaction_id = '" + transactionId + "'");
return new IngestReceipt(transactionId, calendar.getTime());
}catch (Exception e) {
throw new IngestServiceException("Failed to ingest metadata for transaction id '" + transactionId + "' : " + e.getMessage(), e);
}finally {
try {
conn.close();
}catch(Exception e) {}
try {