int alertId = AlertLoggingService.getInstance().insertAlertLog(alVO); //get the ALERT ID OF THIS ISSUE ******************************************************* public int insertAlertLog(Object parameterObject) throws DaoException { return alDao.insertAlertLog(parameterObject); } **************************************************** public int insertAlertLog(Object parameterObject) throws DaoException { int c = 0; c = super.update("AlertLoggingSQL.insertAlertLog", parameterObject); System.out.println("C DATA: " + c); return c; } ******************************************* insert into alert_logging (id, timestamp, type, tag_id, mnemonic, location_str, category_str, upper_limit_alert, upper_limit, lower_limit, lower_limit_alert, measured_value) values(#id#, #timestamp#, #tagId#, #alertType#, #mnemonic#, #locationStr#, #categoryStr#, #upperLimitAlert#, #upperLimit#, #lowerLimit#, #lowerLimitAlert#, #measuredValue#) select LAST_INSERT_ID() as id