View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0002075 | SymmetricDS | New Feature | public | 2014-11-19 14:37 | 2024-08-07 17:26 |
| Reporter | srecon | Assigned To | |||
| Priority | normal | ||||
| Status | new | Resolution | open | ||
| Product Version | 3.6.13 | ||||
| Summary | 0002075: Avoid sending SQL query when synchronizing data between two DB | ||||
| Description | We 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? | ||||
| Tags | security | ||||
|
|
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. |
|
|
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 |
|
|
Maybe provide a new event to send to the target to specify that you want to delete or truncate a specific table, without specifying an explicit sql statement. table,sometable delrecords,1=1 or table,sometable truncate |
| 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 | |
| 2024-08-07 17:26 | pmarzullo | Note Added: 0002487 |