Invalid syntax error “type= MyISAM” in DDL generated by Hibernate

by

The problem is that – in Hibernate 5.x and earlier – the dialect org.hibernate.dialect.MySQLDialect is for MySQL 4.x or earlier. The fragment TYPE=MYISAM that is generated by this dialect was deprecated in MySQL 4.0 and removed in 5.5.

Given that you use MariaDB, you need to use (depending on the version of MariaDB and – maybe – the version of Hibernate) one of:

  • org.hibernate.dialect.MariaDBDialect
  • org.hibernate.dialect.MariaDB53Dialect
  • or higher versions (e.g. org.hibernate.dialect.MariaDB106Dialect)

If you are using MySQL, or if the above two dialects for MariaDB don’t exist in your version of Hibernate:

  • org.hibernate.dialect.MySQL5Dialect
  • org.hibernate.dialect.MySQL55Dialect
  • org.hibernate.dialect.MySQL57Dialect
  • org.hibernate.dialect.MySQL8Dialect
  • or variants of these dialects (e.g. org.hibernate.dialect.MySQL57InnoDBDialect)

More Related Contents:

  1. Hibernate 5 :- org.hibernate.MappingException: Unknown entity
  2. Using Hibernate’s ScrollableResults to slowly read 90 million records
  3. The server time zone value ‘AEST’ is unrecognized or represents more than one time zone
  4. Unable to get spring boot to automatically create database schema
  5. Hibernate: Automatically creating/updating the db tables based on entity classes
  6. No Dialect mapping for JDBC type: 1111
  7. @GeneratedValue polymorphic abstract superclass over MySQL
  8. Spring boot JPA insert in TABLE with uppercase name with Hibernate
  9. Can Hibernate work with MySQL’s “ON DUPLICATE KEY UPDATE” syntax?
  10. Spring, Hibernate, Blob lazy loading
  11. How can I use MySQL assign operator(:=) in hibernate native query?
  12. Enum in Hibernate, persisting as an enum
  13. When are connections returned to the connection pool with Spring JPA (Hibernate) Entity Manager?
  14. Hibernate Criteria Query to get specific columns
  15. com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed
  16. SQL Error: 0, SQLState: 08S01 Communications link failure [duplicate]
  17. Hibernate: Create Mysql InnoDB tables instead of MyISAM
  18. What is the MariaDB dialect class name for Hibernate?
  19. No matter what, I can’t batch MySQL INSERT statements in Hibernate
  20. com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source
  21. org.hibernate.InstantiationException: No default constructor for entity: : principal.Cliente
  22. Is there a more efficient way of making pagination in Hibernate than executing select and count queries?
  23. How to setup Hibernate to read/write to different datasources?
  24. Hibernate Criteria API: get n random rows
  25. Unable to get multiple Table entities through Stored procedure using hibernate
  26. Make hibernate backquote all table / column names
  27. Hibernate: flush() and commit()
  28. Apache Commons equals/hashCode builder [closed]
  29. com.mysql.jdbc.PacketTooBigException
  30. Different representation of UUID in Java Hibernate and SQL Server

Leave a Comment