Skip to main content

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.

Jump to: navigation, search

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

(New page: <div style="margin:5px;float:right;border:1px solid #000000;padding:5px">__TOC__</div> == DBWS Schema Naming Convention Transformers == == Document History == {|{{BMTableStyle}} |-{{BMTHS...)
 
Line 1: Line 1:
<div style="margin:5px;float:right;border:1px solid #000000;padding:5px">__TOC__</div>
+
__NOTOC__
 
== DBWS Schema Naming Convention Transformers ==
 
== DBWS Schema Naming Convention Transformers ==
  
Line 16: Line 16:
 
== DBWS utility enhancements ==
 
== DBWS utility enhancements ==
 
[https://bugs.eclipse.org/bugs/show_bug.cgi?id=234677 bug 234677] The DBWSBuilder utility should allow user to alter names of the generated schema type. The algorithm the DBWSBuilder utility uses two very simple rules:
 
[https://bugs.eclipse.org/bugs/show_bug.cgi?id=234677 bug 234677] The DBWSBuilder utility should allow user to alter names of the generated schema type. The algorithm the DBWSBuilder utility uses two very simple rules:
** table name ==> translate any characters un-supported by XML ^1^ ==> to_lowercase ==> add suffix 'Type' ==> top-level complex element type in {{.xsd}} file
+
** table name ==> translate any characters un-supported by XML <sub>1</sub> ==> to_lowercase ==> add suffix 'Type' ==> top-level complex element type in {{.xsd}} file
** column name ==> translate characters ==> to_lowercase ==> element tag name ^2^ \\
+
** column name ==> translate characters ==> to_lowercase ==> element tag name <sub>2</sub>
^1^ - same algorithm documented as part of the SQL/X (a.k.a. SQL/XML:2003) specification) \\
+
<sub>1</sub> - same algorithm documented as part of the SQL/X (a.k.a. SQL/XML:2003) specification)
^2^ - All columns expressed as XML elements;
+
<sub>2</sub> - All columns expressed as XML elements;

Revision as of 12:23, 11 September 2008

DBWS Schema Naming Convention Transformers

Document History

Date Author Version Description & Notes
080911 Mike Norman 1.0

DBWS utility enhancements

bug 234677 The DBWSBuilder utility should allow user to alter names of the generated schema type. The algorithm the DBWSBuilder utility uses two very simple rules:

    • table name ==> translate any characters un-supported by XML 1 ==> to_lowercase ==> add suffix 'Type' ==> top-level complex element type in Template:.xsd file
    • column name ==> translate characters ==> to_lowercase ==> element tag name 2

1 - same algorithm documented as part of the SQL/X (a.k.a. SQL/XML:2003) specification) 2 - All columns expressed as XML elements;

Back to the top