Error 12164 – [xnio-1 TASK-2] p.p.c.s.c.globalexception handler resolver: Global exception information ex = com.xxx.cd.mapper.cdinvoiceinfomapper.insert (batch index # 1) failed———— Error information
Cause: java.sql.batchupdateexception: unknown column ‘xxx’ in ‘field list’ — prompt reason
Finding problems
First of all, the error prompt means that the field cannot be found in the database and the input is invalid
resolvent
- first check the database to see if there is this field in the table. If not, add it. Then add this field to the corresponding mapper.xml and entity class. If the above problems do not exist or cannot be solved, it is recommended to check on the web side to see if there is this missing data in your input data. If not, check the service layer, Open the configuration in Nacos, maintain the table directory in this field, and find that there is this table, but this table does not need this field. Remove this table from it, and then you can do it
Summary
Don’t be afraid when you make mistakes. It’s best to read the error information and the reason patiently, and understand the meaning roughly. If you don’t understand, ask your colleagues first.
Read More:
- How to Fix SQL Error: 1054, SQLState: 42S22 Unknown column ‘markcardex0_.art_service_time’ in ‘field list’
- MySQL error 1054 (42s22) unknown column ‘password’ in ‘field list’
- Unknown column ‘Password‘ in ‘field list‘
- MySQL unknown column ‘in’ field list ‘solution
- MySQL ERROR 1054 (42S22): Unknown column’password’ in’field list’ error
- MySQL password setting error message: error 1054 (42s22): unknown column ‘password’ in ‘field list’
- MySQL error: column ‘ID’ in field list is ambiguous
- In the SQL query statement, add the column that does not exist in the table and set the fixed value of the column
- Error attempting to get column time from result set. Cause: java.sql.SQLFe
- Cause: java.sql.SQLException: invalid column type: 1111 Error [How to Fix]
- Field xxxMapper in com.xxx.service.impl.xxxServiceImpl
- Use xx [‘xx ‘] = XX to set field value or does not support field: XXX
- Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the
- Start error: field xmapper in com.xxx.service . impl.xxxServiceImpl required a bean of type
- Word column after the text evenly distributed in the left and right two columns, rather than fill in the left column and then fill in the right column, how to do?
- Error attempting to get column ‘xxxxx’ from result set — after Lombok is annotated with builder, mybatis cannot recognize the correct type of field
- SQL error: 17006, sqlstate: 99999 invalid column name
- JNI calls the add function of list in Java to flash back
- Solution to the problem that SQL database query result field contains new line character, which leads to copy to excel dislocation
- How many pieces of data can list store in Java?