added loading methods and changed check select before commit insertion