how to resolve error executing ddl commands in spring boot

Hi I am new to spring Boot and i created new project(Demo) using spring initilizr Project structure is Project : Maven Project Language : Java Spring Boot : 2.4.2 application.propertites file is like …

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….

NoSuchMethod in JOOQ 3.14 InsertQuery with Postgresql

I’m trying to use Jooq’s InsertQuery to insert a record into PostgresQL database, but I’m running into following error: java.lang.NoSuchMethodError: ‘org.jooq.UniqueKey org.jooq.impl.Internal….

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 …

procedure myProcedure (text, text) does not exist Hint: No procedure matches the given name and argument types

whenever trying calling any stored procedure in PostgreSQL 11.4 from my java application but getting this issue procedure pkg$my_procedure(text, text) does not exist. Note that I’m able to call the SP …

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 …

JPA does not return default value after saving

I faced a problem. A have an entity: @Entity @Table(name = “user”) public class User { @Id @GeneratedValue private Integer id; @Column(name = “date_create”, insertable = …