How to query from multiple tenants in a single request?

[seepine]

Background

CustomTenantResolver.java

@PersistenceUnitExtension
@RequestScoped
public class CustomTenantResolver implements TenantResolver {

  @Override
  public String getDefaultTenantId() {
    return TenantUtil.NONE.toString();
  }

  @Override
  public String resolveTenantId() {
    var tenantId = TenantUtil.getTenantId().toString();
    System.out.println("resolve tenantId " + tenantId);
    return tenantId;
  }
}

TenantUtil

public class TenantUtil {

  private static final ThreadLocal<Serializable> tl = new ThreadLocal<>();
  public static final Serializable ROOT = "-1";
  public static final Serializable NONE = "-999";

  public static void clear() {
    tl.remove();
  }

  public static Serializable getTenantId() {
    return tl.get();
  }

  private static void setTenantId(Serializable tenantId) {
    tl.set(tenantId);
  }
}

TenantFilter

@Priority(0)
@Provider
public class TenantFilter implements ContainerRequestFilter, ContainerResponseFilter {
  @Override
  public void filter(ContainerRequestContext requestContext) {
    String tenantId = requestContext.getUriInfo().getQueryParameters().getFirst("tenantId");
    TenantUtil.setTenantId(Objects.requireNonNullElse(tenantId, TenantUtil.NONE));
  }

  @Override
  public void filter(
      ContainerRequestContext requestContext, ContainerResponseContext responseContext) {
    TenantUtil.clear();
  }
}

RoleResource

@Path("/role")
public class RoleResource {

  @Inject RoleRepository roleRepository;

  @GET
  @Path("list")
  public List<SysRole> list() {
    return roleRepository.select().fetch();
  }

  @GET
  @Path("test")
  public void test() {
    TenantUtil.setTenantId("123");
    System.out.println(roleRepository.select().fetch());
    TenantUtil.setTenantId("456");
    System.out.println(roleRepository.select().fetch());
  }

}

Expected

curl http://127.0.0.1/role/list?tenantId=123

[{"id":"1", "tenantId": "123"}]

curl http://127.0.0.1/role/list?tenantId=456

[{"id":"2", "tenantId": "456"}]

Problem

curl http://127.0.0.1/role/test

[{"id":"1", "tenantId": "123"}]
[]

The CustomTenantResolver.resolveTenantId only executed once

[seepine]

@yrodiere Hi, can you give me some suggestion about this?

[yrodiere]

Hi, already did: https://stackoverflow.com/questions/76985783/how-to-query-from-multiple-tenants-of-hibernate6-in-a-single-request/76990686#76990686
Please don't duplicate your questions >_< Asking just here or just on stackoverflow would be enough.

[seepine]

Okay, because there was no response after several days of questioning.

[yrodiere]

Well I don't work on weekends. Please be patient ;)