/**
* Insert new row into the BUSINESS_ENTITIES table.
*
* @param service object holding values to be inserted
* @param connection JDBC connection
* @throws java.sql.SQLException
*/
public static void insert(BusinessService service, Connection connection)
throws java.sql.SQLException {
PreparedStatement statement = null;
Timestamp timeStamp = new Timestamp(System.currentTimeMillis());
try {
statement = connection.prepareStatement(insertSQL);
statement.setString(1, service.getBusinessKey().toString());
statement.setString(2, service.getServiceKey().toString());
statement.setTimestamp(3, timeStamp);
log.info(
"insert into BUSINESS_SERVICE table:\n\n\t"
+ insertSQL
+ "\n\t BUSINESS_KEY="
+ service.getBusinessKey().toString()
+ "\n\t SERVICE_KEY="
+ service.getServiceKey().toString()
+ "\n\t LAST_UPDATE="
+ timeStamp.getTime()
+ "\n");
int returnCode = statement.executeUpdate();
log.info("insert into BUSINESS_SERVICE was successful, return code=" + returnCode);
} finally {
try {
statement.close();
} catch (Exception e) {
/* ignored */
}
}
}
