removed pessimisitic lock because it doesnt work with derby embedded