Spring Data JPA VS hibernate-validator

Please note: The H2 database was chosen for simplicity. You can replace it with any other database technology and use the Spring Boot JPA to connect. The demo application will still work.

What you are trying to do is not supported in JPA/JPQL or Spring Data (see here) Not even all databases support that syntax as far as I'm aware. You either need to concat the columns or add functionality to do this yourself, perhaps a Hibernate UserType will work.

There was also a discussion in the Spring Data JPA project repo surrounding the documentation as well: https://github.com/spring-projects/spring-data-jpa/issues/2055

There is a small typo on the second issue, I have tried opening a PR myself to fix it https://github.com/spring-projects/spring-data-jpa/pull/2869. I hope i haven't messed up something lol.

data-jpa: Spring Data JPA, makes it easy to create JPA-based repositories

This repository is an example application for the Spring Boot framework that employs the Netflix DGS framework to expose a GraphQL API and that interacts with a PostgreSQL DBMS via Spring Data JPA.

I'm using Spring Data JPA as a persistence framework. Therefore, those classes are Hibernate entities.

By two different former developers, one from QueryDSL and the other RSQL JPA Spec (Criteria API), both mention that it is a Java issue mentioned here (since 2015...): https://github.com/spring-projects/spring-data-jpa/issues/1115

If you go with hibernate note that there are a few different ways to use it. It can be used standalone and it can be used as a JPA implementation. If you use Spring and use hibernate as a JPA implementation then a popular Spring data layer abstraction is Spring Data which has JPA support with its Spring Data JPA library (https://spring.io/projects/spring-data-jpa)

Why not use some tool like https://hibernate.org/validator/ ?

Without attempting to define 'right mind', Hibernate validator uses regex based email validation.

/* * This code is based on this PR: https://github.com/hibernate/hibernate-validator/pull/1199 * All credits to Daniel Heid (dheid). I just made some adjustments. * In order to apply this on your situation, just create this class and call the method "isValidStringUUID". As its param, pass in your string UUID. */ public class UUIDValidator { enum LetterCase { /** * Only lower case is valid */ LOWER_CASE, /** * Only upper case is valid */ UPPER_CASE, /** * Every letter case is valid */ INSENSITIVE } private static LetterCase letterCase = LetterCase.LOWER_CASE; private static final int[] GROUP_LENGTHS = { 8, 4, 4, 4, 12 }; public static boolean isValidStringUUID(String value) { if ( value == null ) { return false; } int valueLength = value.length(); if ( valueLength == 0 ) { return false; } else if ( valueLength != 36 ) { return false; } int groupIndex = 0; int groupLength = 0; int checksum = 0; for ( int charIndex = 0; charIndex < valueLength; charIndex++ ) { char ch = value.charAt( charIndex ); if ( ch == '-' ) { groupIndex++; groupLength = 0; } else { groupLength++; if ( groupLength > GROUP_LENGTHS[groupIndex] ) { return false; } int numericValue = Character.digit( ch, 16 ); if ( numericValue == -1 ) { // not a hex digit return false; } if ( numericValue > 9 && !hasCorrectLetterCase( ch ) ) { return false; } checksum += numericValue; } } // NIL UUID if ( checksum == 0 ) { return false; } return true; } private static boolean hasCorrectLetterCase(char ch) { if ( letterCase == null ) { return true; } if ( letterCase == LetterCase.LOWER_CASE && !Character.isLowerCase( ch ) ) { return false; } return letterCase != LetterCase.UPPER_CASE || Character.isUpperCase( ch ); } }

Our microservice accept http requests: For swagger used Swagger OpenAPI 3. The bank account REST controller, which accept requests, validate it using Hibernate Validator, then call command or query service. The main reason for CQRS gaining popularity is the ability to handle reads and writes separately due to severe differences in optimization techniques for those much more distinct operations.

I'm trying to build a specific sub module of an open source library.