at the moment I’m developing a little program, which uses Maven and Hibernate. I wrote 130 Junit tests. Half of them are testing my DAOs. All of them are successful and don’t make any problems. Now I started to write some REST methods and wanted to test them with Postman. The problem is that I get…
Tag: hibernate
Does Hibernate HQL Support Regular expression pattern matching?
I was testing different ways of data retrieval from my database (MySQL) using Hibernate. And I get to know that it is possible to use LIKE in HQL just like we do it in SQL. But when I tried REGEXP I got the following error I have also tried the different forms like RLIKE and REGEXP_LIKE. But the error is
Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment] Java Error
I have been facing problem connecting Hibernate to Azure Data Studiowhere I want to read the data from the database. Here are the files: Testing Class Hibernate.cfg.xml Error Stacktrace Please help me find out the problem regarding the code and how do I modify it? The error is mainly on the configuration of t…
hibernate validator throws exception ValidationException: HV000028 for @Past annotation
I am validating an entity with a hibernate validator in a spring boot project. I got an exception for the Date validator @Past . I faced javax.validation.ValidationException: HV000028: Unexpected exception during isValid call This is the dependency I have in my gradle.build file implementation ‘org.spri…
Spring Boot – Jackson EntityNotFoundException returns 200 instead of 500 response
Exception handler is returning 200 response even though I have specified it to return 500 in the handler (HttpStatus.INTERNAL_SERVER_ERROR) when encountering this exception. I am using Spring Boot v1.5.4.RELEASE. I am calling a Spring Boot service returning a JSON object. I am using a custom exception handler…
Hibernate mapping between different database and domain model
I have created a domain and database model. The domain model is for a rest api. The both have similar components like product, category, customer, retailer, etc… But if you take a closer look at both models. You can see some differences. For example, you can see that in the database model the retailer h…
How to put YML value inside the @Pattern(regexp = “HELLO|WORLD”)
I want to move the “HELLO|WORLD” value to the YML file. Then call the value from YML file inside the regexp. For example, Following is the YAML file YML FILE Java class to get the YAML value Java class that use regex validation Instead of a string, I want to do something similar to this. I have al…
Groovy createCriteria issue with joined table
I have a domain class Coach which has a has many relationship to another domain class CoachProperty. Hibernate/Grails is creating a third joined table in the database. In the example below I am trying to fetch the coaches which both have foo AND bar for their text value. I have tried different solutions with …
Jpa Enum error with Smallint type in postgres
I want to put enum in my entity. But I have an error with validation which JPA wonts smallint set as enum. How I can solve this issue. “Schema-validation: wrong column type encountered in column [status] in table [order]; found [int2 (Types#SMALLINT)], but expecting [int4 (Types#INTEGER)]”[enter i…
Batch fetching into @ElementCollection
I have following entity with its persistent collection After loading 10k rows A entities, I want to load its collection as well And select statement generated quite a lot (~10k). Very poor performance here! Any idea to work with batch select here? Answer I have solved this! IDEA Hibernate will take care of th…