If a naive design is followed, JDBC code rapidly becomes repetitious. JDBC is one area where applying the "Don't Repeat Yourself" guideline found in The Pragmatic Programmer (Hunt and Thomas) has large rewards. Reducing code repetition :

• greatly increases the quality of the design
• minimizes ripple effects when changes occur
• decreases the size of the code base

The following topics present examples of removing code repetition when accessing the database :

• Simplify database operations
• Encapsulate connections
• Use template for transactions

Data exception wrapping

Yes   No   Undecided