Missing Query Tag (ARCH4057)

Key java.orm.missing-query-tag · Severity info · Category orm

Not attaching a descriptive SQL comment/tag to queries makes source attribution in slow-query logs hard. Add a comment hint to the query.

Incorrect

@Query("SELECT u FROM User u WHERE u.tenantId = :id")
List<User> findByTenant(Long id);

Correct

@Query("SELECT u FROM User u WHERE u.tenantId = :id")
@QueryHints(@QueryHint(name = "org.hibernate.comment", value = "findByTenant"))
List<User> findByTenant(Long id);

Fix

Add a query comment/tag to terminal queries for log/APM correlation.