How do I insert multiple rows WITHOUT repeating the “INSERT INTO" statement in hibernate java?

Asked Aug 01 '17 at 11:01

Active Aug 01 '17 at 12:44

Viewed 200 times

Can I create this type of SQL statement using hibernate in java.

INSERT INTO table1 (id,First, Last)
VALUES
(1,'Fred', 'Smith'),
(2'John', 'Smith'),
(3,'Michael', 'Smith'),
(4,'Robert', 'Smith');

INSERT INTO table2 (id,table1_id,age)
VALUES
(11,1, 35),
(12,2,24),
(13,3,32),
(14,3,31);

Actually, I am uploading a .csv file having very large amount of data. For that I want to create these type of insert statement for speedup the execution of CSV file.

How can I do so? Or there is any other way to do so?

edited Aug 01 '17 at 12:44

asked Aug 01 '17 at 11:01

unknownbits

2,855
10
41
81

yes you can did you tried something? or you want to start from scratch? – Youcef LAIDANI Aug 01 '17 at 11:26
@YCF_L I WANT TO START FROM SCRATCH. – unknownbits Aug 01 '17 at 11:35
Yes, you can try bulk-load database import utilities. – Ritesh K Aug 01 '17 at 11:37
@RiteshK can you send me the link of it for java hibernate ? – unknownbits Aug 01 '17 at 12:15
[LOAD DATA INFILE](https://stackoverflow.com/a/24170168/5070879) – Lukasz Szozda Aug 01 '17 at 12:33

How do I insert multiple rows WITHOUT repeating the “INSERT INTO" statement in hibernate java?

0 Answers0