View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003950 | SymmetricDS | Improvement | public | 2019-05-10 15:26 | 2019-05-13 17:49 |
| Reporter | hanes | Assigned To | |||
| Priority | normal | ||||
| Status | confirmed | Resolution | open | ||
| 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 | ||||