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:
- Java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver [How to Solve]
- Springboot uses Oracle database to report property ‘sqlsessionfactory’ or ‘sqlsessiontemplate’ are required
- SpringBoot Project Run Page Error: Whitelabel Error Page This application has no explicit mapping for /error
- Error starting ApplicationContext. To display the conditions report re-run your application with ‘de
- [Solved] BindingException: Type interface XXX is not known to the MapperRegistry
- [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）
- Error querying database.Cause: java.sql.SQLException: Error setting driver on UnpooledDataSource.
- JAVA: How to use the third-party font library method (using the third-party TTF / TTC font library method)
- Spring Project Error: Error creating bean with name [How to Solve]
- Mybatisenumtypehandler upgrade error of mybatis plus
- Spring Cloud Hoxton.SR9 gateway and reactor-netty 0.9.0.RELEASE is Incompatible [How to Solve]
- [Solved] Consider defining a bean of type ‘org.springframework.data.redis.core.RedisTemplate‘ in your configu
- [Solved] Cannot find class: com.mysql.jdbc.Driver
- spring cloud 2020 gateway Error 503 [How to Solve]
- [Solved] Unable to start web server; nested exception is org.springframework.boot.web.server.WebServerExcepti
- How to Solve PageHelper.startPage count Error
- Asynchronous processing of HTTP request by Java_ Method 2: through deferredresult
- Mybatis single parameter pass in exception (How to Fix)
- [Solved] Failed to introspect Class [org.springframework.cloud.netflix.hystrix.HystrixCircuitBreakerConfigura