Hello, Is there anyway to examine the SQL insert statements that are generated for CMP beans? I'm trying to understand a curious problem -- A CMP bean (X) has a field that is another CMP bean (Y). Y's primary key is a serializable. It is legal for X to not have a Y assigned to it. I create a bunch of X beans that do not have any values assigned to Y. The creates work fine. I expect that the database columns will have nulls as the value for the Y column when the entity ref is null and Y's primary key otherwise. Now, I examine the database -- Hypersonic SQL. The values for the Y column are not null! Instead, they are "aced000570" -- I guess, some header information from Java serialization. My suspicion is that Orion is not checking whether the entity ref is null when generating the SQL. But, that's not possible since it has to extract the primary key from the entity ref. How do I solve this? Thanks, Vidur -- Vidur Dhanda Active Solutions tel: 617/566-1252 [EMAIL PROTECTED] www.active-solutions-inc.com
