JDBCWizard Oracle and PL/SQL Web Service Generator for Oracle - Product Features

JDBCWizard 6.0 is a web service generator for people who use Javai and who need to access Oracle and PL/SQL:

• It automates almost everything by examining your Oracle database and your SQL statements.
• It can write code to access procedures with Oracle's proprietary %ROWTYPE, PL/SQL Record and PL/SQL Package Array parameters, even though they aren't directly supported by JDBC. Where possible it returns cursors as arrays of class instances.
• It has a step-by-step Wizard interface that lets you pick database objects and SQL statements. then it writes Java to run them for you. You don't need to understand the inner workings of Oracle to access Oracle.
• For detailed information on JDBCWizard see the Documentation page or read the White Paper.
• Click here to download a fully working demo of JDBCWizard.

Features:

• Intuitive and straightforward - A Swing GUI lists existing database objects and makes creating code trivial.
• JDBCWizard can be run by itself, as an Eclipse Plugin, an Oracle SQLDeveloper Plugin or an Oracle JDeveloper 10g Extension
• Generates Java Source Code To Run PL/SQL procedures - JDBCWizard can write Java source code to run most of your PL/SQL procedures.
• Generates Java Source Code To Access Tables - JDBCWizard writes persistance and navigation code for tables.
• Generates Java Source Code To Run Any SQL statement - JDBCWizard can write Java source code to run any SQL statement with minimal user effort.
• JSR181 Compatible - generated code has JSR181 @WebService and @Webmethod annotations.
• Large object support - BLOBs, CLOBs and BFILE parameters can be treated as java.io.File objects.
• VARRAY Parameter Support - JDBCWizard generates code for Procedures that take TABLE or VARRAY TYPE objects as parameters.
• No Schema Changes - JDBCWizard does not require or create any additional database objects such as Procedures, Views or Tables.
• Fully Integrated with JDeveloper 10g - JDBCWizard can be installed as an extension for Oracle's JDeveloper 10g.
• Fully Integrated with Eclipse 3.0 - JDBCWizard can be installed as an plugin for Eclipse
• Web Service Generation - JDBCWizard can generate web service code that is compatible with products such as Apache Axis.
• Fully Integrated with SQL Developer - JDBCWizard can be installed as an extension for Oracle's SQL Developer.
• No precompilers needed - No requirement to use SQLJ. JDBCWizard writes complete and human readable calls to PL/SQL procedures using a GUI and has no external dependencies other JDBC drivers.
• Writes Code to access Table - JDBCWizard writes persistance and navigation code for tables.
• No 'mysterious' runtime component - Everything is done with human readable source code.
• VARRAY Parameter Support - JDBCWizard generates code for Procedures that take TABLE or VARRAY TYPE objects as parameters.
• Oracle Focused - JDBCWizard is optimized for Oracle. For more information see here.
• Also works with JDeveloper 11g - JDBCWizard also runs as a Plugin for JDeveloper.

Compatability:

• Oracle Database Server - JDBCWizard works against all versions of Standard and Enterprise Oracle from V8.1.5 (8i) to V11.2 (11g). JDBCWizard works with Oracle XE but is not supported against Oracle Lite.
• Java - JDBCWizard is developed and tested with Sun Java 1.4 and higher.
• Operating Systems - JDBCWizard is supported on Sun Solaris, Linux and Windows.
• SQL*Net/Precompilers - JDBCWizard uses the Oracle 'thin' driver and does not require SQL*Net or a precompiler.

Pricing & Licencing:

• Run time Binaries - There isn't one. JDBCWizard is a source code generator. Generated code uses a library called 'com.orindasoft.pub'. Purchasers get the source code to this library as well as the ability to generate all the code they want.
• Licence Periods - Orinda software offers 3, 6, 9, 12 month and perpetual licences. When the licence expires you can no longer generate new code but existing code keeps working.
• Purchase Methods - JDBCWizard can be bought online using WorldPay or PayPal. We also take purchase orders by prior agreement.
• Support - JDBCWizard comes with web and email support for the duration of the licence. Higher levels of support are available for site licence purchasers.