I have a game collection application where I want to create seperate lists of games. I am using Spring JPA and Hibernate in the backend and this is what the Entity classes look like right now. I am not sure if this is even the right approach… In the end, I want to create a Spring Boot application where …
Tag: hibernate
org.postgresql.util.PSQLException: ERROR: relation “users” does not exist – SpringBoot, Hibernate, Postgresql
I am using Spring Boot with Hibernate, JPA and Postgresql database. I am trying to create new user and save it. I have the following code: UserEntity.java UserController.java UserServiceImpl.java UserRepository.java Application.yaml My error in Intelij looks like this: I am testing it with Postman and sending…
Understanding JPA sequence generator
I’m using spring data JPA’s sequence generator to assign primary keys to entities. Model contains: The corresponding sequence definition(for SQL Server DB): Since I wanted to start the ids from 100 instead of 1, so I updated the sql script to And then I encountered the problem as mentioned here. I…
Batch insert entities to DB (Quarkus, Hibernate)
First off: I’m not used to Quarkus or Hibernate (I’m pretty much all .net) Problem: My service receives a list of ~10k (Would guess thats the most common number). This comes via a resource endpoint, and it takes +10s for it to complete, Far to long. And the service is unresponsive. The statusDao.C…
Strange exception when mapping two columns in a table to the same column in another table
There are two entities: and when i create repository with custom query the exception is thrown but if i remove the second referencing column from the query the program starts without exceptions. Moreover, if i use standart query method bookRepository.findAll(): all works fine Books: Book{id=3, name=’Tes…
Query on parent’s collection – Hibernate Specification
I have three tables created with Hibernate. Product is the parent while barcodes is a collection end price is a child (one to many) of products. I’m trying to query starting from the child (Price). I was able to query on a string but now i would like to query on the collection s element. how would you w…
Spring boot delete object from database based on a OneToOne relationship
i’ve got an “appointment” entity object(table) AND dates_doctor_available entity build like this AND now i wish from a controller to remove the Database entry based on the “date_time_available_fk” Using “Appointment” object. For example something like where inside ser…
org.hibernate.hql.internal.ast.QuerySyntaxException: Apartment is not mapped [from Apartment]
I have springboot rest appplication with Hibernate and MySQL. I have this error: nested exception is org.springframework.dao.InvalidDataAccessApiUsageException: org.hibernate.hql.internal.ast.QuerySyntaxException: Apartment is not mapped [from Apartment] But I dont know where I have a mistake. I have two tabl…
Spring Hibernate SQL Server – problem in updating columns
I get the below error while not updating the mentioned column at all. I only update two another columns that one of them is used to compute the column “Available”. The column “Available” cannot be modified because it is either a computed column or is the result of a UNION operator. I a…
What am I doing wrong in this one to one bi-directional mapping?
I have two classes: Person and PersonDetail Person: PersonDetail I have set up a bi-directional one-to-one mapping between these classes. I am trying to save a person and that person’s details and then I am trying to fetch the person using the person’s details. The code for that is: My test is fai…