Hi,
I have got a problem with referential integrity. I am using OJB PB API with
HSQLDB and have set up a table 'person' with personId as primary key and a
second table 'activity' with this attribute as foreign key (null allowed).
the datatyp is integer and the association is 0..1 to many.
It should be possible to store an activity and assign a person later to it.
however, when I try to store an activity I get the following exception:
org.apache.ojb.broker.KeyConstraintViolatedException ....
java.sql.SqlException: integrity constraint violation for table 'person'.
What am I doing wrong?
thx,
Dirk