This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
I am working on a project (JSF web app running against an Oracle database) for a client and evaluating Hibernate for use with it, but the client requirement database-wise is that only stored procedures be used, even for CRUD operations on a single table. Does using Hibernate in this scenario even make sense? One can use Hibernate to execute stored procedures (in DAOs or whatever), but it appears that the Hibernate object mapping uses SQL syntax only and can't use stored procedures, from what I've read so far. If I'm off-base, then some pointers in the right direction would be appreciated. :-T