solution: MySql 5.1.47 Time type error

[zjinlei]

• I have searched the issues of this repository and believe that this is not a duplicate.

Ⅰ. Issue Description

When using the mysql driver version 5.1.47, there are a variety of error cases that integrate seata, which can be solved by modifying the version (for example, using 5.1.39).

Case 1.Persistent Object contains LocalDateTime, use Mybatisplus to insert.

Case 2.Persistent Object contains java.util.Date, but seata is called setTimestamp method.

Ⅱ. Describe what happened

If there is an exception, please attach the exception trace:

Just paste your stack trace here!

Ⅲ. Describe what you expected to happen

Ⅳ. How to reproduce it (as minimally and precisely as possible)

1. xxx
2. xxx
3. xxx

Ⅴ. Anything else we need to know?

Ⅵ. Environment:

• JDK version : 1.8
• OS :
• seata: 0.8.0
  -mysql: 5.1.47

[wslongchen]

So will it update the plan in later versions?

[zjinlei]

@wslongchen Recommended to replace the mysql version

[lxy1693]

多谢提供方案，困扰了很久的问题

[yoyoyoga]

using mysql-connector-java 5.1.39，garbled characters appear when reading database field type as json format data, be careful

[zhuangzhuangdashen]

so it's a issue about seata , or a mysql connector issue?