'Getting Exception while inserting data in Redshift DB

while fetching data from database It is working fine when trying to insert data in Redshift database getting exception MY POJO class : Quote.java

@Entity
public class Quote {
@Id
@GeneratedValue(strategy= GenerationType.AUTO)
private Integer id;
@Column(name="user_name")
private String username;
private String quote;
}

Getting Exception :

com.amazon.support.exceptions.ErrorException: [Amazon](500310) Invalid operation: relation "hibernate_sequence" does not exist;

We cannto create sequence in Redshift but we can create sequence in postgresql and when I am connect with redshift + spring-data-jpa then it is using postgresql db

hbm2ddl.auto = update

I have tried with identity also



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source