When updating an interface written by others before debugging, the front end always reports an error, exceptionmessage: null, similar to this format
the Java code sends a put request, The parameter requires a class
this is the field to be transferred during swagger UI test
this is the field of this class in the database table
it is not difficult to find that there are more fields in the class than in the database table, The only fields in the SQL statement that need to be modified are these
so I changed all the parameters to be transmitted to the parameters required by the SQL statement. The test was successful
then go to the front end. The front end fields correspond to the fields of the SQL statement. Some fields have and some do not, The parameters required by SQL can be changed uniformly. There is an episode in the middle. The front-end field name is different from the back-end field name, and this error is also reported.
Summary:
Exceptionmessage: null is mostly due to the inconsistency between SQL fields and database table fields or the different definitions of front and rear field names
Read More:
- Mybatis Error setting non null for parameter #15 with JdbcType null Could not set parameters for
- [Solved] MySQL: datetime (0) null default NULL
- [Solved]ERROR 1067 (42000): Invalid default value for ‘end_time‘ Mysql
- [Solved] Worker 1 failed executing transaction ‘ANONYMOUS‘ at master log mall-mysql-bin.000001, end_log_pos
- Cause: java.sql.SQLException: ORA-01407: Unable to update (“MESIRJ”.”TMMIC01″.”RDEL”) is NULL
- [How to Fix]Mybatisplus ignores mapped fields
- SqlSugar Connect MySql 8.0.29 Error [How to Solve]
- Mybatis Add Datas error: ERROR: Field * doesn‘t have a default value
- [SQL ERROR] SQL Error: could not execute statement & query did not return a unique result: 2; nested excepti
- MYSQL Insert Data Error: check the manual that corresponds to your MySQL server version for the right syntax
- MySQL 8.0 error 1114 (HY000): the table’sbtest1’is full (Fixed)
- [Solved] ERROR 1054 (42S22): Unknown column ‘password‘ in ‘field list‘
- [Solved] Hive Find Error: FAILED: RuntimeException java.lang.RuntimeException: cannot find field
- [Solved] Mysql Error: [Err] 1136 – Column count doesn‘t match value count at row 1
- C# Connect MYSQL Error: MySql.Data.MySqlClient.MySqlException:“SSL Connection error.”
- Problems in connecting mysql8.0 in IDEA [How to Solve]
- [Solved] pymysql.err.ProgrammingError: (1064, ‘You have an error in your SQL syntax;
- [MySQL] mysql 5.5 and 5.6 timestamp default default value CURRENT_TIMESTAMP problem
- [Solved] Daily further: database error: unknown column ‘model’ in ‘field list‘
- [Solved] sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1064, “You have an error in your SQ