Orindasoft

Including Legacy Oracle PL/SQL and SQL in your SOA

Scenario: Upgrading a Legacy Oracle System so it can become part of your SOA

You have a large, complex and functioning Legacy Oracle system with lots of PL/SQL procedures and complex queries. You need to expose Oracle as a web service as part of a migration to a Service Oriented Architecture (SOA). But you want to be able to call legacy PL/SQL as part of web service without having to rewrite and re-learn the esoteric JDBC skills associated with the legacy Oracle PL/SQL application. Neither do you want to end up tied to a specific service vendor's expensive proprietary implemention.

JDBCWizard generates vendor-agnostic Java services for your existing Oracle PL/SQL and SQL.

Instead of placing our bet on one specific Web Service platform we focused on representing legacy Java code as a stateless Java service with a single method call for each PL/SQL procedure or SQL statement. This drastically simplifies things for the people who are trying to integrate legacy Oracle and PL/SQL with your SOA as they don't need Oracle or JDBC skills and instead can work with generated Java classes. In more complex cases where PL/sQL records are being passed to Java or multiple values are returned JDBCWizard creates all the extra Java classes required to represent records, arrays and sets of output parameters, as well as a Java Interface to identify methods specific to the generated Oracle PL/SQL web service.

This approach also has interesting implications for customers that may bee seeking to replace Oracle and PL/SQL at a future date with either another database or something else entirely, as it effectively abstracts the database from the applications that wish to use it.