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

    how to import data into postgresql?

    su baochen Newbie

      hi,

       

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

       

      @Entity
      @Table(name = "user", schema = "public")
      public class User implements java.io.Serializable {
      
          private Integer id;
          private String username;
          private String password;
      
      @Id
          @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!