hibernate.dialect 관련 질문입니다.

persistence.xml파일 내부에 dialect를 기본으로 작성하면 아래처럼 에러가 발생하여 인터넷 검색을 통해 해결하였습니다.

그러나 수정한코드에는 선이그어져 있어서 사용하면 안된다는 의미인것같아서요

문제는 해결했는데 정확한 원인을 모르고 넘어가는것같아 답답하여 질문합니다.

결론: 같은 dbms안에서도 방언의 종류가 여러종류인지 이런걸 판단하는 방법이 무엇인지 알고싶습니다.

  ex) mysqldialect vs mysql5dialect  vs mysql5innodialect

mysql사용 에러발생

-> mysql5Inno사용 에러미발생 그러나 deprecated 메세지 발생

-> mysql5사용 해결완료

에러내용: 

<property name="hibernate.hbm2ddl.auto" value="create"/>

위처럼 테이블을 삭제하고 자동 생성해주는 코드 추가시 발생하는 에러였습니다.

1. mysqldialect방언 사용시 : type=MyISAM을 맨뒤에 붙이면서 에러가발생합니다.

    create table Member (

       id bigint not null auto_increment,

        age integer,

        name varchar(255),

        primary key (id)

    ) type=MyISAM

2. mysql5innodbdialec방언 사용시: engine=InnoDB을 맨뒤에 붙이면서 쿼리가 잘 작동합니다.

    create table Member (

       id bigint not null auto_increment,

        age integer,

        name varchar(255),

        primary key (id)

    ) engine=InnoDB

에러전문------------------

ibernate: 

    create table Member (

       id bigint not null auto_increment,

        age integer,

        name varchar(255),

        primary key (id)

    ) type=MyISAM

10월 28, 2020 10:09:03 오전 org.hibernate.resource.transaction.backend.jdbc.internal.DdlTransactionIsolatorNonJtaImpl getIsolatedConnection

INFO: HHH10001501: Connection obtained from JdbcConnectionAccess [org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator$ConnectionProviderJdbcConnectionAccess@2d5ef498] for (non-JTA) DDL execution was not in auto-commit mode; the Connection 'local transaction' will be committed and the Connection will be set into auto-commit mode.

10월 28, 2020 10:09:03 오전 org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException

WARN: GenerationTarget encountered exception accepting command : Error executing DDL "

    create table Member (

       id bigint not null auto_increment,

        age integer,

        name varchar(255),

        primary key (id)

    ) type=MyISAM" via JDBC Statement

org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "

    create table Member (

       id bigint not null auto_increment,

        age integer,

        name varchar(255),

        primary key (id)

    ) type=MyISAM" via JDBC Statement

at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)

at org.hibernate.tool.schema.internal.SchemaCreatorImpl.applySqlString(SchemaCreatorImpl.java:439)

at org.hibernate.tool.schema.internal.SchemaCreatorImpl.applySqlStrings(SchemaCreatorImpl.java:423)

at org.hibernate.tool.schema.internal.SchemaCreatorImpl.createFromMetadata(SchemaCreatorImpl.java:314)

at org.hibernate.tool.schema.internal.SchemaCreatorImpl.performCreation(SchemaCreatorImpl.java:166)

at org.hibernate.tool.schema.internal.SchemaCreatorImpl.doCreation(SchemaCreatorImpl.java:135)

at org.hibernate.tool.schema.internal.SchemaCreatorImpl.doCreation(SchemaCreatorImpl.java:121)

at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:156)

at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:73)

at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:316)

at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:469)

at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1259)

at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:56)

at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:79)

at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:54)

at hellojpa.JpaMain.main(JpaMain.java:10)

Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'type=MyISAM' at line 6

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)

at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)

at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:764)

at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648)

at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)

... 15 more