View Issue Details

IDProjectCategoryView StatusLast Update
0004675SymmetricDSBugpublic2021-03-30 19:13
Reporterelong Assigned To 
Prioritynormal 
Status newResolutionopen 
Product Version3.12.0 
Target Version3.12.9 
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.

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