Kbase P140318: READ-XMLSCHEMA method fails to create dynamic temp-table if default values specified in XSD
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/1/2009 |
|
Status: Unverified
SYMPTOM(s):
READ-XMLSCHEMA method fails to create dynamic temp-table if default values specified in XSD
Override-default-mapping parameter is TRUE
XSD defines an element with type="xsd:string" and default="<default value>" attributes set
Unable to set initial value '<value>' from XML Schema for field '<field>'. (13143)
FACT(s) (Environment):
OpenEdge 10.1x
OpenEdge 10.2x
All Supported Operating Systems
CAUSE:
Enhancement Request# 0000003889
CAUSE:
This is expected behavior.
READ-XMLSCHEMA will create a CLOB field for xsd:string type elements if Override-default-mapping is used.
It will attempt to use the value for the XSD element's default attribute to set the field's initial value, but CLOB fields do not support an initial value so an error is raised.
FIX:
An enhancement request is logged for better handling of this situation.
Workaround:
Do not set the Override-default-mapping parameter to TRUE if it is not necessary.
If it is necessary, manually specify an appropriate field-type-mapping list to ensure the string elements with a default value are mapped to the CHARACTER datatype.