Hibernate: Create Mysql InnoDB tables instead of MyISAM

by

Can’t you specify the Hibernate dialect and use 

hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect

Edit

From MySQL version > 5.1 this should be

hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect

to avoid running into this issue Using “TYPE = InnoDB” in MySQL throws exception

More Related Contents:

  1. Hibernate: Automatically creating/updating the db tables based on entity classes
  2. No Dialect mapping for JDBC type: 1111
  3. @GeneratedValue polymorphic abstract superclass over MySQL
  4. Spring boot JPA insert in TABLE with uppercase name with Hibernate
  5. When are connections returned to the connection pool with Spring JPA (Hibernate) Entity Manager?
  6. Mapping PostgreSQL JSON column to a Hibernate entity property
  7. Error creating bean with name ‘entityManagerFactory’ defined in class path resource : Invocation of init method failed
  8. Connection to Db dies after >4
  9. How to choose the id generation strategy when using JPA and Hibernate
  10. JPQL Create new Object In Select Statement – avoid or embrace?
  11. Spring Boot + JPA : Column name annotation ignored
  12. Hibernate, @SequenceGenerator and allocationSize
  13. What is the difference between Unidirectional and Bidirectional JPA and Hibernate associations?
  14. JPA/Hibernate Native Queries do not recognize Parameters
  15. What is the easiest way to ignore a JPA field during persistence?
  16. Default fetch type for one-to-one, many-to-one and one-to-many in Hibernate
  17. @Transactional method called from another method doesn’t obtain a transaction
  18. @PreUpdate and @Prepersist in hibernate/JPA (using session)
  19. Hibernate bidirectional @ManyToOne, updating the not owning side not working
  20. JPA how to make composite Foreign Key part of composite Primary Key
  21. Hibernate/JPA DB Schema Generation Best Practices
  22. How to set a default query timeout with JPA and Hibernate?
  23. How to map sql native query result into DTO in spring jpa repository?
  24. Persisting UUID in PostgreSQL using JPA
  25. Batch inserts with JPA/EJB3
  26. How to force Hibernate to return dates as java.util.Date instead of Timestamp?
  27. Is there a more efficient way of making pagination in Hibernate than executing select and count queries?
  28. Spring, JPA, and Hibernate – how to increment a counter without concurrency issues
  29. Change Table Name of an Entity on runtime? [duplicate]
  30. Unable to get multiple Table entities through Stored procedure using hibernate

Leave a Comment