Uploaded image for project: 'iDempiere'
  1. IDEMPIERE-3057

2Pack handler for SQL Statements that must not fail

    Details

    • Type: New Feature
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Sprint:

      Description

      At this moment 2Pack has a handler for SQL Statement, this handler is written in a way that it can fail silently and 2Pack still completes and is marked as successful, even if the SQL Statement fails.

      This was developed that way because of certain SQL statements that are OK when running the first time - but will fail for sure if 2pack is ran for second time, for example adding a foreign key.

      This approach is very dangerous as we still need some SQL statements to be mandatory for the success of 2pack.

      So, proposal here is to add a new handler for SQLMandatory, so we still have the old SQLStatement (which optionally can fail and 2pack still keeps completing) and the new SQLMandatory which cannot fail and will force a rollback in case of failure.

      Regards,

      Carlos Ruiz

        Attachments

          Activity

            People

            • Assignee:
              carlosruiz_globalqss Carlos Ruiz
              Reporter:
              carlosruiz_globalqss Carlos Ruiz
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: