View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006190 | SymmetricDS Pro | Improvement | public | 2024-01-15 17:37 | 2024-02-15 20:28 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.14.7 | ||||
| Target Version | 3.14.12 | Fixed in Version | 3.14.12 | ||
| Summary | 0006190: SQL-Server log mining should not require snapshot isolation | ||||
| Description | SQL-Server log mining should not require snapshot isolation. The setup database wizard currently sets the target.db.jdbc.isolation.level to snapshot isolation, which causes an error in the log if the database doesn't have it. Snapshot isolation is no longer required for log mining on SQL-Server. See issue 0005795 for an explanation and the fix to work on SQL-Server without snapshot isolation. | ||||
| Tags | log miner | ||||
| related to | 0005795 | closed | emiller | SymmetricDS Pro | SQL Server log miner skips over changes on a busy system |
| related to | 0005815 | closed | josh-a-hicks | SymmetricDS | DDL Capture Changes - Three enhancements to DDL trigger capture |
| related to | 0006191 | closed | elong | SymmetricDS Pro | SQL-Server log mining should not require snapshot isolation |
|
SymmetricDS: 3.14 a870b6eb 2024-01-15 17:39:57 Details Diff |
0006190: SQL-Server log mining should not require snapshot isolation |
Affected Issues 0006190 |
|
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/mssql/MsSql2008DatabasePlatform.java | Diff File | ||
|
SymmetricDS: 3.15 420aa3e9 2024-01-15 17:39:57 Details Diff |
0006190: SQL-Server log mining should not require snapshot isolation |
Affected Issues 0006190 |
|
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/mssql/MsSql2008DatabasePlatform.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2024-01-15 17:37 | elong | New Issue | |
| 2024-01-15 17:37 | elong | Status | new => assigned |
| 2024-01-15 17:37 | elong | Assigned To | => elong |
| 2024-01-15 17:37 | elong | Tag Attached: log miner | |
| 2024-01-15 17:37 | elong | Relationship added | related to 0005795 |
| 2024-01-15 17:37 | elong | Relationship added | related to 0005815 |
| 2024-01-15 17:42 | elong | Status | assigned => resolved |
| 2024-01-15 17:42 | elong | Resolution | open => fixed |
| 2024-01-15 17:42 | elong | Fixed in Version | => 3.14.12 |
| 2024-01-15 17:42 | elong | Issue cloned: 0006191 | |
| 2024-01-15 17:42 | elong | Relationship added | related to 0006191 |
| 2024-02-05 18:57 | admin | Status | resolved => closed |
| 2024-02-15 20:28 | admin | Changeset attached | => SymmetricDS 3.14 a870b6eb |
| 2024-02-15 20:28 | admin | Changeset attached | => SymmetricDS 3.15 420aa3e9 |