The jdbc SQL statement encounters a keyword.
-Time = 03:10:36. 0-sourceid = SUBWAY-M2M-TF-8-position = 002228: 0203272686 #363623406.1369768236-variable:-schema = subway_p31-table = lunabidsetting-action = insert-row # = 1 Col #1: campaignid (-5) = 10927509 Col #2: custid (-5) = 1103845351 Col #3: Keys (12) = biddailymaxcost Col #4: oldvalue (-5) =-1 Col #5: newvalue (-5) = 3000 Col #6: createtime (93) = 03:10:36. 0 Col #7: lastupdatetime (93) = 03:10:36. 0
Com. Taobao. tddl. dbsync. applier. applierbrokenexception: COM. MySQL. JDBC. Exceptions. jdbc4.mysqlsyntaxerrorexception: You have an error in your SQL syntax; check
The manual that corresponds to your MySQL Server version for the right syntax to use near 'keys, oldvalue, newvalue, createtime, lastupdatetime) values (10927509,1103845351, 'B' at line 1
The column name of the target table is a keyword, which must be enclosed in 'keys'
Brackets in SQL Server
Insert into app (name, 'key', secret, status) values ('A', 'bb ', null, 2 );
Reference http://solodu.iteye.com/blog/520419