Project Title: PL/J

The Challenge

Oracle PL/SQL to Java Migration Toolkit

The Solution

PL/J (Oracle PL/SQL to Java Migration Toolkit) enables deployment of business logic based on the Oracle PL/SQL code as pure Java applications with support for further migration. The PL/SQL program units (packages, stored procedures and functions) are translated into a pure Java source code, supported by Open Runtime Framework.

Migration of PL/SQL stored procedures into Java offers the following benefits:

• Reuse existing code base.
  
• Java is an open industry standard.
  
• Java development skills are common.

PL/J performs source-to-source conversion of Oracle 8i PL/SQL stored procedures and functions into a pure Java code, while preserving the transactional behavior and code structure of the source. Converted procedures can be executed by applications in the same way as original ones.

The resulting code can be compiled and run under Oracle Aurora Java Virtual Machine, or under any other Java 2?-compliant Java virtual machine. The resulting code is built on top of the industry standard JDBC (Java Database Connectivity), and InfoBus.

Depending on the edition of PL/J, the Open Runtime Framework can be provided in different packaging, from compiled jar files for evaluation purposes to an open source library for corporate customers willing to migrate.

After the conversion the resulting code can:

• Replace the existing PL/SQL code.
  
• Be installed into a separate database.
  
• Be packed for later installation into a single self-installing .exe or .jar file.
  
• Be prepared for later development with all the necessary project information.
  
• Be split into tiers or, on the contrary, merged according to performance considerations.

Two main components of the product can be identified:

PL/J performs conversion of PL/SQL modules into Java, by relying on the Open Runtime Framework. It is designed as classical three-pass compiler, and combines regular translation patterns with heuristics to simplify the resulting code. All PL/SQL types are mapped into Java classes, with static and dynamic type support.

The Open Runtime Framework specifies all the interfaces necessary to reimplement PL/SQL language structures (control and data types) to Java. It consists of two layers: an Abstraction Layer and a set of implementations, forming an Implementation Layer. The Abstraction layer defines Java interfaces and is what the compiler relies on. At the Implementation Layer all these interfaces are implemented according to the details of the underlying drivers, etc.

Migration of PL/SQL stored procedures into Java saves investment already made into PL/SQL development, reduces cost by not requiring special training for developers and gives the customer benefits of modern Java technology.

Tools and Technologies

• SML New Jersey
  
• XML
  
• Oracle 8i
  
• YACC
  
• LEX

Post Your Story, Tell All About Your Success!

If you want the story of your company to appear on the portal please fill out this form and send it to [email protected]. We would also like you to leave contact information (name, e-mail, phone) of a person who is responsible for filling the form to clarify any questions, which could appear.

Available Success Stories From Companies:

Disclaimer

All information contained in this Section is owned by RUSSOFT.org and its Participants and is protected by Russian and international copyright laws. Any reproduction or republication of all or part of this Section has to remain intact and include a notice on the copyright of RUSSOFT.org or the Participants, as applicable.

While the information of this Section has been presented with all due care, RUSSOFT.org does not warrant the accuracy, completeness, usefulness and truth of Section’s information, links and logos derived from third parties. RUSSOFT.org is not liable for any loss or damage occurring from the use of this Section’s materials.