Red Squirrel Reflection - 12/01/2003: JDBC Development without a Database

Red Squirrel Reflections

Dave Hoover explores the psychology of software development

[Previous entry: "Customer Appreciation"] [Main Index] [Next entry: "More McConnell"]

JDBC Development without a Database
Monday, December 1, 2003

I am the architect on a small J2EE project. It is our WebSphere pilot project. The database schema is small, with only a few associations. The development database instance hasn't been created yet, but I needed to start developing the skeleton of the application.

Not surprisingly, I started with a test. Because the database schema is simple, I opted for the Active Record pattern. Using the com.mockobjects.sql package, I was able to drive the design of the application's domain objects...without a database.

Once the database is ready, I am looking forward to swapping ConnectionFactoryImpl with ConnectionFactoryMock and seeing how many SQL typos I made.

Posted by Dave