[spring] add more repository methods

also add more unit tests,
and correct wrong use of sequences