Mybatis exception: the element content must contain correctly formatted character data or tags ., Mybatis character

Mybatis exception: the element content must contain correctly formatted character data or tags ., Mybatis character

When my colleague wrote a query interface today, an error occurred: the element content must consist of correctly formatted character data or tags.

Cause of error: When querying mybatis, you need to use the operator less than sign: <and greater than sign:>. In the mybatis configuration file, this will be considered as a tag, so the parsing is incorrect.

Error example:

Select <include refid = "Base_Column_List"/> from t_time_interval where status <> 99 and time_intvl_id> = 29 and time_intvl_id <= 45 order by time_intvl_id

Solution:

Select <include refid = "Base_Column_List"/> from t_time_interval where <! [CDATA [status <> 99 and time_intvl_id> = 29 and time_intvl_id <= 45 order by time_intvl_id]>

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.