udayagiri-sivasai-dev opened a new pull request, #5956: URL: https://github.com/apache/fineract/pull/5956
## Description This PR addresses FINERACT-1788 by replacing native SQL/JdbcTemplate usage in the Notifications read platform service with Spring Data JPA/JPQL repository methods. Changes made: - Added JPQL queries in `NotificationMapperRepository`. - Replaced unread notification checks with repository-based JPQL. - Replaced notification read-status update with a repository update query. - Replaced notification list fetching with JPQL projection into `NotificationData`. - Removed old `JdbcTemplate`, `RowMapper`, and native SQL query code from `NotificationReadPlatformServiceImpl`. - Updated `NotificationConfiguration` constructor wiring after removing old JDBC dependencies. Validation performed: - Ran `spotlessApply`. - Ran `:fineract-provider:compileJava` successfully. - Verified no `JdbcTemplate`, `RowMapper`, `nativeQuery`, `createNativeQuery`, or `String sql` usage remains in the notification module. - Ran `git diff --check`. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
