File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Object Relational Mapping and the fly likes Oracle stored procedures and Hibernate Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Oracle stored procedures and Hibernate" Watch "Oracle stored procedures and Hibernate" New topic

Oracle stored procedures and Hibernate

Durin Dal

Joined: Aug 20, 2009
Posts: 2
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

Thanks in advance...
Bhagat Singh Rawat
Ranch Hand

Joined: Apr 04, 2009
Posts: 93
Here is the solution of your's problem:Stored Procedures with Hibernate

Brainbench Java 2.0 Fundamentals, J2EE 1.4
I agree. Here's the link:
subject: Oracle stored procedures and Hibernate
It's not a secret anymore!