No table comments are generated (Mysql)

[erengong]

The new version of swagger annotation does not generate table annotations.

[carter-ya]

Maybe you should reset your tempalte.

[erengong]

The problem seems to still exist, the table comment cannot be generated.

[carter-ya]

What version of mysql driver are you using?

You can try use this version mysql-connector-java-8.0.23

[erengong]

Previously I used 8.0.22, this time I used 8.0.23, the same effect.

[carter-ya]

Can you provide the table schema and mysql database version?

[erengong]

mysql database version: 5.6.27-log
table schema:

CREATE TABLE `t_auth_role` (
    `f_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
    `f_platform` tinyint(4) NOT NULL COMMENT '所属平台(1-平台管理/2-代理商管理/3-企业管理)',
    `f_corp_id` bigint(20) NOT NULL COMMENT '企业ID',
    `f_name` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '权限名称',
    `f_super_admin` tinyint(1) NOT NULL DEFAULT '0' COMMENT '超级管理员',
    `f_remark` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '备注',
    `f_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '已删除(true-是/false-否)',
    `f_operator` bigint(20) NOT NULL DEFAULT '0' COMMENT '操作者ID',
    `f_create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `f_update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
    PRIMARY KEY (`f_id`),
    KEY `idx_corp_id` (`f_corp_id`)
) ENGINE = InnoDB AUTO_INCREMENT = 685 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '权限管理 - 角色表'

[erengong]

I don’t think it’s a problem with the table schema, because all my tables have this problem, since the new version of the idea-plugin.

[carter-ya]

Maybe you should refer to this answer: Retrieve mysql table comment using DatabaseMetaData

[carter-ya]

[erengong]

perfect! Just add this parameter: useInformationSchema=true.Thank you very much.