I hope I didn't sound too critical in my note below. Cayenne is a very easy to use tool and I'm sure it will only get easier to use as time goes on. My thinking that Cayenne might make this really easy for me is a testament to how easy it is already.
As I thought about it I realized that adding a column could be a difficult thing for Cayenne to manage if the column was mandatory because Cayenne does not yet allow a default value specification. I'm hoping that specifying a default value will be a new Cayenne feature soon since it seems like a useful feature and all databases (I think) support it at some level.
Are these features "on the horizon" or "down the road further"? (default column specification, and smarter schema evolution)
Thanks,
Jonathan
>>> "Jonathan Carlson" <Jonathan.Carlso..atun.com> 2004-07-23 1:37:07 PM >>>
I did a quick test to see how Cayenne handled adding a new field when there was data already in the table. I was secretly hoping that Cayenne would do the right thing and generate an add column statement rather than a create table statement, but it didn't.
To top it off, clicking on the "Generate" button resulted in a "Schema Generation Complete" message as if the db schema now matched what was in Cayenne, which it didn't because no column was added.
Is this a bug or just a missing feature? What's the best way for me to handle this situation? Add columns manually?
Thanks in advance!
Jonathan
*********************************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
Katun Corporation -- Celebrating 25 Years of Service
www.katun.com
*********************************************************************************
*********************************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
Katun Corporation -- Celebrating 25 Years of Service
www.katun.com
*********************************************************************************
This archive was generated by hypermail 2.0.0 : Fri Jul 23 2004 - 17:20:44 EDT