I have two table and I try to join use column idsubscriber but show some error. Class Subscriber: @Entity @Table(name = "subscriber") @XmlRootElement @NamedQueries({ @NamedQuery(name = "Subscriber.findAll", query = "SELECT s FROM Subscriber s") , @NamedQuery(name = "Subscriber.findById", query =…
I'm super rusty with databases and haven't got the chance to work too much with them in the past 6-8 years, so there are some things that are uncertain for me. Let's assume I have a simple bi-directional one-to-many situation:…
I read this stackoverflow post which says that we don't need to use @EnableJpaRepository or @EntityScan Spring data repository works without annotations I'm not sure what's wrong. But my Spring Boot application is only able to start with @EnableJpaRepository and…
I want to write a complex hql query with relationships from 3 tables. It is necessary to make a selection of the selected columns so that they are located by ID @Query("SELECT p.regId, p.method, p.tax, p.fee, p.netAmount, r.countSec, p.status "…
I'm currently learning Spring-Boot and Spring-Data-JPA. I'm using a postgresql database for storing the data. My goal is to store ingredients with a unique and custom ID (you just type it in when creating it), but when another ingredient with…
To persist I use Hibernate 6 and use on the entity: @JdbcTypeCode(SqlTypes.JSON) private String value; When you save to the database, save wrapped in quotes and inside the json escape the quotes: "{"name":"pepito", "lastname":"perez"}" when I use the query to…
Now I learn about nested jsons and geojson and how to save them in PostgreSQL as JsonB directly in database and before starting. Inspiration source: https://thorben-janssen.com/persist-postgresqls-jsonb-data-type-hibernate/ Error I get when running the app: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory'…
I am trying to implement Hibernate second level caching in a Spring boot project using Redisson. I have followed this blog as a reference https://pavankjadda.medium.com/implement-hibernate-2nd-level-cache-with-redis-spring-boot-and-spring-data-jpa-7cdbf5632883 Also i am trying to initialize the RedissionClient programmatically and not through declaratively /through a…
I am new to docker and it is easy to get confused about some things. Here is my question. I am working on my Spring Boot app and was creating entities for DB. I found out that when I remove…
i am working on my first school project with springboot and thymeleaf . I am supposed to create a crud for two OneToMANY related entities : User and Comments. I succeded in making the comments' CRUD but i'm having a…