Relative Content

Tag Archive for postgresqlspring-boot

Using JdbcCursorItemReader to call a function on Postgres

I´m working on this project that process a user request and generate a report on csv format.
The data is read from a Postgres 15.2 DB. I´m using Springbatch where I use a JdbcCursorItemReader<Map<String, Object>> to retrieve data from a Postgres Function.

Using JdbcCursorItemReader to call a function on Postgres

I´m working on this project that process a user request and generate a report on csv format.
The data is read from a Postgres 15.2 DB. I´m using Springbatch where I use a JdbcCursorItemReader<Map<String, Object>> to retrieve data from a Postgres Function.

spring boot generation type sequence not working properly with postgresql

@Data @Entity public class Question { @Id @GeneratedValue(strategy = GenerationType.SEQUENCE) private Integer id; private String questionTitle; private String option1; private String option2; } this is my dao. every time when i post new data the id value is wrongly generated in postgresql. I tried to delete the table. even also the table start with id […]