I am looking to find out how the majority of companies do iterative unit testing with DB2 or Oracle. Are Personal Edition (PE) or Enterprise databases used? If PE databases are used, who creates the DB, who does the data modeling, populating, etc?
Theresa, Welcome to JavaRanch! We do run developer tests against the database. We call them integration tests to separate them from the unit tests where we mock out the database. Our project is currently in the midst of migrating from DB2 to Oracle.
For both databases, each developer has the Personal Edition installed. We have the ddl and development sql in CVS. Whenever we pull in code and the schema has changed, we all run it again. This happens often during some parts of development. All tests are expected to run against the schema/sql in CVS and clean up after themselves.