View Issue Details

IDProjectCategoryView StatusLast Update
0003610SymmetricDSBugpublic2019-03-14 12:48
ReporterNewerth Assigned Topmarzullo  
Prioritylow 
Status closedResolutionfixed 
Product Version3.9.8 
Target Version3.10.0Fixed in Version3.10.0 
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
Tagsdialect: hsqldb

Activities

pmarzullo

2019-02-06 19:38

developer   ~0001390

JAVA_OBJECT was mapped to column type OBJECT, but should have been mapped to column type OTHER, in both HSQLDB and HSQLDB2.

Related Changesets

SymmetricDS: 3.10 c68fbf49

2019-02-06 14:36:58

Philip Marzullo

Details Diff
0003610: HSQLDB type OTHER support Affected Issues
0003610
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/hsqldb/HsqlDbDdlBuilder.java Diff File
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/hsqldb2/HsqlDb2DdlBuilder.java Diff File

Issue History

Date Modified Username Field Change
2018-06-22 07:28 Newerth New Issue
2018-06-22 07:28 Newerth Tag Attached: hsqldb
2018-10-10 18:13 hanes Status new => acknowledged
2018-10-10 18:13 hanes Target Version => 3.10.0
2018-10-29 16:56 hanes Priority normal => low
2019-02-06 19:35 pmarzullo Assigned To => pmarzullo
2019-02-06 19:35 pmarzullo Status acknowledged => assigned
2019-02-06 19:38 pmarzullo Status assigned => resolved
2019-02-06 19:38 pmarzullo Resolution open => fixed
2019-02-06 19:38 pmarzullo Fixed in Version => 3.10.0
2019-02-06 19:38 pmarzullo Note Added: 0001390
2019-02-06 20:00 Changeset attached => SymmetricDS 3.10 c68fbf49
2019-03-14 12:48 admin Status resolved => closed
2019-04-23 20:48 admin Tag Renamed hsqldb => dialect: hsqldb