How support multiple tenant root with hibernate6 ?

[seepine]

In Springboot

application.yml

spring:
  jpa:
    properties:
      hibernate:
        multiTenancy: true
        tenant_identifier_resolver: com.example.config.TenantResolver

TenantResolver.java

public interface CurrentTenantIdentifierResolver {
        // set tenant value
	String resolveCurrentTenantIdentifier();
   
        // true will query all tenant data
	default boolean isRoot(String tenantId) {
		return false;
	}
}

But in Quarkus 3.x

I can not find how to query ignore tenant like CurrentTenantIdentifierResolver .isRoot

application.properties

quarkus.hibernate-orm.multitenant=DISCRIMINATOR

CustomTenantResolver.java

@PersistenceUnitExtension
@RequestScoped
public class CustomTenantResolver implements TenantResolver {

  // what is this ?
  @Override
  public String getDefaultTenantId() {
    return "0";
  }

  @Override
  public String resolveTenantId() {
    return Optional.ofNullable(TenantUtil.getTenantId()).map(Serializable::toString).orElse(null);
  }
}

[quarkus-bot[bot]]

/cc @Sanne (hibernate-orm), @gsmet (hibernate-orm), @yrodiere (hibernate-orm)

[yrodiere]

As far as I can tell this is simply a missing feature.

If you need it, I'd suggest filing a feature request, and ideally a pull request that:

• adds the missing method to io.quarkus.hibernate.orm.runtime.tenant.TenantResolver
• implements isRoot() in

  quarkus/extensions/hibernate-orm/runtime/src/main/java/io/quarkus/hibernate/orm/runtime/tenant/HibernateCurrentTenantIdentifierResolver.java

  Line 18 in d7b4c51

  public final class HibernateCurrentTenantIdentifierResolver implements CurrentTenantIdentifierResolver {

• adds a simple test (checking you have access to all tenants) in integration-tests/hibernate-orm-tenancy/discriminator/src/main/java/io/quarkus/it/hibernate/multitenancy/fruit/CustomTenantResolver.java / integration-tests/hibernate-orm-tenancy/discriminator/src/main/java/io/quarkus/it/hibernate/multitenancy/fruit/FruitResource.java / integration-tests/hibernate-orm-tenancy/discriminator/src/test/java/io/quarkus/it/hibernate/multitenancy/fruit/HibernateTenancyFunctionalityTest.java

[seepine]

Hi, can I directly use hibernate org.hibernate.context.spi.CurrentTenantIdentifierResolver like this in quarkus?

spring:
  jpa:
    properties:
      hibernate:
        multiTenancy: true
        tenant_identifier_resolver: com.example.config.TenantResolver

[yrodiere]

I doubt it. You can always try using quarkus.hibernate-orm.unsupported-properties, but as the name of the property implies, it's unsupported (so if it doesn't work, the Quarkus team won't consider it a bug).

Really your best bet would be to contribute a patch for #35424

[seepine]

yes, i will contribute.

[seepine]

see pulls#35492