# 2nd level cache with multiple sources
**URL:** https://discourse.hibernate.org/t/2nd-level-cache-with-multiple-sources/8041
**Category:** Hibernate ORM
**Created:** [July 26, 2023, 3:57pm UTC](https://discourse.hibernate.org/t/2nd-level-cache-with-multiple-sources/8041 "2023-07-26T15:57:05Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@Anton](https://discourse.hibernate.org/u/Anton)
#### Post date: [July 26, 2023, 3:57pm UTC](https://discourse.hibernate.org/t/2nd-level-cache-with-multiple-sources/8041/1 "2023-07-26T15:57:05Z")
Hello,
I need some help because I have added 2 data sources to my project which actually seemed to be working fine, so I decided to add ehcache as a 2nd level cache and discovered that for the data source which is annotated as `@Primary`, query caching isn’t working, even though there are hits - it generates selects every time. For the alternative datasource it works just fine. How did I found it out - just removed `@Primary` annotation from one data source and added to another and the situation got inverted. I guess it has something to do with the SessionFactories, but I don’t know what kind of configuration should be done nor I can find decent info about it.
PS: there are only 2 entities for each data source, very basic, with no relations and `@Cacheable` + `@org.hibernate.annotations.Cache` annotations. Also there are 2 repositories which do extend JPARepository and both have `@QueryHints` annotations in order to cache queries (queries are very simple - looking for an object by single value, which are not the PK). In terms of project Im using ehcache 3+, Hibernate 6+, SpringBoot 3+
Thanks in advance
---
### Author:  [@beikov](https://discourse.hibernate.org/u/beikov)
#### Post date: [July 26, 2023, 4:55pm UTC](https://discourse.hibernate.org/t/2nd-level-cache-with-multiple-sources/8041/2 "2023-07-26T16:55:17Z")
This is a Hibernate forum, not a Spring forum. Since caching works fine for one persistence unit but not the other, the problem is certainly in your configuration, but you should better ask these questions in Spring forums.
---
### Author:  [@Anton](https://discourse.hibernate.org/u/Anton)
#### Post date: [July 26, 2023, 10:07pm UTC](https://discourse.hibernate.org/t/2nd-level-cache-with-multiple-sources/8041/3 "2023-07-26T22:07:00Z")
Already did, but no replies so far =( Ok, thanks, will keep investigating.