Possibility of inserting many rows in to table with single database hit

Question

I came across this scenario where I have to insert some 100 rows into my table using the Java application that I support.

I do not want my application to hit the DB every time with the insert query to do this.

Can you suggest some idea for me to insert all those 100 rows in to that table with a single DB hit.

score 2 · Accepted Answer · answered Jul 17 '12 at 14:18

2

You can do batch query processing for this purpose.

answered Jul 17 '12 at 14:18

kosa

1 Answers1