aspose file tools
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

Win a copy of The Software Craftsman this week in the Agile forum!
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
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
subject: Oracle stored procedures and Hibernate