Batch Processing has to be concerned during enterprise application design and integration test.
Batch Processing Concerns
Normally, it refer to three problems.
Memory Resource consuming
There could be Memory Leak, OutOfMemoryException or consume bulk heap size to slow down the platform response time.
Data Synchronization with Database
We must make sure that to be updated data would be properly updated in database.
Database I/O consuming
Batch Processing means communicate with Database many times, it could lead to many SQL operation which manipulate huge I/O read/write.
Batch Processing Solution
Hibernate Batch Processing
Batch Processing by using JDBC API
- Using JDBC API to call SQL directly
- Using JDBC API to call Procedure directly