This is an extract of running code, that performs batch inserts into databases based on JMS messages of either explicit SQLs or prepared statements.
The component is Spring based.
Donated by onSMSC Ltd and released under the Apache License 2.0.
Add dependency to
groupId: com.onsmsc
artifactId: db-shovler
version: 1.0.10
Add the ShovlerBean to your applicationContext as shown in the IT test.
Return of the disappearing setMaxBatchSize()
Stability - handle all DataAccessExceptions
Pause on TransientDataAccessException
Small fix to handle Spring's very own JmsException
Some release-plugin screwups untangled.
Available in Sonatype's OSS repository
- Setter for maxBatchSize
- Oracle responses
Poll messages from JMS destination and use a converter to feed a JDBC batch statement.