OrindaBuild and Oracle JDeveloper 10g

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 can be used stand alone or as a Addin for JDeveloper 10g.

There is a Macromedia Flash presentation that shows how OrindaBuild Works.

There's also information on the business case for using OrindaBuild and our consultancy service.

OrindaBuild™ can be used standalone or as an extension for Oracle JDeveloper 10g. For detailed information on OrindaBuild™ see the JDeveloper Addin Manual or the Documentation page. A full featured demo of OrindaBuild can be downloaded here.

Features:

• Fully Integrated with JDeveloper 10g - OrindaBuild can be installed as an extension for Oracle's JDeveloper.
• Intuitive and straightforward - OrindaBuild has a wizard based user interface that walks you thorugh the code generation process.
• No precompilers needed - No requirement to use SQLJ. OrindaBuild writes complete and human readable calls to PL/SQL procedures using a GUI and has no external dependencies other JDBC drivers.
• Writes Code for PL/SQL procedures - OrindaBuild can write Java source code to run your PL/SQL procedures.
• Writes Code for Tables - OrindaBuild writes persistance and navigation code for tables.
• Writes Code for any SQL statement - OrindaBuild can write Java source code to run any SQL statement with minimal user effort.
• No mysterious runtime component - Everything is done with human readable source code.
• Large object support - BLOBs, CLOBs and BFILE parameters can be treated as java.io.File objects.
• VARRAY Parameter Support - OrindaBuild generates code for Procedures that take TABLE or VARRAY TYPE objects as parameters.
• Oracle Focused - OrindaBuild is optimized for Oracle. For more information see here.
• Also works with Eclipse - OrindaBuild also runs as a Plugin for Eclipse.
• Flexible Licensing - OrindaBuild is available for periods ranging from one month to a year or even forever. When the license expires you can maintain the code by hand. Generated code does not stop working because your licence has expired.
• No Schema Changes - OrindaBuild does not create any additional database objects such as Procedures, Views or Tables.
• Easy Install - The OrindaBuild extension can be installed using the "Check For Updates" feature in JDeveloper 10g