All Questions
Tagged with postgresql hibernate
3,870
questions
0
votes
0
answers
20
views
Materialized view with Postgresql/Hibernate/Panache
I have created a panache entity in Quarkus which map existing Materialized view. When I execute a refresh view from a test it's not work.
@Entity(name = "MY_VIEW")
@Immutable
@...
- 467
0
votes
0
answers
47
views
Not able to call postgres stored procedure with UUID[] as parameter
I have a stored procedure.
CREATE OR REPLACE PROCEDURE rvprficreationadm.copy_questions(IN target_componentid uuid, INOUT source_questionids uuid[], IN createdby uuid, IN is_copied_from_qb boolean, IN ...
- 972
0
votes
1
answer
41
views
Bitwise operation in HQL
I am using Hibernate 6, and I have created a custom dialect.
Below is my CustomPostgreSQLDialect.java:
public class CustomPostgreSQLDialect extends Dialect {
@Override
public void ...
- 1
-1
votes
0
answers
21
views
How to track nested property changes using Javers in a Spring Boot and PostgreSQL environment?
I'm working on a Spring Boot application with a PostgreSQL database and I'm using Javers for auditing.
Spring boot has JaVers starter:
implementation("org.javers:javers-spring-boot-starter-sql:7....
- 3,682
0
votes
0
answers
13
views
In Hibernate 5, The Jsonb sql column Serializer/Deserializer using SnakeCase than the camelCase (TypeDef JsonBinaryType)
While saving/retrieving Jsonb Object in a DB. JSON key are saved in SnakeCase than the CamelCase
Entity Class
@Entity
@TypeDef(name = "json", typeClass = JsonBinaryType.class)
public class ...
- 63
-1
votes
2
answers
43
views
springboot api in cloudrun not able to connect to postgresql instance within same GPC project
I have created a spring boot application that can connect to the postgresql14 instance (running in my GCP project) when I run the application on my local machine. Setup I used to make it work:
...
- 139
0
votes
0
answers
19
views
Hibernate can't find a table from postgresql database [duplicate]
Well, I have a postgresql database and table:
Structure in postgresql
So, i want to get all records from "SheduleRecords" table using Hibernate.
Table structure:
All types are "...
- 21
1
vote
1
answer
65
views
Springboot - Hibernate - Postgres Pessimistic Locking not work
I am working on a project using Java 17.0.11, Spring Boot 3.1.1, Hibernate, and Postgres. I have a piece of code that has high concurrency requirements, and I used a pessimistic lock hoping to ensure ...
- 11
-1
votes
0
answers
43
views
Hibernate Multiple OneToMany relations to same Entity yield 3 join tables
I tried to model a multiple choice question in hibernate.
I have the following Entities (simplified, id is in the parent classes):
@Entity
public class Choice extends AuditedEntity implements IChoice {...
- 679
0
votes
0
answers
13
views
Hibernate duplicates query for non-existing entities with OneToOne relationships
I want to prevent the duplicate SQL queries executed by hibernate, as my underlying relation is a complex view, (although maybe postgresql might cache the result, but still I would vastly prefer if ...
- 24.4k
0
votes
0
answers
13
views
Override parameterNames in EntityPersister to include composite key attribute
There is a column CreatedDate which is updated to be part of composite key in postgresql. @IdClass is used to define the composite key. After the change of adding it as part of composite key, ...
- 71
0
votes
0
answers
44
views
I cannot connect to the Postgres database located on the server
I created a database on the Railway app service. Created a postgres database on it but when I try to join it using the provided credentials I get an error
error when I try to run the project locally
...
- 79
1
vote
0
answers
43
views
Column <name> is of type json but expression is of type smallint[]
There is field of json type in postgres db named data_processing_steps.
It's defined in category entity as
@Type(JsonType.class)
@Column(columnDefinition = "json")
private Set<...
- 3,301
0
votes
1
answer
20
views
How to reduce time taken by createEntityManagerFactory
I'm setting up unit tests for my company application. It's set up to create a new docker container of the database for every test, so each test has a fresh database to work with. However, I get an IO ...
- 35
-1
votes
1
answer
46
views
Incorrect column name when querying PostgreSQL database from Spring Boot app using Hibernate
I have a simple Spring Boot application that connects to a PostgreSQL database.
This is a piece of Photographer class (entity)
@Entity
@Table(name = "photographer", schema = "public&...
- 121