we are using the SampleJdbcTemple (in processor) in our spring batch application. it process million of records , so it taking more time for the database operation, so we looking some other alternative connect the database. give me suggestion to overcome the issue??
reader----->processor( using the SampleJdbcTemple for querying) ------>writer
1. we are processing million of records , so for each record it hits the database. Is SampleJdbcTemple leads to open and close the connection for each record or ??, If it Yes, how to manage it??
2. Is it there connection pooling in spring batch?, If Yes, how to configure and implement that??