本文介绍了Spring Boot 2.0.x上的InnoDB?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

请在Spring Boot 2.0.x中如何配置"hibernate.dialect.storage_engine = innodb"属性?

How to configure the "hibernate.dialect.storage_engine = innodb" property in Spring Boot 2.0.x, please ?

  • Spring Boot 2.0.5.RELEASE
  • MySQL Community Server 8.0.11

application.properties:

application.properties:

spring.jpa.hibernate.ddl-auto=create-drop
spring.jpa.properties.hibernate.format_sql=true
spring.jpa.properties.hibernate.dialect.storage_engine=innodb
spring.jpa.show-sql=true

MySQL服务器变量:

MySQL Server Variables:

default_storage_engine=InnoDB
default_tmp_storage_engine=InnoDB

Spring Boot Console输出:

Spring Boot Console output:

Hibernate:

    drop table if exists person
Hibernate:

    create table person (
       id bigint not null auto_increment,
        address varchar(255),
        age integer,
        city varchar(255),
        info varchar(255),
        telephone varchar(255),
        zip_code varchar(255),
        email varchar(255) not null,
        first_name varchar(255) not null,
        last_name varchar(255) not null,
        version bigint,
        primary key (id)
    ) engine=MyISAM

推荐答案

您可以尝试以下操作:

spring.jpa.database-platform: org.hibernate.dialect.MySQL5InnoDBDialect

这篇关于Spring Boot 2.0.x上的InnoDB?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

09-02 05:04