snapshot implementation added for h2 and mysql.