View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0002626 | SymmetricDS | Improvement | public | 2016-06-02 23:39 | 2016-06-10 14:22 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.7.0 | ||||
| Target Version | 3.7.34 | Fixed in Version | 3.7.34 | ||
| Summary | 0002626: Set order of triggers to first on SQL Server to preserve order of changes | ||||
| Description | When the user has triggers on a table already, and those triggers are modifying data, the ordering of triggers is important. The SymmetricDS triggers need to fire first to capture the first change before other triggers can modify additional data. Add a mssql.trigger.order.first parameter that will enable the use of sp_settriggerorder procedure to set the SymmetricDS triggers to first. Only one trigger can be set as first, so if the user already has a trigger set to first, set their trigger to none, and log a warning. | ||||
| Tags | No tags attached. | ||||
|
SymmetricDS: 3.7 e663e244 2016-06-03 16:39:38 Details Diff |
0002626: Set order of triggers to first on SQL Server to preserve order of changes |
Affected Issues 0002626 |
|
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/mssql/MsSqlSymmetricDialect.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/common/ParameterConstants.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/AbstractSymmetricDialect.java | Diff File | ||
| mod - symmetric-core/src/main/resources/symmetric-default.properties | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2016-06-02 23:39 | elong | New Issue | |
| 2016-06-02 23:39 | elong | Status | new => assigned |
| 2016-06-02 23:39 | elong | Assigned To | => elong |
| 2016-06-03 21:00 | admin | Changeset attached | => SymmetricDS 3.7 e663e244 |
| 2016-06-06 14:54 | elong | Status | assigned => resolved |
| 2016-06-06 14:54 | elong | Fixed in Version | => 3.7.34 |
| 2016-06-06 14:54 | elong | Resolution | open => fixed |
| 2016-06-10 14:22 | elong | Status | resolved => closed |