Reading Time: 2 minutes Writing dynamic queries using JPA Specification could be a hard to understand and implement but lets make it simple and easy to understand! To query array of string in postgreSQL , we might use a query like this : select * from employee where ARRAY_TO_STRING(keywords, ‘,’) LIKE ‘%lunch%’; To use specification for querying array string datatype ,we will have to Define a custom dialect to Continue Reading

Reading Time: < 1 minute There might be a situation when you want to set the default value of column in spring boot. You might be thinking how to set it even when you have set the default value in the database but you still get a null value stored in the database . It is because JPA includes the columns with null value in the insert query which you Continue Reading