Generationtarget encountered exception accepting command : error executing ddl via jdbc statement

Question

Problem :

I am a completely novice in the hibernate world and facing below error,

WARN: GenerationTarget encountered exception accepting command : Error executing DDL via JDBC Statement org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL via JDBC Statement

The exception while I run the stand-alone program in the hibernate 5.2.9 version. But in the hibernate 4 version all my code runs very well. I looked for many solutions but they are not working for me.

Answer 1

You must try the different dialects as follows

org.hibernate.dialect.MySQL5Dialect

or org.hibernate.dialect.MySQLMyISAMDialect or org.hibernate.dialect.MySQLInnoDBDialect 

to see which one exactly works for you.

It seems your current dialect is generating the type=MyISAM while it should be the  ENGINE=MyISAM in your create table query.

The mysql error 'TYPE=MyISAM'

Your logs are showing that following query was tried to be executed , 

create table MyTable (id integer not null, name varchar(255), primary key (id)) type=MyISAM 

So you should try to execute the query directly on the mysql command prompt to see if that properly works for the MySQL version.

OR

You are using the updated version of MySQL but using the very old dialect

You should use either,

<property name="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</property>

OR below one

<property name="hibernate.dialect">org.hibernate.dialect.MySQL8Dialect</property>

in your hibernate.cfg.xml file.

This will prevent you from getting the dialect issues