The project updates data in batches. There is no problem with mybatis writing and SQL, and there is no problem with the data, but this error is reported.
Solution:
The configuration of database URL needs to add a parameter allowMultiQueries:
url: jdbc:mysql://${ip}:${port}/${dbname}?allowMultiQueries=true
Read More:
- Mybatis Add Datas error: ERROR: Field * doesn‘t have a default value
- [Solved] The number of rows returned by the mybatis UPDATE statement is always 1 or useaffectedrows = true
- [Solved] sqoop Import Datas to mysql error: ERROR tool.ExportTool: Error during export: Export job failed
- Cannot resolve classpath entry: e://jar/mysql-connector-java-5.1.17-bin mybatis error in reverse engineering
- Using Mybatis to connect to the database error: Loading class `com.mysql.jdbc.Driver‘. This is deprecated. The new driver···
- MYSQL Safe Upgraded Error: You are using safe update mode and you tried to update
- [Solved] MySQL Execute update error: error code: 1175
- Mysql Flashback Warning: C:\Program Files\MySQL\MySQL Server 8.0\bin\mysql.exe
- [Solved] ERROR 2002 (HY000): Can’t connect to local MySQL server through socket’/var/lib/mysql/mysql.sock’ (2)
- [Solved] MYSQL Command Execute Error: Can ‘t connect to local MySQL server through socket ‘/tmp/mysql.sock ‘(2) “
- Mybatis Error: The server time zone value ‘����1532a0’ is unrecognized
- How to Solve can‘t connect to local mysql server through socket ‘/var/lib/mysql/mysql.sock‘
- MySql Install Error: Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock‘
- ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’
- MYSQL Enter password:ERROR 2003 (HY000): Can‘t connect to MySQL server on ‘localhost:3306‘
- MYSQL Insert Data Error: check the manual that corresponds to your MySQL server version for the right syntax
- [Solved] Django configures MySQL Error: NameError: name ”_MySQL ‘is not defined
- MYSQL: CURRENT_TIMESTAMP & ON UPDATE CURRENT_TIMESTAMP
- C# Connect MYSQL Error: MySql.Data.MySqlClient.MySqlException:“SSL Connection error.”
- Can mybatis prevent SQL injection