database pool may contains connections with auto commit fasle which leads to not adding entries hence set auto comit value to true befor insertions and updates