How to map column with type BIT(24) in PostgreSQL with Hibernate

I have a table with a column which type is a bit (24). I tried to use String and when I try to get this object it maps well, but when I try to save it, Hibernate throws Exception: org.postgresql.util….

Postgresql – How to read xmlattributes on xml?

I Have xml :

How to Map a JPA create native query to projections

I am trying to get count from a postgreSQL database using Spring Data JPA createNativeQuery. However, the query is returning null instead of the actual values. Here is the JPA createNativeQuery …

Is it possible to use MongoDb and PostgreSql for same model in Spring boot?

I have built a User management service in which I’m using MongoDb (spring data). I have two models User and Role. package com.userservice.usermanagement.models; import java.util.HashSet; import java….

Is there a way to query ltrees in JOOQ?

Is there any sort of extension that would allow me to use Postgres ltrees in JOOQ without having to use raw SQL? Any way to make one myself maybe?

What’s the effective way to insert more a million rows into postgresql server from another postgres server using Java?

I have two postgresql servers and I need to copy table rows with from first server format and convert to another server format (different column names). I use java application with spring boot and jpa …

Jooq Java CTE wrong render

I have CTE that is been creating from DSL.values: final RowN[] rowNS = tasksId .stream() .map(x -> DSL.row(x.toString())) .toArray(RowN[]::new); …

Spring boot cannot connect to postgre database deployed on another kubernetes pod

I deployed my microservice hello-k8s in a pod and another pod as postgre-server, I have successfully connected to localhost using port-forward and try to create a table in the deployed database. But …

Can I specify *source* IP address for a JDBC connection?

I have a Java application that connects to a database with a JDBC driver. It happens to be a Postgres instance, but I’m looking for a general solution if it exist. The server on which the application …

PostgreSQL throws “Connection has been abandoned” -> “An I/O error occurred while sending to the backend”

I know that there are a lot of topics about abandoned connections , however I can’t figure out what is the problem in my case, so I really hope for some help. I have a Java application with Spring, …