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.
Difference between revisions of "EclipseLink/Development/DBWS/AdvancedJDBCTypesThruJPub"
< EclipseLink | Development | DBWS
Line 16: | Line 16: | ||
== DBWS utility enhancement: support for Advanced JDBC types thru JPub == | == DBWS utility enhancement: support for Advanced JDBC types thru JPub == | ||
[https://bugs.eclipse.org/bugs/show_bug.cgi?id=271679bug 271679] <br/> | [https://bugs.eclipse.org/bugs/show_bug.cgi?id=271679bug 271679] <br/> | ||
+ | |||
+ | Similar to the work supporting advanced PL/SQL types (records, collections), DBWSBuilder should use <code>o.e.p.platform.database.oracle.publisher.sqlrefl.SqlReflector</code> to extract the database | ||
+ | metadata for Stored Procedures that use Advanced JDBC types: | ||
+ | <css> | ||
+ | .source-sql {border-style: solid;} | ||
+ | </css> | ||
+ | <source lang=sql> | ||
+ | -- 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; | ||
+ | {/source} |
Revision as of 13:52, 16 April 2009
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; {/SOURCE}