!rant

Using Java is there a framework for building functional tests?

For unit testing we use JUnit but when I'm writing my code, often I need to debug against an actual db, for example, to be able check it actually will work and return the results I expected (and mocked in the unit test).

Also generally what is the best order of testing and development? I know TDD is the big one but again unit tests won't catch things like using the wrong query.

And I think the goal of unit tests is to make sure your methods behave as expected and also serve as documentation so someone doesn't accidentally break existing functionality when you change the code?