In this recipe, we will consider a simple technique that we can use to enforce having detailed records when inserting a new master record in an entity association relationship. The use case demonstrates how to enforce creating at least one employee at the time when a new department is created.
We will use the HR
database schema and the HRComponents
workspace that we have created in previous recipes in this chapter.
1. Open the
DepartmentImpl
custom entity implementation class and override thedoDML()
method using the Override Methods dialog.2. Add the following code to the
doDML()
method before the call tosuper.doDML():
// check for insert if (DML_INSERT == operation) { // get the department employees accessor RowIterator departmentEmployees = this.getDepartmentEmployees(); // check for any employees if (!departmentEmployees.hasNext()) { // avoid inserting the department if there are no employees...