java - jooq 3.11.9 与 MySQL 版本 8.0.11

Question

我使用的是 jooq 版本 3.11.9，并且我的本地安装了 MySQL 版本 8.0.11。在启动 jooq 与 Mysql 的连接时，出现以下错误:

org.jooq.exception.DataAccessException: SQL [select 1 as `one` from dual where exists (select 1 as `one` from `mysql`.`proc`)]; Table 'mysql.proc' doesn't exist

我了解 MySQL Ver 8.0.11 不包含此表。那么解决办法是什么呢？我无法降级 MySQL 版本，因为其他项目已经使用此版本运行。

Answer 1

正如你在mysql中看到的Release notes :

Previously, information about stored routines and events was stored in the proc and event tables of the mysql system database. Those tables are no longer used. Instead, information about stored routines and events is stored in the routines, events, and parameters data dictionary tables in the mysql system database. The old tables used the MyISAM (nontransactional) storage engine. The new tables use the InnoDB (transactional) engine.