Sign in Subscribe

Topic

Spring Data JPA

A collection of 2 issues

Ensuring Smooth Spring Boot Testing with Oracle-Style Queries in H2 Database

Are you facing issues running Spring Boot tests due to Oracle-specific functions not being recognized in your H2 in-memory database? If so, you're not alone. Many developers encounter difficulties when testing Spring Boot applications that rely on Oracle-specific features like DUAL, SYSDATE, TO_DATE, or rownum. Fortunately, there's a straightforward

why your Spring Data JPA query so slow? took more than 10 mins to just fetch 100 thousands records

We encountered a query performance issue which took more than 10 minutes to complete a query from a table which has 100 thousands records. We are using Spring Data JPA framework. We thought the framework shouldn't be quite slow. 100,000 records is not too much. After google search, find