I have a CMP EJB that has a foreign key field in it (DepartmentID). This
field can be null (removed other fields for simplicity):
CREATE TABLE ACTIVITY (
ACTIVITYID NUMBER NOT NULL,
DEPARTMENTID NUMBER
)
The ActivityID and DepartmentID are class variables of the EJB.
I'm trying to create a record with no DepartmentID. But the value of the
DepartmentID is always 0 (zero) because ints default to 0. The end result is
a constraint error because there is no department with ID=0.
My question: How can I tell orion to create the new record with a null value
for DepartmentID instead of 0.
-----------------------------------------
Eduardo Estefano
Integrated Information Systems