Office applications Toolkit

Integrating Oracle and Java: Optimising your development platform for ERP apps

Tags:
ERP,
Oracle,
Java

Scott Robinson Tech Republic

Published: 06 Jun 2003 11:05 BST

Bringing Oracle and Java together in your development environment gives you an exceptionally flexible and robust application development and data-handling infrastructure that fronts an excellent data management system and is easily extended in enterprise resource planning. On top of that, it's extremely Internet-friendly, an increasingly important consideration.

The complication you must address in choosing them in combination for application development, particularly in an ERP environment, is that there is so much available that prudent choices require some forethought. Here's a rundown on which parts of Java are especially useful with Oracle 8i, the specifics of Oracle's accommodation of Java, and how these can work well in ERP applications.

JServer: A Java machine living inside Oracle
Beginning with 8i, Oracle has included JServer, a suite of Java facilities that deeply integrate Java and Oracle in powerful ways. This suite features an accommodation of Java that brings all the ERP-friendly characteristics of Java -- its platform independence, its flexibility in communication modes, and its powerful class library and tool base -- directly into the Oracle database environment, where database interaction and efficiency can be firmly bound to Java's application strengths.

You pay a price in complexity, to be sure, but you increase the potential power of your application interfaces by an order of magnitude (very important in ERP distributed apps where one application has multiple interfaces). You avail yourself of all the robustness of Oracle in external applications (a powerful consideration in an extended ERP environment containing multiple databases), and your interfaces are instantly portable to other environments -- a boon for ERP systems.

Rethinking PL/SQL
ERP systems are primarily about tying multiple databases to myriad external applications in new ways, increasing data accessibility by an order of magnitude or so in the process (for the purpose of feeding external applications, even extending to the systems of other companies). A primary consideration in choosing an interface mechanism, then, is the facility with which an external application can execute procedures that are read- or write-intensive while accommodating multiple access paths to foreign platforms and maintaining security in the bargain. You need an extremely flexible interface toolkit for such an undertaking, and the more class libraries, the better.

Your first and foremost design choice is considering whether to hand off to Java a number of duties that you would otherwise assign to PL/SQL. How can you do this? With a Java Stored Procedure (JSP), also known as a Java Method. Since 8i, Oracle has permitted Java as a language for implementing the same sort of external procedures that are commonly assigned to PL/SQL.

Go to section: