File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Santanu Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Santanu" Watch "Santanu" New topic


San De

Joined: Sep 14, 2008
Posts: 1
I need to insert multiple row into a table by using a stored procedure.I set the input parameter for this SP inside a foor loop and execut this SP. but I think its very costly. because inside a for loop every time i am calling sp.execute. suggest me the most efficient way to insert multiple records inside a table.
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 32815

I don't understand how the subject relates to your post.

The most efficient way to do multiple updates is to use JDBC batch updates. This reduces the number of database roundtrips.

Since this is about JDBC, I'll move it to our JDBC forum for you.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
subject: Santanu
jQuery in Action, 3rd edition