View Issue Details

IDProjectCategoryView StatusLast Update
0004675SymmetricDSBugpublic2021-05-28 20:40
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.12.0 
Target Version3.12.10Fixed in Version3.12.10 
Summary0004675: SQL-Server trigger not implemented exception for NCHAR
DescriptionUsing 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)
Tagsdialect: sql-server, trigger

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.12 a98716a5

2021-05-13 14:57:29

admin

Details Diff
0004675: SQL-Server trigger not implemented exception for NCHAR Affected Issues
0004675
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/AbstractTriggerTemplate.java Diff File

Issue History

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