View Issue Details

IDProjectCategoryView StatusLast Update
0002075SymmetricDSNew Featurepublic2019-04-23 13:20
Reportersrecon Assigned To 
Prioritynormal 
Status newResolutionopen 
Product Version3.6.13 
Summary0002075: Avoid sending SQL query when synchronizing data between two DB
DescriptionWe are synchronizing two DataBase through SymetricDS. DataBase are isolated in different environment and only access through https. We observed packets which sending vice verse and found the following SQL query in Packet:
table,sym_table_reload_request
keys,TARGET_NODE_ID,SOURCE_NODE_ID,TRIGGER_ID,ROUTER_ID
columns,TARGET_NODE_ID,SOURCE_NODE_ID,TRIGGER_ID,ROUTER_ID,RELOAD_SELECT,RELOAD_DELETE_STMT,RELOAD_ENABLED,RELOAD_TIME,CREATE_TIME,LAST_UPDATE_BY,LAST_UPDATE_TIME
sql,delete from sym_table_reload_request

"sql,delete from sym_table_reload_request" - We have some restriction to sending such sql query through packet from one environment to another. Is there any way to configure such way that symmetricDS doesn't send any sql query?
Tagssecurity

Activities

chenson

2014-11-19 14:43

administrator   ~0000598

It would be nice to be able to send a "truncate" command versus the sql for registration. Each database platform could run a truncate or delete (which ever is more efficient) instead of using the initial.load.delete.first.sql property.

We have had times where we wanted to set initial.load.delete.first.sql to truncate %s but we couldn't because it is used in registration and on some platforms (sql server) you can't truncate tables with fks.

srecon

2014-11-19 16:07

reporter   ~0000599

Last edited: 2014-11-19 16:07

View 2 revisions

let me explain the problem briefly, We have the problem with pure SQL command. For security reason we have not allowed to send any SQL query through symmetricDS packet.
If you can convert "sql,delete from sym_table_reload_request"
as follows:
delete ,"table name"
will solve the problem

Issue History

Date Modified Username Field Change
2014-11-19 14:37 srecon New Issue
2014-11-19 14:43 chenson Note Added: 0000598
2014-11-19 14:43 chenson Target Version => 3.7.0
2014-11-19 16:07 srecon Note Added: 0000599
2014-11-19 16:07 srecon Note Edited: 0000599 View Revisions
2014-12-10 14:41 chenson Target Version 3.7.0 =>
2019-04-23 13:20 elong Tag Attached: security