solution: MySql 5.1.47 Time type error - Githubissues

apache / incubator-seata

:fire: Seata is an easy-to-use, high-performance, open source distributed transaction solution.

https://seata.apache.org/

Apache License 2.0

25.33k stars 8.78k forks source link

solution: MySql 5.1.47 Time type error #1578

Open zjinlei opened 5 years ago

zjinlei commented 5 years ago

[ ] 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)

xxx
xxx
xxx

Ⅴ. Anything else we need to know?

Ⅵ. Environment:

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

wslongchen commented 5 years ago

So will it update the plan in later versions?

zjinlei commented 5 years ago

@wslongchen Recommended to replace the mysql version

lxy1693 commented 4 years ago

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

yoyoyoga commented 4 years ago

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

zhuangzhuangdashen commented 1 year ago

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