Why doesn the Java Pet Store Demo use stored procedures?
A. We don’t use stored procedures since they will result in a non-portable application. Our design allows, however, for stored procedures to be added elegantly–all you need to do is to provide an alternate Data Access Object that plugs into the application architecture and makes stored procedure calls. These are essentially a performance optimization that are particular to a specific application and its deployment environment. For this reason, it falls outside the scope of Java Enterprise BluePrints which focuses on the application programming model.
