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}