On Mon, 26 Apr 2010, Arne Vajh?j wrote:
My preference is: if database need to be accessed by apps in different
technology, then it makes sense to put the business logic in SP's -
otherwise I would keep the business logic in the Java code, because
that makes it a lot cheaper to work with a different database -
It's worth mentioning that the modern alternative approach here is to
put hide the database completely behind the java, and expose the
functionality through web services. Rather than having other apps talk
to the database directly, they make calls to the java layer. That lets
you raise the level of abstraction in the other apps, reuse
functionality in the java, and maintain the invariants enforced by the
business logic in the java.