View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0003950 | SymmetricDS | Improvement | public | 2019-05-10 15:26 | 2024-08-21 18:46 |
Reporter | hanes | Assigned To | |||
Priority | normal | ||||
Status | closed | Resolution | won't fix | ||
Product Version | 3.10.2 | ||||
Summary | 0003950: Oracle dialect does not support urowid(n) | ||||
Description | Simple test example: create table test14 (myurowid urowid(5), myId varchar(256), primary key (myId)); Trigger create fails with: Failed to create triggers for test14 org.apache.commons.lang.NotImplementedException: MYUROWID is of type OTHER with JDBC type of UROWID at org.jumpmind.symmetric.db.AbstractTriggerTemplate.fillOutColumnTemplate(AbstractTriggerTemplate.java:972) at org.jumpmind.symmetric.db.AbstractTriggerTemplate.buildColumnsString(AbstractTriggerTemplate.java:821) at org.jumpmind.symmetric.db.AbstractTriggerTemplate.replaceTemplateVariables(AbstractTriggerTemplate.java:548) at org.jumpmind.symmetric.db.AbstractTriggerTemplate.createTriggerDDL(AbstractTriggerTemplate.java:436) at org.jumpmind.symmetric.db.AbstractSymmetricDialect.createTrigger(AbstractSymmetricDialect.java:388) at org.jumpmind.symmetric.db.oracle.OracleSymmetricDialect.createTrigger(OracleSymmetricDialect.java:108) at org.jumpmind.symmetric.service.impl.TriggerRouterService.rebuildTriggerIfNecessary(TriggerRouterService.java:1809) at org.jumpmind.symmetric.service.impl.TriggerRouterService.updateOrCreateDatabaseTriggers(TriggerRouterService.java:1680) at org.jumpmind.symmetric.service.impl.TriggerRouterService.syncTriggers(TriggerRouterService.java:1517) at com.jumpmind.symmetric.console.impl.cr$b.doWork(InstalledTriggersPanel.java:547) at com.jumpmind.symmetric.console.impl.ab$2.onBackgroundDataRefresh(InProgressDialog.java:99) at com.jumpmind.symmetric.console.ui.a.a(BackgroundRefresherService.java:99) at com.jumpmind.symmetric.console.ui.a$3.run(BackgroundRefresherService.java:142) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) 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) | ||||
Tags | dialect: oracle, trigger | ||||
Date Modified | Username | Field | Change |
---|---|---|---|
2019-05-10 15:26 | hanes | New Issue | |
2019-05-10 15:26 | hanes | Status | new => confirmed |
2019-05-13 17:49 | elong | Tag Attached: dialect: oracle | |
2019-05-13 17:49 | elong | Tag Attached: trigger | |
2024-08-21 17:25 | cquamme | Assigned To | => cquamme |
2024-08-21 17:25 | cquamme | Status | confirmed => closed |
2024-08-21 17:25 | cquamme | Resolution | open => won't fix |
2024-08-21 18:46 | cquamme | Assigned To | cquamme => |