All Questions
Tagged with postgresql java
8,727
questions
0
votes
0
answers
27
views
How to catch the PSQLException exception? [closed]
How to catch the **PSQLException ** exception? I am using Spring boot JDBCTemplate and it can throw a PSQLException exception. Using try-catch, I get this message from IDEA: "Exception 'org....
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 ...
0
votes
1
answer
41
views
Java type in JDBS PreparedStatements for Postgresql ltree[] (Array of ltree elements)
I have a JDBC Prepared Statement that take a parameter of ltree[], the hierarchical tree-like data type in Postgres.
My goal is to query multiple entries from my_table, where the path is ltree type ...
-1
votes
1
answer
59
views
PostgreSQL database not connecting to spring-boot application
I am currently setting up postgreSQL db for my spring-boot project. However, when I try to launch the tomcat server I get exception saying that the repository beans could not be created due to this:
...
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
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....
-4
votes
0
answers
26
views
Java Integration tests failing when I run them all at once, but separately they all pass [duplicate]
For some reason, integration tests in my project have started to fail when I run them all at once.
error that I get is(I had to remove some of the stack trace because it was too long):
java.sql....
-1
votes
0
answers
35
views
Spring boot: Why am I getting this 404 Error?
Just to give a little background on the project; I'm making a Spring Boot project using Maven. I have a two microservices, one called "products" and one called "config-server" to ...
0
votes
1
answer
36
views
ERROR: prepared statement "S_25" already exists Spring Data + postgres
So the problem is that is not always happening i have to make like 5/10 api request and then i get this error , then maybe for another 5 request i don't get the error then again the same error... ...
-1
votes
2
answers
44
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:
...
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 "...
1
vote
1
answer
68
views
Spring Boot: Error 404 when accessing localhost endpoint
Just to give a little background on the project; I'm making a Spring Boot project using Maven. I have a two microservices, one called "products" and one called "config-server" to ...
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 ...
-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 {...
1
vote
1
answer
48
views
Why does enum cause type mismatch when saving in postgresql from JPA?
I have a user object defined as such
@Entity
@Table(name = "user_account")
public class User {
public enum Role {
CLIENT,
ADMIN
}
@Id
@GeneratedValue(...