The reason for the autocommit is because you commit the holliday list first and since they are attached to a newProvince object that one is autocommitted. You should always commit the parent object first before you commit the child objects. And never try to commit inside iterations. Create two lists before the iteration (province and holidays) and after the iteration then commit the province list and then the holiday list both.
Regards,
Ronald
Hi Subhrajit Pagal,
When you start the build-in DB viewer, do you see the records there? If so, the DataSource Microflow is not correct. Also, you could just retrieve the list from the database without an XPath...
Go Make It.