Im trying to insert a record in a postgres db but insertion fails.
When trying to select data, selection works fine, so i suppose its not a spring-hibernate configuration error
environment: Spring 3.1, Hibernate 3.6, Postgres 9.1
here is my code :
Entity class:
@Entity
public class Person implements Serializable {
@Id
@Column(insertable=false, updatable=false)
@Type(type="java.lang.Long")
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator="PERSON_SEQ")
@SequenceGenerator(name="PERSON_SEQ", sequenceName="PERSON_SEQ", allocationSize=1)
private Long id;
@Column
private String firstName;
}
My Dao:
@Repository
public class PersonDao extends BaseDao
public void insertPerson(){
super.getHibernateTemplate().execute(new HibernateCallback() {
@Override
public Object doInHibernate(Session session) throws HibernateException, SQLException {
Person p = new Person();
p.setFirstName("george");
session.persist(p);
return null;
}
});
}
}
At the first time the application is deployed, a new sequence is created in postgres
CREATE SEQUENCE person_seq
INCREMENT 1
MINVALUE 1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER TABLE person_seq
OWNER TO postgres;
The hibernate sql output during sql insert is:
Hibernate:
select
nextval ('PERSON_SEQ')
Hibernate:
insert
into
Person
(firstName, lastName, money, id)
values
(?, ?, ?, ?)
but it never inserts the record, even if the sequence increments by 1
