Paul McNett wrote: > Uwe Grauer wrote: >> Carl Karsten wrote: >>>> Running DDL scripts while there are open connections to an already >>>> existing database doesn't work in firebird. >>> Are you saying a table can't be added while other clients are using other >>> tables? >>> >>> Carl K >> No, not when you are adding a new standalone table. >> But if the script would try to change a touched object, >> this wouldn't work in fb. >> And restoring to a existing database wouldn't work either. > > The unit tests create new unique tables and drop them for every single > test, but do this in a common database. So each client will touch a > different table, but the same database. Do you think this would be a > problem? Well, I'll soon find out anyway. >
you should use a special database for testing. If other clients would access these database-tables this wouldn't work as expected. firebird is a ACID compliance database, so this wouldn't be allowed. I think you know what that means: http://www.firebirdsql.org/devel/doc/papers/html/paper-fbent.html#paper-fbent-acid http://en.wikipedia.org/wiki/ACID Uwe _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
