Spring 3 jdbctemplate batch update

Still we can improve performance using multi threading concepts for insert queries. Following image illustrates a simple strategy on how we can perform batch inserts asynchronously. To improve execution time adjust values for spring. Like stated in 3.

Following is the execution results on 1. Still not up to the insert statement results, but shown much better results than earlier results. Checkout source code at GitHub. Save my name, email, and website in this browser for the next time I comment. Our primary goal is to provide simple and effective tutorials with well tested working examples for the all level of developers. All trademarks are the property of their respective owners, which are in no way associated with javabydeveloper.

Java is a trademark or registered trademark of Oracle Corporation. Examples at javabydeveloper is not connected to Oracle Corporation and is not sponsored by Oracle Corporation. Sign in. Note that we have taken the queries from a String array. Instead you may want to make it dynamically. For example: Note how we are creating query dynamically using data from Employee object and adding it in batch to insert in one go.

You must be thinking what about SQL Injection? Creating queries like this dynamically is very prone to SQL injection. And also the insert query has to be compiled each time. Why not to use PreparedStatement instead of simple Statement. Yes, that can be the solution. We used java. PreparedStatement and added insert query in the batch. This is the solution you must implement in your batch insert logic, instead of above Statement one.

Still there is one problem with this solution. Consider a scenario where you want to insert half million records into database using batch. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown.

The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses. Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Related 6. Hot Network Questions.