Notice: This Wiki is now read only and edits are no longer possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.
EclipseLink/Development/DBWS/AdvancedJDBCTypesThruJPub
DBWS Schema Naming Convention Transformers
Document History
Date | Author | Version Description & Notes |
---|---|---|
090416 | Mike Norman | 1.0 |
DBWS utility enhancement: support for Advanced JDBC types thru JPub
Similar to the work supporting advanced PL/SQL types (records, collections), DBWSBuilder should use o.e.p.platform.database.oracle.publisher.sqlrefl.SqlReflector
to extract the database
metadata for Stored Procedures that use Advanced JDBC types:
-- a series of nested types CREATE TYPE Region AS OBJECT ( reg_id NUMBER(5), reg_name varchar2(50) ); CREATE TYPE Emp_Address AS OBJECT ( street varchar2(100), suburb varchar2(50), postcode INTEGER, addr_region REGION ); CREATE TYPE Emp_Object AS OBJECT ( employee_id NUMBER(8), employee_name VARCHAR2(80), date_of_hire DATE, address emp_address ); -- a Stored Procedure (function) that uses 'root' of nested types package advanced_object_demo AS FUNCTION echoEmployee (pEmployee IN Emp_Object) RETURN Emp_Object; END advanced_object_demo;