private List<Map<String, Object>> getData(final int id) {
        IDBI dbi = new DBI(ds);
        Handle h = null;
        try {
            h = dbi.open();
            return h.createQuery("select id,username,linkedid,password,serializedprofile from users where id = :id").bind("id", id).list(2);
        } finally {
            if (h != null) {
                h.close();
            }
        }
    }
Tests the {@link DbProfileService}.

@author Jerome Leleu
@since 1.8.0
pac4j-sql/src/test/java/org/pac4j/sql/profile/service/DbProfileServiceTests.java