Hibernate Error Executing Ddl Via Jdbc Statement

Hibernate Error executing DDL via JDBC Statement

in your CFG file please change the hibernate dialect

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

Spring Boot Error executing DDL via JDBC Statement

I think your database does not support the InnoDB engine.
Try to replace

spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.MySQLInnoDBDialect

by

spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.MySQL5Dialect

Spring hibarnate error : Error executing DDL via JDBC Statement

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'mod integer not null, mod_cap varchar(255), msg integer not null, name varchar(2' at line 1

mod is the name of a function. You can't use it without escaping it. Change that variable name and it will work.

Alternatively, you can put this in your configuration to auto-escape all identifiers:

hibernate.globally_quoted_identifiers=true

Spring Boot Error executing DDL drop schema via JDBC Statement

Here's how I solved this.

I was already using a custom PostgreSQL dialect in my project. It's defined in a class that extends org.hibernate.dialect.PostgreSQL10Dialect. So I just added a method override for getDropSchemaCommand(String schemaName), and had it return a String starting with "drop schema if exists" instead of "drop schema".

The custom dialect has to be specified in the application.properties file, using spring.jpa.properties.hibernate.dialect.

how to resolve error executing ddl commands in spring boot

user is a reserved keyword in postgresql. Change your table name to something else, for example:

@Entity
@Table(name = "users")
public class User {

Error executing DDL "create table users (...)" via JDBC Statement

You need to remove ' from column name:

@Column(name = "username'", nullable = false)

->

@Column(name = "username", nullable = false)

DATABASE_TO_UPPER=FALSE also looks very suspicious, this setting should normally be used only with H2 1.4.197 and older versions, but this isn't related to your problem.

Error executing DDL "insert into ..." via JDBC Statement in Spring Boot

It seems like the insert query has been read like 3 separate queries. Try to change the import.sql to:

insert into currency_exchange(id, currency_from, currency_to) values (10001, 'USD', 'INR');

Not sure why you have the error though, I've tested it with the latest Hibernate ORM 5.6.9.Final and it worked fine.

Maybe it's a bug in the version you are using (should be 5.4.32).
Or maybe there's something else in the import.sql?

Spring boot exception error executing ddl

Spring boot probably was configured to have spring.jpa.hibernate.ddl-auto=update meaning it will update the schema to match the domain layer of spring application when needed.

Considering that the schema already contained some data (table records), Spring tried to update a table to have a constraint, but that constraint was not respected by the existing data so the DDL failed.

Cleaning the data of the mentioned table would probably allow spring to execute the DDL script to apply the aforementioned constraint.

Otherwise you can switch to spring.jpa.hibernate.ddl-auto=create where Spring will first remove all tables from database which would mean removal of existing data as well, and then recreate the schema. This would have as effect that no previous data would violate the constraint. Hence spring will be able to move forward with DDL.

---

Related Topics