On 8/2/06, Alex Funk <[EMAIL PROTECTED]> wrote:
I used DdlUtils to compare an existing Derby database model with a specification xml, and 'Database#equal' returned false, although they are equal. The reason is - I think - that tables have a certain order in the 'Database' class, stored in an 'ArrayList'. The existing 'Database' from 'platform.readModelFromDatabase(...)' returns the tables in a different order than the 'Database' from 'DatabaseIO().read'.
They are returned in the order that the database returns them, DdlUtils does nothing to that order. Likewise, reading form an XML uses the order in the XML file.
Is there a good reason for this, or is that considered a bug? Does that only happen with certain DBMS? Is there a workaround?
I could add an attribute to the Ant subtask for reading a model from a live database that tells DdlUtils to sort the tables (alphabetically). Please create an issue in JIRA if this would help you. Tom
