MySQL time type problem in Ibatis framework (original OH)

When you write code, you encounter an error that is not found, simply record the problem in this Dubbo frame.

Start Dubbo a server-side of the Bat times error is as follows

This is the SQL text where the XML file parsing error. The investigation found that the type in DB is timestamp, and the type mismatch of String,javatype and Jdbctype is defined in entity, which causes the parse times out "Java.lang.IllegalStateException:No Typehandler found for property XXX "error.

The solution is as follows:

1, modify the structure of the DB table, change the corresponding field to datetime

2. Use date format function to process the field, modify SQL to select Date_format (XXX, '%y-%m-%d%h:%i:%s ') XXX from TABLE;

MySQL time type problem in Ibatis framework (original OH)