Project scenario:
ruoyi cloud converts mybatis into mybatis plus, executes the querywrapper method, and always reminds of the error. Cause: java.sql.sqlsyntax errorexception: unknown column ‘search_ Value ‘in’ field list ‘
but the corresponding entity class did not find this field. After some efforts, the answer was found in an article, and finally the problem was solved!
Problem Description:
problem screenshot:
Cause analysis:
because the database does not have this field, ruoyi cloud integrates baseentity, which contains this error field</ font>
Solution:
add annotation @tablefield (exist = false) to the corresponding entity class
Read More:
- Mybatis Error: All elements are null [How to Solve]
- [Solved] IDEA JPA Custome Query Error: Can‘t resolve symbol ‘Type‘
- Mybatis sets the primary key Auto-Increment error: No setter found for the keyProperty
- [Solved] Idea Build error. The symbol — Lombok cannot be found
- How to Solve the Primary Key of mybatisPlus Inserted Data is too Large Issue
- [Solved] Mybatis Error: attempting to get column ‘XX’ from result set
- [Solved] Mybatis-Plus Error: Invalid bound statement (not found)
- Springboot uses Oracle database to report property ‘sqlsessionfactory’ or ‘sqlsessiontemplate’ are required
- Java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver [How to Solve]
- [Solved] Mybatis integrates PageHelper and uses sqlserver paging error
- SpringBoot Project Run Page Error: Whitelabel Error Page This application has no explicit mapping for /error
- Spring cloud remote connect Nacos error [How to Solve]
- How to Solve idea com.baomidou Error
- Error starting ApplicationContext. To display the conditions report re-run your application with ‘de
- JAVA: How to use the third-party font library method (using the third-party TTF / TTC font library method)
- [Solved] com.highgo.jdbc.util.PSQLException:bad value for long
- [Solved] BindingException: Type interface XXX is not known to the MapperRegistry
- Springboot startup error: Field elasticsearchRestTemplate in cn.lili.modules.material.serviceImpl.QrMaterialServiceImpl required a bean of type
- [Solved] Error creating bean with name ‘configurationPropertiesBeans‘ defined in class path resource
- [Solved] Hibernate Error: java.lang.StackOverflowError at java.lang.Integer.toString(Integer.java:402）