| More details about the setup can be found in this Stackoverflow question and its answer(s). Now using the Hibernate Filter annotation defining a condition results in the code working for H2, PostgreSQL and OracleDB as expected for both Hibernate legacy quotes (backtip) as well as JPA quotes (\"), but for MariaDB it only works for the legacy quotes. @Entity
@Table(name = "\"users\"")
@FilterDef(name = "activeUsers", parameters = @ParamDef(name = "active", type = "boolean"))
@Filter(name = "activeUsers", condition = "\"active\" = :active")
public class User { @Id private Long id; private boolean active; // getters/setters (not shown) } Changing Filter annotation line to Hibernate legacy quotes solves the issue for MariaDB making it work for all mentioned databases: @Filter(name = "activeUsers", condition = "`active` = :active") |