Anonymous

  <insert id="insertAlertLog" parameterClass="alertLoggingVO">

    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#)

    <selectKey keyProperty="id" resultClass="Integer">
      select LAST_INSERT_ID() as id
    </selectKey>

    
  </insert>