Updating xml using java
To read, write and update XLSX, we can use Apache POI API. There are methods and classes in POI that makes excel processing very easy.
If the process is repeating only once every five minutes and from one point, I would not worry about connection pooling.Of course, it depends on how large and complicated your XML file is for how long it will take.As Shaggy Moose said, you probably don't need to do any DB connection pooling unless the same application will also be hitting the DB at the same time for other reasons.To write an XLSX, start reading XLSX file using File Input Stream. Pass this stream to XSSFWorkbook and get XSSFSheet.