Hibernate throws "org.hibernate.id.IdentifierGenerationException: attempted to assign id from null one-to-one property"

Hibernate ORM
8

@vlad, Please correct me if I am doing something wrong. Apologize for the experimentation. I have made the following changes in Compensation mapping with Orders table.

Updated Compensation class(removed orderid field and made Orders as Id field). Below are the queries generated in console.

Hibernate: create table compensation (channel_dealer_code varchar(255), order_id varchar(255) not null, primary key (order_id))
Hibernate: create table orders (order_id varchar(255) not null, access_id varchar(255), primary key (order_id))
Hibernate: alter table compensation add constraint FKic3016mn3tbu38ye2hx4ad66t foreign key (order_id) references orders

Updated Compensation model:

package com.newModel;

import java.io.Serializable;

import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.MapsId;
import javax.persistence.NamedQuery;
import javax.persistence.OneToOne;
import javax.persistence.Table;



@Entity
@Table(name="COMPENSATION")
@NamedQuery(name="Compensation.findAll", query="SELECT o FROM Compensation o")
public class Compensation implements Serializable {
	private static final long serialVersionUID = 1L;

	/*@Id
	@Column(name="ORDER_ID")
	private String orderId;*/
	
	@Column(name="CHANNEL_DEALER_CODE")
	private String channelDealerCode;

	//bi-directional one-to-one association to Order
	
	@Id
	@OneToOne(cascade=CascadeType.ALL)
	@JoinColumn(name="ORDER_ID")
	private Order order;

	
}

Following is the error in console:

Hibernate: select order0_.order_id as order_id1_1_1_, order0_.access_id as access_i2_1_1_, compensati1_.order_id as order_id2_0_0_, compensati1_.channel_dealer_code as channel_1_0_0_ from orders order0_ left outer join compensation compensati1_ on order0_.order_id=compensati1_.order_id where order0_.order_id=?
Hibernate: select compensati0_.order_id as order_id2_0_0_, compensati0_.channel_dealer_code as channel_1_0_0_ from compensation compensati0_ where compensati0_.order_id=?
Hibernate: insert into orders (access_id, order_id) values (?, ?)
Hibernate: insert into compensation (channel_dealer_code, order_id) values (?, ?)
2018-11-23 16:13:53.210  WARN 17532 --- [nio-8080-exec-1] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: -10, SQLState: 23502
2018-11-23 16:13:53.211 ERROR 17532 --- [nio-8080-exec-1] o.h.engine.jdbc.spi.SqlExceptionHelper   : integrity constraint violation: NOT NULL check constraint; SYS_CT_10118 table: COMPENSATION column: ORDER_ID
2018-11-23 16:13:53.214 ERROR 17532 --- [nio-8080-exec-1] o.h.i.ExceptionMapperStandardImpl        : HHH000346: Error during managed flush [org.hibernate.exception.ConstraintViolationException: could not execute statement]
2018-11-23 16:13:53.244 ERROR 17532 --- [nio-8080-exec-1] o.a.c.c.C.[.[.[/].[dispatcherServlet]    : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement] with root cause

org.hsqldb.HsqlException: integrity constraint violation: NOT NULL check constraint; SYS_CT_10118 table: COMPENSATION column: ORDER_ID

In Debug found order is available inside compensation, pls find the attached screenshot for the same.
NewDebug