Hibernate import.sql error in sql syntax: Unsuccessful: INSERT INTO

Question

In Spring boot app I'm trying to load on startup import.sql file with my sql schema for testing app. Weird problem because the same sql file works when I'm adding its by hand to my DB.

sample of import.sql:

INSERT INTO car
(name, description, price) VALUES
('Audi Q7', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse libero ex.', 150),
('Audi A4', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse libero ex.', 79.99),
...

spring boot startup listing:

Listing on GitHubGist

sample of error:

HHH000388: Unsuccessful: INSERT INTO car
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 '' at line 1
HHH000388: Unsuccessful: (name, description, price) VALUES
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 'name, description, price) VALUES' at line 1
...

Some JPA providers support "new line" syntax (e.g DataNucleus), and some don't. Yours doesn't. — Neil Stockton
– Neil Stockton, Commented Mar 8, 2017 at 7:14

Naros · Accepted Answer · 2017-03-07 21:54:10Z

4

That is because the entries in import.sql shouldn't span multiple lines. Hibernate reads it per line and executes each line read as a single statement.

answered Mar 7, 2017 at 21:54

Naros

21.3k4 gold badges50 silver badges80 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Juergen Zimmermann Over a year ago

See also stackoverflow.com/questions/4674828/…

Collectives™ on Stack Overflow

Hibernate import.sql error in sql syntax: Unsuccessful: INSERT INTO

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related