How to apply multi-tenant filtering (e.g., hospitalId) using Hibernate filters with Spring Data JPA in the same database and schema?

Question

I’m building a multi-tenant Spring Boot application where all tenants share the same database and schema, but data is separated by a hospital_id column in each table.

Here’s my setup:

Same database
Same schema
Tables have a hospital_id column

I want to automatically filter data per tenant (hospitalId) without adding WHERE hospital_id = :hospitalId manually in every query.

@Entity
@FilterDef(name = "hospitalFilter", parameters = @ParamDef(name = "hospitalId", type = "string"))
@Filter(name = "hospitalFilter", condition = "hospital_id = :hospitalId")
public class PatientEntity {
    @Id
    private Long patientId;

    @Column(name = "hospital_id")
    private String hospitalId;

    // other fields
}

I tried using Hibernate filter, but I think this is not working with jpa repo.

If you're working in a medical environment, I suspect you should use separate databases or schemas. Would that not also simplify this design? — halfer
– halfer, Commented Jun 14 at 21:49
@halfer Yes, separating databases or schemas is a good idea. But in my case, all hospitals use the same schema, so having different databases or schemas can be costly and harder to manage. — Himanshu Sharma
– Himanshu Sharma, Commented Jul 5 at 16:38

halfer · Accepted Answer · 2025-06-14 21:49:42Z

2

You can use Hibernate Filter with Spring Boot JPA but you have to enable it. I think you are missing the code to enable it.

Refer to Using Hibernate Filter with Spring Boot JPA and How can I activate hibernate filter in Spring Boot. (This one contains Git repo as an example too).

edited Jun 14 at 21:49

halfer

20.2k20 gold badges110 silver badges207 bronze badges

answered Jun 1 at 15:49

Yasin Ahmed

18110 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Himanshu Sharma Jun 6 at 17:13

Thanks, Yasin! It worked perfectly. However, I have one more question: it's working fine for the findAll() method, but when I call findById(), the filter isn’t being applied

Rajind Ruparathna Jul 25 at 7:37

As per Hibernate docs, "Filters apply to entity queries, but not to direct fetching." - docs.jboss.org/hibernate/orm/5.6/userguide/html_single/…

Collectives™ on Stack Overflow

How to apply multi-tenant filtering (e.g., hospitalId) using Hibernate filters with Spring Data JPA in the same database and schema?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related