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.
You don't need to know how PL/SQL works or how to get it to work with JDBC to create fully functional JSR181 compliant Java Web Services.
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