0 Replies Latest reply on Oct 7, 2012 12:35 AM by su baochen

    how to import data into postgresql?

    su baochen Newbie



      I'm trying to import some data into postgresql database, the entity like :


      @Table(name = "user", schema = "public")
      public class User implements java.io.Serializable {
          private Integer id;
          private String username;
          private String password;
          @SequenceGenerator(name = "user_seq", sequenceName = "user_id_seq", allocationSize = 1)
          @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "user_seq")
          public Integer getId() {
              return this.id;
          public void setId(Integer id) {
              this.id = id;



      And import.sql like :


      insert into user(username,password) values('admin','admin');


      The problem is, hibernate will automatically generate the id field of user table as type integer, not type serial, so import.sql will generate error:


      Caused by: org.postgresql.util.PSQLException: ERROR: null value in column "id" violates not-null constraint


      So, how to let hibernate to generate the correct id field (serial type, not integer type)?


      Thanks in advance!