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