When using the canal 1.0.25 to initiate the canal service or update the database data, the canal service side complains __canal

1 questions

The canal service side complains when using the canal 1.0.25 to initiate the canal service or update the database data. The error is as follows:

Com.alibaba.druid.sql.parser.ParserException:syntax error, error in: ' XX ') ...

2 analysis

This problem is caused by the ")" in the SQL statement that created the table. The root cause is the problem of the canal-dependent Druid version. 3 Settlement measures

The current solution is as follows. In the Conf/canal.properties file, comment out one line of configuration information as shown below and restart it.

#canal. Instance.tsdb.spring.xml=classpath:spring/tsdb/h2-tsdb.xml    

References: Click on the Open link