In my quest to resolve my ongoing architectural inner struggle, I’ve run across this article by Eric Bruno a couple of times. It’s old (September 2005), but it may still be pertinent.
Use Stored Procedures for Java Persistence
I hope to hear from Eric soon about his current stance on the topic. A lot can change in 2 1/2 years!
Full Stack Code Attack 