View Issue Details

IDProjectCategoryView StatusLast Update
0000239SymmetricDSImprovementpublic2010-01-19 16:56
ReporterAssigned Tochenson  
Priorityhigh 
Status closedResolutionfixed 
Product Version2.1.0 
Target Version2.1.0Fixed in Version2.1.0 
Summary0000239: Search Router By Router Id
Description"May I know how to retrieve existing router based on the current node? I know we have this API: Router router = triggerRouterService.getRouterByIdForCurrentNode(""corp_store_identity"", false); But it is not working if there is no any trigger configure for ""corp_store_identity"" router first, we will get null value in this case. The sql generated by the above API is like the followings: select t.trigger_id,t.channel_id,t.source_table_name,t.sync_on_insert,t.sync_on_update,t.sync_on_delete,r.sync_on_insert as r_sync_on_insert,r.sync_on_update as r_sync_on_update,r.sync_on_delete as r_sync_on_delete,t.sync_on_incoming_batch,t.excluded_column_names, t.name_for_delete_trigger,t.name_for_insert_trigger,t.name_for_update_trigger,t.source_schema_name,t.source_catalog_name,t.sync_on_insert_condition,t.sync_on_update_condition,t.sync_on_delete_condition,t.tx_id_expression,t.external_select,t.create_time as t_create_time,t.last_update_time as t_last_update_time, t.last_update_by as t_last_update_by, r.target_catalog_name,r.source_node_group_id,r.target_schema_name,r.target_table_name,r.target_node_group_id,r.router_expression,r.router_type,r.router_id,r.create_time as r_create_time,r.last_update_time as r_last_update_time,r.last_update_by as r_last_update_by, tr.create_time,tr.last_update_time,tr.last_update_by,tr.initial_load_order, tr.initial_load_select from sym_trigger_router tr inner join sym_trigger t on tr.trigger_id=t.trigger_id inner join sym_router r on tr.router_id=r.router_id where r.source_node_group_id = 'corp' For new trigger, this select will return nothing. Can we have some API which will perform something like this: select * from sym_router r where r.source_node_group_id = 'corp' I try to use SymmetricDS API instead of issue JDBC call directly."
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change