View Issue Details

IDProjectCategoryView StatusLast Update
0003610SymmetricDSBugpublic2018-06-22 03:28
ReporterNewerthAssigned To 
Prioritynormal 
Status newResolutionopen 
Product Version3.9.8 
Target VersionFixed in Version 
Summary0003610: HSQLDB type OTHER support
DescriptionSymmetricDS appears not to support type OTHER in the HSQLDB database, even for HSQLDB -> HSQLDB synchronization:

2018-06-22 08:38:29,033 ERROR [impl.TriggerRouterService] [as2-test-source-sync-triggers-1] Failed to create triggers for partner
org.apache.commons.lang.NotImplementedException: PARTNERCOMMENT is of type OTHER with JDBC type of OTHER
        at org.jumpmind.symmetric.db.AbstractTriggerTemplate.fillOutColumnTemplate(AbstractTriggerTemplate.java:904)
        at org.jumpmind.symmetric.db.AbstractTriggerTemplate.buildColumnsString(AbstractTriggerTemplate.java:760)
        at org.jumpmind.symmetric.db.AbstractTriggerTemplate.replaceTemplateVariables(AbstractTriggerTemplate.java:501)
        at org.jumpmind.symmetric.db.AbstractTriggerTemplate.createTriggerDDL(AbstractTriggerTemplate.java:395)
        at org.jumpmind.symmetric.db.AbstractSymmetricDialect.createTrigger(AbstractSymmetricDialect.java:384)
        at org.jumpmind.symmetric.service.impl.TriggerRouterService.rebuildTriggerIfNecessary(TriggerRouterService.java:1802)
        at org.jumpmind.symmetric.service.impl.TriggerRouterService.updateOrCreateDatabaseTriggers(TriggerRouterService.java:1673)
        at org.jumpmind.symmetric.service.impl.TriggerRouterService.updateOrCreateDatabaseTrigger(TriggerRouterService.java:1552)
        at org.jumpmind.symmetric.service.impl.TriggerRouterService$2.run(TriggerRouterService.java:1538)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        at java.util.concurrent.FutureTask.run(FutureTask.java:266)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at java.lang.Thread.run(Thread.java:748)
Additional InformationSee http://www.h2database.com/html/datatypes.html#other_type

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2018-06-22 03:28 Newerth New Issue
2018-06-22 03:28 Newerth Tag Attached: hsqldb