OrindaBuild and Oracle SQL Developer

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.

Create Java Services on demand from within SQL Developer using OrindaBuild

OrindaBuild is available as a SQL Developer extension. Once installed it allows you to create a Java service class to run your PL/SQL and SQL with a few mouse clicks.

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.

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 SQL Developer. For detailed information on OrindaBuild™ see the SQL Developer Addin Manual or the Documentation page. A full featured demo of OrindaBuild can be downloaded here.

The OrindaBuild update center for SQL Developer is here:

http://www.orindasoft.com/public/sqldev15Center.xml

Information on how to use this update center to install a demo is here.

Features:

• Fully Integrated with SQL Developer - OrindaBuild can be installed as an extension for Oracle's SQL Developer.
• 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 JDeveloper 11g - OrindaBuild also runs as a Plugin for JDeveloper.
• 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.