Message Title

Nikolay Firov updated an issue

Attached example project.

Change By:	Nikolay Firov
Attachment:	ex_HHH-10647.zip

Referencing serial id produces always not null column with default value.
{code:java}
@Entity
@Table(name = "books")
public class Book {
    private Integer id;
    private Author author;

    @Id
    @Column(name = "id", columnDefinition = "serial")
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    @JoinColumn(name = "author", nullable = true)
    @ManyToOne(optional = true, fetch = FetchType.LAZY)
    public Author getAuthor() {
        return author;
    }

    public void setAuthor(Author author) {
        this.author = author;
    }
}

@Entity
@Table(name = "authors")
public class Author {
    private Integer id;

    @Id
    @ Column(name = "id", columnDefinition = "serial")
    @ GeneratedValue(strategy = GenerationType. AUTO IDENTITY )
    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }
}
{code}

Result DDL for column author in books table:
{code:sql}
ALTER TABLE books ADD COLUMN author integer;
ALTER TABLE books ALTER COLUMN author SET NOT NULL;
ALTER TABLE books ALTER COLUMN author SET DEFAULT nextval('authors_seq'::regclass);
{code}

Add Comment

This message was sent by Atlassian JIRA