added test for both database adapter