What is OrindaBuild?
OrindaBuild writes the Java source needed to access the PL/SQL procedures and other objects in your database. OrindaBuild was written as a stand-alone Java application and has now been 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 fully functional demo can be downloaded here .
Benefits:
Full PL/SQL Syntax usable from Java
PL/SQL includes many elements of syntax that are not covered by the JDBC standard. Calling any procedure with parameters other than scalar variables and cursors normally requires the creation of wrapper procedures or other steps that add time and complexity to the development process.
A good example of this is the package below. While straightforward from a PL/SQL perspective, most Java developers would encounter significant difficulty in writing the JDBC calls needed to run the procedures from Java. OrindaBuild effortlessly generates all the Java code needed. To see this and other generated code click here
Reduced Development Time
By automating the Java access code creation process OrindaBuild reduces the development time needed and makes it much easier to make changes to existing code.
Tables
OrindaBuild also writes persistence code for tables. In addition to the obvious insert, update and delete operations generated code will allow retrieval by any Key or indexed set of columns.
SQL statements
OrindaBuild can write a Java class around any SQL statement. It understands the formats used for parameters in SQL*Plus and JDBC. It will create matching parameters in the generated code. An example of this is here
DAO/Service Generation
In addition to the minimal set of Java classes needed to run your stored procedures OrindaBuild also writes supporting Data Access Object classes that simplify usage of the generated code. An Example of a DAO class is here
OrindaBuild also generates a Service class that allows any procedure to be called in one Java method call. See here
No Precompilers / 100% Source Code
OrindaBuild generated code does not require the use of a precompiler. It does not require schema changes. It does not create persistent database objects. Generated code uses a Java library, the source code for which is included in the full version of the product.
Pricing and Licensing
A full OrindaBuild license is US$299. This includes email support for a two-year warranty period and a generator that will work indefinitely. There is no runtime license or requirement to use the OrindaBuild binaries in a production system.
Versions and Prerequisites
The OrindaBuild Plugin works with PL/SQL Developer 7.0. Because the plugin uses new features in the 7.0 API. It does not work with PL/SQL developer versions prior to 7.0.
OrindaBuild requires Sun Java 1.4 or 1.5.
OrindaBuild works against all Oracle server versions from 8.1.5 to 10.2.0 inclusive. OrindaBuild does not work with some versions of Personal Oracle but does work with XE.
Demo Download
A fully functional time limited demo can be downloaded here
OrindaBuild writes the Java source needed to access the PL/SQL procedures and other objects in your database. OrindaBuild was written as a stand-alone Java application and has now been 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 fully functional demo can be downloaded here .
Benefits:
Full PL/SQL Syntax usable from Java
PL/SQL includes many elements of syntax that are not covered by the JDBC standard. Calling any procedure with parameters other than scalar variables and cursors normally requires the creation of wrapper procedures or other steps that add time and complexity to the development process.
A good example of this is the package below. While straightforward from a PL/SQL perspective, most Java developers would encounter significant difficulty in writing the JDBC calls needed to run the procedures from Java. OrindaBuild effortlessly generates all the Java code needed. To see this and other generated code click here
Code:
CREATE OR REPLACE PACKAGE complex_example AS
--
TYPE city_pair_plsql_record IS RECORD (from_city flights.departure_city%type
,to_city flights.arrival_city%type);
--
PROCEDURE flies_between_all (p_first_city_pair in city_pair_oracle_type
,p_second_city_pair in city_pair_plsql_record
,p_third_city_from in airports%ROWTYPE
,p_third_city_to in airports%ROWTYPE
,p_airline_list out simple_examples.airline_refcursor_type);
--
PROCEDURE get_table_of_flights_from (p_city in flights.departure_city%TYPE
,p_flights_from out flights_table);
--
PROCEDURE add_bookings (p_customer in customers%ROWTYPE
,p_booking_table in bookings_table
,p_status_message out varchar2);
--
END;By automating the Java access code creation process OrindaBuild reduces the development time needed and makes it much easier to make changes to existing code.
Tables
OrindaBuild also writes persistence code for tables. In addition to the obvious insert, update and delete operations generated code will allow retrieval by any Key or indexed set of columns.
SQL statements
OrindaBuild can write a Java class around any SQL statement. It understands the formats used for parameters in SQL*Plus and JDBC. It will create matching parameters in the generated code. An example of this is here
DAO/Service Generation
In addition to the minimal set of Java classes needed to run your stored procedures OrindaBuild also writes supporting Data Access Object classes that simplify usage of the generated code. An Example of a DAO class is here
OrindaBuild also generates a Service class that allows any procedure to be called in one Java method call. See here
No Precompilers / 100% Source Code
OrindaBuild generated code does not require the use of a precompiler. It does not require schema changes. It does not create persistent database objects. Generated code uses a Java library, the source code for which is included in the full version of the product.
Pricing and Licensing
A full OrindaBuild license is US$299. This includes email support for a two-year warranty period and a generator that will work indefinitely. There is no runtime license or requirement to use the OrindaBuild binaries in a production system.
Versions and Prerequisites
The OrindaBuild Plugin works with PL/SQL Developer 7.0. Because the plugin uses new features in the 7.0 API. It does not work with PL/SQL developer versions prior to 7.0.
OrindaBuild requires Sun Java 1.4 or 1.5.
OrindaBuild works against all Oracle server versions from 8.1.5 to 10.2.0 inclusive. OrindaBuild does not work with some versions of Personal Oracle but does work with XE.
Demo Download
A fully functional time limited demo can be downloaded here
