Orindasoft

JDBCWizard - We generate Oracle JDBC calls so you don't have to!

JDBCWizard enables you to create Web Services for your existing Oracle database with minimal effort. JDBCWizard works for both PL/SQL procedures and SQL statements. JDBCWizard is designed specifically for Oracle and hides the complexity associated with real world PL/SQL that involves records and arrays.

Why Use JDBCWizard to create your Oracle web services?

Problem: Creating database web services is non-trivial.

The glue code that sits between your database and your web service engine will represent the bulk of your web service conversation effort. Not only that, it will need to be maintained as long as the underlying database exists. Creating this code may require more work than it took to create the database it uses.

Solution: JDBCWizard generates this code for you with minimal effort

Problem: Simply sticking a Java Data Access Object layer on top of Oracle does not give you web services.

Most existing systems will have business logic that is expressed with SQL statements. In such cases having access to the database schema is not enough - outside knowledge on how the data should be interpreted is required to turn the raw data stored in potentially hundreds of tables into valid business information. You can't simply issue 'dumb' SQL statements. You have to use ones that were carefully written by someone else.

Solution: JDBCWizard writes Java to run your key SQL statements as Java web services

Problem: Most existing systems will use lots of arcane PL/SQL, which you may not know much about.

PL/SQL is used in Oracle for pretty much any problem that can't be solved with a single SQL statement. But PL/SQL is an 3GL based on ADA. It makes extensive use of records and arrays as parameters and these can be hard to access using Java as JDBC doesn't really understand all of them. More importantly none of your developers will know all the details of this or want to learn them.

Solution: JDBCWizard can create Java services for your PL/SQL wthout you having to understand the details of JDBC and PL/SQL

Problem: Most PL/SQL procedures were never designed with JDBC in mind

PL/SQL handles parameters totally differently from Java, and as a result the code to call a procedure as a service can be amazingly complicated and verbose

Solution: JDBCWizard creates all the Java classes you need to create PL/SQL web services without you having to waste time coding them yourself

Next Steps...

Download your free, fully functioning limited life demo of JDBCWizard here. Single user JDBCWizard licences can be bought online for between US$199 and US$9999. For information on site licences email us at v6sales at orindasoft dot com.

If you buy JDBCWizard online you end up with a 100% human readable Java source code solution that doesn't require additional libraries, third party tools or precompilers.

If you buy a perpetual licence (US$9999) you also get a free internet based consultation with a product expert. We'll help you generate your Java source code and assist with any implementation issues you have. For more information see our consultancy page.

For more information on how JDBCWizard works, the business case for using JDBCWizard. our consultancy service, the Eclipse 3.5 Web Service Plugin, the Oracle SQL Developer extension see below.

JDBCWizard Logo

Core product features - How JDBCWizard works and what it can do for you.

Eclipse 3.0

Information on the JDBCWizard Plugin for Eclipse users.

JDeveloper 11g

Find out about JDBCWizard.s extension for JDeveloper 11g users.

SQL Developer 1.5

How JDBCWizard works as a plugin for Oracle's SQL Developer.