SCENARIO: I have a MySQL Database where I have one Table with a Mapping of a user and a product. My Application offers an api so I have to be aware that the mapping will not be done multiple times. Therefor I want to check if the two ids( of the user and the product) are already mapped. PROBLEM: I
Tag: spring-data-jpa
Response from query couldn’t map to pojo class spring boot
Every response from query should be mapped to a poja class. I have written a native query @Query(value=”SELECT new QuestionJsonTotalAnswer(q.question) FROM mydb.question q”, nativeQuery=true) List&…
How to log failed sql in hibernate?
I’m building a SpringBoot application with spring-data-jpa. I know how to log all sqls from this question. How to print a query string with parameter values when using Hibernate But what if I only want to log failed sqls? Answer There are two options: Configure sql logging with parameter values. Disable…
Java sort list alphabeticaly with value “Other” at the end
I got a small Spring Boot application that manages some projects and clients. A client has a country ( which is an entity) and I want to let the user when he wants to create/update his clients to …
Can I use custom criteria (from a database extension) with spring JPA specifications?
I really found of Spring Data’s JpaSpecificationExecutor, it allows me to dynamically build queries, depending on the filters applied by user. However, I’ve installed a ZomboDB plugin, and now I need …
Hibernate not allowing to increment by 5 in sequence
I have following db sequence Java However with Hibernate I am getting following error which says hibernate is expecting increment by 50. Why is so? Edit1 Added java code. Answer The error message is quite clear. You have enabled (or not disabled) schema validation, so when the application starts Hibernate is …