File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Testing and the fly likes Personal Edition Database Use Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Engineering » Testing
Bookmark "Personal Edition Database Use" Watch "Personal Edition Database Use" New topic

Personal Edition Database Use

Theresa Huff

Joined: Oct 12, 2005
Posts: 1
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?

Thank you,
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 33124

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.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
I agree. Here's the link:
subject: Personal Edition Database Use
It's not a secret anymore!