Hibernate sequence generation not working for element of a composite key

Question

I have a Hibernate entity with a composite key where the key is made up of a Long ID and a Timestamp. The ID should use a sequence generator.

MyEntity:

@Entity
@Table(name="MY_ENTITY")
public class MyEntity {
   private MyEntityPk myEntityPk;

   @EmbededId
   public MyEntityPk getMyEntityPk() {
      return myEntityPk;
   }

   // setter omitted

   // other properties/getters/setters omitted
}

MyEntityPk:

public class MyEntityPk implements Serializable {

   // version UID/hashCode()/equals() omitted

   private Long myEntityId;
   private Timestamp revisionTime;

   @Column(name = "MY_ENTITY_ID", unique = true, nullable = false, precision = 13, scale = 0)
   @GeneratedValue(strategy=GenerationType.AUTO, generator="HIBERNATE_SEQUENCE_GEN") 
   @SequenceGenerator(name="HIBERNATE_SEQUENCE_GEN", sequenceName="HIBERNATE_SEQUENCE")
   public Long getMyEntityId() {
      return myEntityId;
   }

   public void setMyEntityId(Long myEntityId) {
      this.myEntityId = myEntityId;
   }

   @Column(name = "REVISION_TS", nullable = false)
   public Timestamp getRevisionTime() {
      return revisionTime;
   }

   public void setRevisionTime(Timestamp revisionTime) {
      this.revisionTime = revisionTime;
   }

}

The PK looks like it's wired up correctly. When I do a find all, I have a list of MyEntity objects where the MyEntityPk objects for each have an id and revisionTime from the database.

On insert, though, the following is giving me an error indicating that the MY_ENTITY_ID is null and the db won't allow a null value for that column. With our other entities, we can insert and leave our auto-generated IDs null and Hibernate knows to grab the next sequence from the db and use it in the entity. In this case, for some reason that's not happening:

MyEntity e = new MyEntity();

MyEntityPk pk = new MyEntityPk();
pk.setRevisionTime(new Timestamp(System.currentTimeMillis()));
//pk.setMyEntityId(5l); // see note below
e.setMyEntityPk(pk);

// setting a bunch of other entity parameters omitted

Session session = getSession();
session.saveOrUpdate( entity );

Ends up giving me:

// a bunch of stack trace omitted
Caused by: java.sql.BatchUpdateException: ORA-01400: cannot insert NULL into ("MY_SCHEMA"."MY_ENTITY"."MY_ENTITY_ID")
// more stack trace omitted

Note that if I set the PK object's ID manually, the insert will work.

score 1 · Accepted Answer · edited May 23 '17 at 11:48

1

I only ever used composite keys which are references to other tables, but take a look at that one JPA Composite Key + Sequence

At first seems like bad news, but if you read the comments of the accepted answer you may get lucky

edited May 23 '17 at 11:48

Community

1
1

answered Jan 08 '13 at 16:44

beder

1,086
5
10

You're right, this is bad news. I left out that we were on an older version of Hibernate (3.3) and it seems like this has been fixed in 3.5. I was able to get around this by manually getting the ID from the sequence before saving. – Chris Williams Jan 09 '13 at 03:37

Hibernate sequence generation not working for element of a composite key

1 Answers1