View Revisions: Issue #6637

Back to Issue
Summary 0006637: Add support for Derby boolean data types
Revision 2024-11-06 18:08 by emiller
Description Currently, the Derby dialect does not support the boolean data type. It would be good to set the booleanColumnTemplate in DerbyTriggerTemplate to add support for this data type.
Revision 2025-02-08 16:20 by pbelov
Description Currently, the Derby dialect does not support the boolean data type. It would be good to set the booleanColumnTemplate in DerbyTriggerTemplate to add support for this data type.

[TriggerRouterService] [server-dby1016root-sync-triggers-1] Failed to create triggers for APP.RANDOM_INT_BOOLEAN StackTraceKey.init [NotImplementedException:2372351393]
org.apache.commons.lang3.NotImplementedException: Table Table [name=RANDOM_INT_BOOLEAN; 2 columns] column Column [name=CLBOOLEAN; jdbcType=BOOLEAN; mappedType=BOOLEAN]
    at org.jumpmind.symmetric.db.AbstractTriggerTemplate.fillOutColumnTemplate(AbstractTriggerTemplate.java:990)
    at org.jumpmind.symmetric.db.AbstractTriggerTemplate.buildColumnsString(AbstractTriggerTemplate.java:830)
    at org.jumpmind.symmetric.db.AbstractTriggerTemplate.replaceTemplateVariables(AbstractTriggerTemplate.java:516)
    at org.jumpmind.symmetric.db.AbstractTriggerTemplate.createTriggerDDL(AbstractTriggerTemplate.java:385)
    at org.jumpmind.symmetric.db.AbstractSymmetricDialect.createTrigger(AbstractSymmetricDialect.java:410)
    at org.jumpmind.symmetric.service.impl.TriggerRouterService.rebuildTriggerIfNecessaryWithException(TriggerRouterService.java:2528)
    at org.jumpmind.symmetric.service.impl.TriggerRouterService.rebuildTriggerIfNecessary(TriggerRouterService.java:2404)
    at org.jumpmind.symmetric.service.impl.TriggerRouterService.updateOrCreateDatabaseTriggers(TriggerRouterService.java:2355)
    at org.jumpmind.symmetric.service.impl.TriggerRouterService.updateOrCreateDatabaseTrigger(TriggerRouterService.java:2198)
    at org.jumpmind.symmetric.service.impl.TriggerRouterService$2.run(TriggerRouterService.java:2052)
    at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
    at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
    at java.base/java.lang.Thread.run(Thread.java:840)
Revision 2024-11-06 18:08 by emiller
Steps To Reproduce
Revision 2025-02-08 16:20 by pbelov
Steps To Reproduce -- Derby (Apache DB)
CREATE TABLE APP.RANDOM_INT_BOOLEAN(
    clint INT NOT NULL,
    clboolean BOOLEAN ,
    PRIMARY KEY (clint)
);

select * from APP.RANDOM_INT_BOOLEAN;

select * from sym_trigger where source_table_name = 'RANDOM_INT_BOOLEAN';

select * from sym_data where table_name = 'RANDOM_INT_BOOLEAN';
Revision 2025-02-10 21:27 by pbelov
Steps To Reproduce -- Derby (Apache DB)
CREATE TABLE APP.RANDOM_INT_BOOLEAN(
    clint INT NOT NULL,
    clboolean BOOLEAN ,
    PRIMARY KEY (clint)
);


INSERT INTO APP.RANDOM_INT_BOOLEAN2 VALUES(1,NULL, 'test1');
INSERT INTO APP.RANDOM_INT_BOOLEAN2 VALUES(2,FALSE, 'test2');
INSERT INTO APP.RANDOM_INT_BOOLEAN2 VALUES(3,TRUE, 'test3');

select * from APP.RANDOM_INT_BOOLEAN;

select * from sym_trigger where source_table_name = 'RANDOM_INT_BOOLEAN';

select * from sym_data where table_name = 'RANDOM_INT_BOOLEAN';