Hi everybody, I have a couple of questions regarding Castle Active Record.
1) I have taken over a project that has been working with SQL Server as the DB (and uses CAR). It now has to be ported to Oracle and that's where the problems start. Apparently Oracle converts empty strings to NULL values (a known issue obviously) which SQL Server hasn't been doing. Since the existing program uses empty strings heavily (like most programs) this would be a major effort to change all the occurences. Especially the queries fail now when they include empty strings. Also the program requires strings to be empty and NOT NULL (for this reason all the strings in the program are initialized to an empty string in the constructors of the classes - but this is useless when CAR delivers NULL-strings...). Is there a work around to be able to use empty strings the way we used them with SQL Server without changing all empty strings to some defined value? 2) We are creating the schema of the DB with the CreateSchema() function. Since we're deploying new versions of the program constantly we are interested in importing the old data (which is also CAR generated) into the new DB. I was thinking of something like "read all objects from the old DB and put them in the new DB" (with ActiveRecordMediator.Save() for example). The problem is that the structure of the tables might be different in the old and new version of the DB. Is there a way of importing data from an old CAR scheme into a new CAR scheme? That would require some kind of versioning I suppose...? (for example in detail: we have a USER table that consists of five columns which were generated from CAR a couple of weeks ago. We now have one new column in there and we would like to import the old data into the new structure with one more column. The class "User" that we have, has changed too of course so I can't read in the old users with the new class...) Thanks in advance! G. -- You received this message because you are subscribed to the Google Groups "Castle Project Users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/castle-project-users?hl=en.
