Difference between revisions of "EclipseLink/Development/DBWS/AdvancedJDBCTypesThruJPub"

Revision as of 14:03, 16 April 2009

DBWS Schema Naming Convention Transformers

Document History

DBWS utility enhancement: support for Advanced JDBC types thru JPub

271679

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;

Extracting the database metadata for the above artifacts via the JDBC metadata API java.sql.DatabaseMetaData is difficult and not standard across different database platforms. For support on Oracle, the JPub-derived SqlReflector is used to extract the database metadata.