I think it was mentioned in one of the recent threads (??), but you'll
be better off defining a "meaningless" integer PK for category. This
way (1) cayenne will generate it for you, (2) you can rename category
without breaking any DB references. This of course assumes that you can
control the schema...
If you have to stay with current schema, Cayenne will not automatically
update related tables [after all object identity is a cornerstone of an
ORM, and here it is being destroyed], but Cayenne can help you finding
those related objects so that you could do the update yourself.
On Nov 28, 2004, at 6:31 AM, Alex Gunawan Wibowo wrote:
> I have a question...
> say my database schema is like this:
> category: _categoryName_ , status
> where categoryName is in String, and it's a primary
> Other tables are referring to this "category" table,
> e.g.: product: _productId_, categoryName.
> If i change the categoryName of a record in "category"
> table, do I need to look for all records in "product"
> table that has the relationship to the "category"
> table with the old categoryName, and set the new
> or is cayenne smart enough to handle that in
> Thanks a lot for the help!
> Best regards,
> Alex Wibowo.
This archive was generated by hypermail 2.0.0 : Sun Nov 28 2004 - 20:35:36 EST