Hibernate annotation for postgresql SERIAL type

Question

I have a postgresql table in which I have declared a column 'inv_seq' which is declared as 'SERIAL'.

I have a Hibernate bean class to map the table. All the other columns are read properly except this column. here is the declaration in the Hibernate bean class:

....


  ....


        @GeneratedValue(strategy=javax.persistence.GenerationType.AUTO)
        @Column(name = "inv_seq")
        public Integer getInvoiceSeq() {
            return invoiceSeq;
        }

         public void setInvoiceSeq(Integer invoiceSeq) {
        this.invoiceSeq = invoiceSeq;
    }

    ....

    .....

Is the declaration correct? I am able to see the serialized numbers generated by the column in the database,but I am not able to access them in the java class.

Please Help.

Thanks, Aditya

Answer 1

Depending on your situation, this may not work. There is a bug opened against Hibernate that documents this behavior.

http://opensource.atlassian.com/projects/hibernate/browse/HHH-4159

If you are open to using a mapping file instead of annotations, I have been able to recreate the issue (NULL's in SERIAL columns that are not part of the primary key). Using the "generated" attribute of the property element causes Hibernate to re-read the row after an insert to pick up the generated column value:

<class name="Ticket" table="ticket_t">
    <id name="id" column="ticket_id">
        <generator class="identity"/>
    </id>
    <property name="customerName" column="customer_name"/>
    <property name="sequence" column="sequence" generated="always"/>
</class>