SDOs- session facadePLZZZZZZZZZZZZZZZ HELPPPPPPPPPPP

hi,

I am using session bean facade in an application. This facade is creating SDOs for handling requests of add, update, delete or view.

I have used them to create different listing servlets. But when I am adding new products or items or store etc I am facing errors.

Adding etc is OK for entity beans with NO CMR relationship keys.

But adding in tables with CMR keys is problem.

I am getting the following errors when trying to add an Item.

CreateException : System error while creating "Item".

cause : WQRY1020E: Runtime evaluation error - DataSource error [Column 'CATEGORYID' cannot accept a NULL value.] encountered.

CreateException 2: System error while creating "Item".

I have spent a lot of time but it is still there.

Plz help

[808 byte] By [javainfevera] at [2007-10-3 1:26:21]