JPA and Stored Procedures - welcome to our blog Techno Live, now we will discuss information about the JPA and Stored Procedures, our admins on this blog has been around to collect information you are looking for so that we usakan to display complete information for you, and in this blog, you can also search for other information, ok please continue reading may be easily understood:

This is about : JPA and Stored Procedures
And this article : JPA and Stored Procedures

JPA and Stored Procedures

I recently stumbled upon many queries on google about how to make Stored Proc calls via JPA. Something was not right with questions like this.

Stored Procs and JPA are completely different beasts with completely different philosophies behind them. Sure you can call stored procs using JPA but thats using the wrong hammer. JPA deals with persistence of entities; Stored procs, with business logic being closest to the data.

If you have a lot of business logic in stored procs, you have the advantage of speed, security and maintainability, however, you lose portability of your business logic if you change your database. Now, in any large-scale enterprise, the database vendor is not really going to change and a database (oracle/sql server/db2) is going to be a uniform commitment across the organization. Having said that, even if you have to port the procs from one database to another, the vendor documentation will include quite comprehensive migration guides for the same. They have to :) For the record, IMHO, I normally stick with stored procs for the reasons listed above. I always have some real DBA cats working on my team that perform something called ATM (Application Transaction Modelling) on the database. Look it up (ATM). Once they are through with this you can flex your ORM muscles all you like, but in the end what you will be left with will just be UGLY. 

Been there, done that, got the T-Shirt.  

If there's one book you should read on JPA, let it be this:

Articles JPA and Stored Procedures finished we discussed

A few of our information about the JPA and Stored Procedures, I hope you can exploit carefully

No've You've finished reading an article on JPA and Stored Procedures and many articles about modern home in our blog this, please read it. and url link of this article is http://liveeconcerts.blogspot.com/2009/03/jpa-and-stored-procedures.html Hopefully discussion articles on provide more knowledge about the world of tech gadgets.

Tag :

Tweet