View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004675 | SymmetricDS | Bug | public | 2020-12-02 18:26 | 2021-05-28 20:40 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.12.0 | ||||
| Target Version | 3.12.10 | Fixed in Version | 3.12.10 | ||
| Summary | 0004675: SQL-Server trigger not implemented exception for NCHAR | ||||
| Description | Using Microsoft JDBC driver on Azure, tables with NCHAR type get error when syncing triggers: 2020-11-25 21:32:20,706 ERROR [central] [TriggerRouterService] [central-sync-triggers-1] Failed to create triggers for TypeClient StackTraceKey.init [NotImplementedException:4049200262] org.apache.commons.lang3.NotImplementedException: Column [name=TypeClientId; jdbcType=nchar; mappedType=NCHAR] is of type NCHAR at org.jumpmind.symmetric.db.AbstractTriggerTemplate.buildKeyVariablesDeclare(AbstractTriggerTemplate.java:1119) at org.jumpmind.symmetric.db.mssql.MsSqlTriggerTemplate.replaceTemplateVariables(MsSqlTriggerTemplate.java:387) at org.jumpmind.symmetric.db.mssql.MsSql2008TriggerTemplate.replaceTemplateVariables(MsSql2008TriggerTemplate.java:21) at org.jumpmind.symmetric.db.AbstractTriggerTemplate.createTriggerDDL(AbstractTriggerTemplate.java:431) at org.jumpmind.symmetric.db.AbstractSymmetricDialect.createTrigger(AbstractSymmetricDialect.java:368) at org.jumpmind.symmetric.service.impl.TriggerRouterService.rebuildTriggerIfNecessary(TriggerRouterService.java:1895) at org.jumpmind.symmetric.service.impl.TriggerRouterService.updateOrCreateDatabaseTriggers(TriggerRouterService.java:1745) at org.jumpmind.symmetric.service.impl.TriggerRouterService.updateOrCreateDatabaseTrigger(TriggerRouterService.java:1630) at org.jumpmind.symmetric.service.impl.TriggerRouterService$2.run(TriggerRouterService.java:1616) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1130) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:630) at java.base/java.lang.Thread.run(Thread.java:832) | ||||
| Tags | dialect: sql-server, trigger | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2020-12-02 18:26 | elong | New Issue | |
| 2020-12-02 18:26 | elong | Tag Attached: dialect: sql-server | |
| 2020-12-02 18:26 | elong | Tag Attached: trigger | |
| 2021-01-08 20:42 | admin | Target Version | 3.12.6 => 3.12.7 |
| 2021-02-25 13:01 | admin | Target Version | 3.12.7 => 3.12.8 |
| 2021-03-30 19:13 | admin | Target Version | 3.12.8 => 3.12.9 |
| 2021-04-28 14:41 | admin | Target Version | 3.12.9 => 3.12.10 |
| 2021-05-13 14:57 | elong | Assigned To | => elong |
| 2021-05-13 14:57 | elong | Status | new => resolved |
| 2021-05-13 14:57 | elong | Resolution | open => fixed |
| 2021-05-13 14:57 | elong | Fixed in Version | => 3.12.10 |
| 2021-05-13 15:00 | admin | Changeset attached | => SymmetricDS 3.12 a98716a5 |
| 2021-05-28 20:40 | admin | Status | resolved => closed |