JPA With postgresql

Question

When i create table Entity in Jpa With hibernate using PostgreSQL database like,

tire - 

 @Entity
 @Immutable
  public class User_entity_t implements Serializable, Cloneable {

    private static final long serialVersionUID = -7049957706738879274L;

    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    @Column(name = "id", updatable = false, nullable = false)
    private Long _judId;

@Column(nullable = false)
private String name;

i get exception as

{syntax error at or near "auto_increment"} Primary Key Id

This may be a duplicate of https://stackoverflow.com/questions/40497768/jpa-and-postgresql-with-generationtype-identity — Roman-Stop RU aggression in UA, Sep 10 '18 at 10:46
Sounds as if your obfuscation layer doesn't know how Postgres handles "auto increment" columns (either as `serial` or as `identity`) — , Sep 10 '18 at 10:51
1) You should avoid to use AUTO and go for IDENTITY. 2) auto_increment sounds like MySQL do you have the correct dialect set? — Simon Martinelli, Sep 10 '18 at 10:55
@SimonMartinelli Thanks For reply. but when iuse Id GeneratedValue(strategy = GenerationType.IDENTITY) Column(columnDefinition = "serial") private Long id; Same error — Rohit Manhas, Sep 10 '18 at 10:58
and you are sure you have the correct syntax set for Postgres? — Simon Martinelli, Sep 10 '18 at 11:01
@SimonMartinelli yes now problem is solve.thanks your advice and help. — Rohit Manhas, Sep 11 '18 at 05:12

score 0 · Answer 1 · answered Sep 11 '18 at 07:35

0

auto_increment sounds like MySQL

You have to set the correct Hibernate dialect.

answered Sep 11 '18 at 07:35

Simon Martinelli

34,053
5
48
82

JPA With postgresql

1 Answers1