Importing data to h2db

Asked Dec 17 '20 at 11:33

Active Dec 17 '20 at 11:56

Viewed 84 times

I have .sql files that have only insert statements. While importing those to the already exists h2db.mv.db(Version 1.4.192) file I am getting the below error

Exception in thread "main" org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException: Unique index or primary key violation: "PUBLIC.CONSTRAINT_INDEX_C ON PUBLIC.GROUPS(ID) VALUES 1"; SQL statement:

The command for importing statements is

java -cp h2-1.4.199.jar org.h2.tools.RunScript -url jdbc:h2:file:./h2db -script dump.sql

edited Dec 17 '20 at 11:56

asked Dec 17 '20 at 11:33

Shubham kapoor

INSERT IGNORE is your friend. – maio290 Dec 17 '20 at 11:38
apologise didn't understand your point @maio290 – Shubham kapoor Dec 17 '20 at 11:43
No offence, but I doubt that you actually understand anything you're doing then. – maio290 Dec 17 '20 at 11:48
you are saying to use "insert ignore" instead of insert? – Shubham kapoor Dec 17 '20 at 11:49

Importing data to h2db

0 Answers0