OrindaBuild Plugin for PL/SQL Developer 7.0
OrindaBuild helps you interact with Oracle by creating a Java service to call your PL/SQL procedures and SQL statements as well as access tables.
Why Use OrindaBuild to call PL/SQL instead of Hibernate or JPublisher?
Object-Relational persistence tools like Hibernate assume that the database is nothing more than a persistence mechanism. Most real world databases are far more complicated. Working with them involves issuing elaborate and tuned SQL statements as well as calling PL/SQL procedures with multiple and complicated parameters that may include records and arrays.
OrindaBuild examines your SQL statements and PL/SQL procedures and writes the Java source files for a service that can be easily integrated with your environment. Using OrindaBuild involves minimal changes to your SQL statements and no changes to your PL/SQL.
If you need to call complicated PL/SQL procedures and SQL statements from your Java tools such as JPublisher and Hibernate force you to change your code, your IDE, your development environment, or your database schema. OrindaBuild does not place limitations of the type or order of parameters in PL/SQL procedures and happily supports records and arrays. OrindaBuild also does conventional Object/Relational persistence. OrindaBuild doesn't have a runtime engine and never needs to be used against a production database.
OrindaBuild is used stand alone or as a plugin for PL/SQL Developer.
There is a Macromedia Flash presentation that shows how OrindaBuild Works.
OrindaBuild™ is fully integrated with PL/SQL Developer 7.0.
PL/SQL Developer users generate Java to run their code with a couple of mouse clicks .
For more information see the
OrindaBuild PL/SQL Developer 7.0 plugin manual or the
Documentation page.
A free fully functioning limited life demo of OrindaBuild™ can be downloaded here. OrindaBuild can be bought online using WorldPay. If you buy OrindaBuild online you end up with a 100% human readable Java source code solution that doesn't require additional libraries, third party tools or precompilers.
There's also information on the business case for using OrindaBuild and our consultancy service.
OrindaBuild also creates a matching Data Access Object factory class and Web Service classes for your chosen SQL statements and PL/SQL procedures.
Create Java to call your PL/SQL procedures by right-clicking in the PL/SQL Developer User Interface:
Features:
- Generates Java - Creates Java source code to run your PL/SQL procedures and functions using JDBC.
- %ROWTYPE and Record support - Generated Java calls PL/SQL procedures that take arrays, records and %ROWTYPE as parameters.
- Service Generation - Generates all the classes needed to call your PL/SQL as part of a Java service.
- Low Impact - Does not require schema changes or the use of a precompiler
- Flexible - Writes Java to run any SQL Statement
- Readable Code - Writes human readable Java code
- Easy to use - Wizard based interface makes configuration easy
- Integrated - Integrated with PL/SQL Developer 7.0 GUI
- Prerequisites - PL/SQL Developer 7.0, Java 1.4 or higher.
