added select and fetchOne to service table adapter