Win a copy of TDD for a Shopping Website LiveProject this week in the Testing forum!

meghan shirkhedkar

Greenhorn
+ Follow
since Aug 26, 2013
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by meghan shirkhedkar

Hi, I am very new to Spring and Spring batch. I have a requirement to parse csv file and write to db(oracle) through stored procedure. The stored procedure is already written and want to build solution on it. Can we use JDBCBatchItemWriter be used to execute stored procedure? Want to also benchmark performance with Spring batch.
Also if JDBCBatchWriter cannot be used to execute store procedure, which class is used to execute stored procedure to write to the database in Spring Batch.
Thanks in advance.
7 years ago

Saifuddin Merchant wrote:I would suggest you do some preliminary readying on Spring Batch

Spring Batch is different from JDBC batch statement - Spring Batch is an entire framework for Reading-->Processing or Transforming --> Writing Data. Spring Batch would provide features like partitioning data, re-starting from failure point, in-build readers and writers.

JDBC batch statement would be the underlying writer used in most cases during a JDBC write by the Spring batch framework. However that is just one use case of the entire framework.

if we try to convert JDBC batch processing to spring batch.


If you mean you have a custom batch processing framework that you intend to move to match that yes, I would say you might get some improvements in terms of performance, maintainability, standardization that comes with using a standard and well maintained framework.


Thanks for the information
8 years ago
Hi, I am very new to Spring framework. Have a question about SPRING BATCH. How different is Spring batch from the JDBC batch(PreparedStatment.addBatch()). Are there any improvements in terms of performance, if we try to convert JDBC batch processing to spring batch.
8 years ago