Missing non-NULL value

[sri ramvaithiyanathan]

Hi,

I have two table,
TMP_EMP : empid int pk, empname varchar
TMP_EMP_DETAILS : empid int , deptname varchar, residence varchar, fk reference TMP_EMP(empid)

TMP_EMP Entity

@Entity
	@Table(name="TMP_EMP")
	public class TMP_EMP implements Serializable {
		private static final long serialVersionUID = 1L;
		@Id
		@Column(name="empid")
		@SequenceGenerator(name="empid_seq", sequenceName="seq_emp")
		@GeneratedValue(generator="empid_seq", strategy=GenerationType.SEQUENCE)
		private int empid;
		@Column(name="empname")
		private String empname;
		@OneToOne(mappedBy="tmpemp",cascade=CascadeType.PERSIST)
		private TMP_EMP_DETAILS tmp_emp_details;

TMP_EMP_DETAILS Entity

@Entity
@Table(name="TMP_EMP_DETAILS")
public class TMP_EMP_DETAILS implements Serializable {
	private static final long serialVersionUID = 1L;
	public TMP_EMP_DETAILS() {
		super();
	}
	@Id
	@Column(name="empid",insertable=false,updatable=false,nullable=false)
	private int empid;
	@Column(name="deptname")
	private String deptname;
	@Column(name="residence")
	private String residence;
	@Id
	@OneToOne
	@JoinColumn(name="empid")
	private TMP_EMP tmpemp;

DBCaller

EntityManagerFactory emf = Persistence.createEntityManagerFactory("XXCONN");
				EntityManager em = emf.createEntityManager();
				em.getTransaction().begin();
						TMP_EMP tmp_emp = new TMP_EMP();
						tmp_emp.setEmpname("Sriram");
						
						TMP_EMP_DETAILS emp_details = new TMP_EMP_DETAILS();
						emp_details.setDeptname("fsg");
//						emp_details.setEmpid(tmp_emp.getEmpid());
						emp_details.setResidence("chennai");
						tmp_emp.setTmp_emp_details(emp_details);
					em.persist(tmp_emp);
					em.getTransaction().commit();

I am getting below exception, don know where I am going wrong

javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.0.v20110604-r9504): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.sap.dbtech.jdbc.exceptions.DatabaseException: [-5005]: Missing non-NULL value
Error Code: -5005
Call: INSERT INTO TMP_EMP_DETAILS (deptname, residence, empid) VALUES (?, ?, ?)
	bind => [3 parameters bound]
Query: InsertObjectQuery(XXENTITY.TMP_EMP_DETAILS@969c29)
	at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commitInternal(EntityTransactionImpl.java:102)
	at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:63)
	at XXDB.XXDBCONN.testConn(XXDBCONN.java:93)
	at XXDB.JustJava.main(JustJava.java:15)
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.0.v20110604-r9504): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.sap.dbtech.jdbc.exceptions.DatabaseException: [-5005]: Missing non-NULL value
Error Code: -5005
Call: INSERT INTO TMP_EMP_DETAILS (deptname, residence, empid) VALUES (?, ?, ?)
	bind => [3 parameters bound]

Please help me to solve this issue.

Regards,
Sriram.V