I want to embed date information in the primary key, for a table that will be partitioned (monthly) in a PostgreSQL database. This should in theory speed up the process on finding out in which partition to look for the…
I have a table that looks like this: CREATE TABLE `test_table` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `ref_id` bigint(20) NOT NULL, `count` int(11) DEFAULT NULL, `status` tinyint(4) NOT NULL, `create_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_timestamp` timestamp NOT NULL DEFAULT…
Hello guys， I am running into this error on my first trial on springboot, and the exception message makes no sense to me, the error message is as follows: 2022-10-03 22:27:15.801 ERROR 22836 --- [ main] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 -…
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'…