The Java project reported a 500 error after opening the mysql binlog parameter:

Problem:

Cannot execute statement:impossible to write to binary log since Binlog_format = statement and at least one table uses a Storage Engine limited to row-based logging. InnoDB is limited to row-logging while transaction isolation level is read COMMITTED or READ uncommitted.

Thinking Process:

Combined with the Baidu discovery is the Java Transaction Working mode requirements of the log format for row, and I opened binlog after the operation mode is not specified, and MySQL default log working mode is statement mode,

can go into MySQL using show variables like "Binlog_format"; is to turn on Binlog unspecified format:

Workaround:

Modify the MY.CNF configuration file in the MYSQLD block add: Binlog_format = row parameter and restart the MySQL service.

Results:

To view the log format as row, the project can be accessed normally and the problem is resolved.

The Java project reported a 500 error after opening the mysql binlog parameter: