x node mapping with sql server

, ,
1

hi

my sql server database contains a field of type tiny int. when i tried to map the table through x node i got the error message that inoxse8965

how i can map the same field.

regards sreeju

2

Hi,
According to the documentation (Tamino XML Schema User Guide —
Appendix 1: Available and Recommended Data Types for Mapping to X-Node/SQL) the type TINYINT is not supported but it could, for example, be mapped to xs:short.
HTH

3

Hi, I would like open this topic due to I spent the last hours trying to define an Xnode schema with a tiny int data in an sql server database mapped to an xs:short and I had the same failure all the time.
<ino:response xmlns:ino=“http://namespaces.softwareag.com/tamino/response2” xmlns:xql=“XQL FAQ (XML Query Language - Frequently Asked Questions)”>
<ino:message ino:returnvalue=“7931”>
<ino:messagetext ino:code=“INOXDE7931”>An error occurred while processing a schema document</ino:messagetext>
ino:messagelineINOXSE8965: Line 41, Column 17: Invalid data type value</ino:messageline>
</ino:message>
</ino:response>
the schema is the following
I will appreciate if someone had idea why when I use data that could be mapped to a short the schema couldn’t define.
I had the same problem with bit data type.
regards, Ro

<?xml version="1.0" encoding="utf-8"?>

<xs:schema attributeFormDefault=“unqualified” elementFormDefault=“unqualified” ino:docname=“test/test” ino:id=“27” xmlns:ino=“http://namespaces.softwareag.com/tamino/response2” xmlns:tsd=“http://namespaces.softwareag.com/tamino/TaminoSchemaDefinition” xmlns:xs=“XML Schema”>
xs:annotation
xs:appinfo
<tsd:schemaInfo name=“sql2-data_pass_mv-TINYINT”>
<tsd:collection name=“MSSQLSERVER”/>
<tsd:doctype name=“sql2-data_pass_mv-TINYINT”>
tsd:logical
tsd:contentclosed</tsd:content>
</tsd:logical>
</tsd:doctype>
tsd:adminInfo
tsd:server4.2.1.1</tsd:server>
tsd:versionTSD4.2</tsd:version>
tsd:created2001-10-19T18:43:21.093-04:00</tsd:created>
tsd:modified2001-10-19T18:43:21.093-04:00</tsd:modified>
</tsd:adminInfo>
</tsd:schemaInfo>
</xs:appinfo>
</xs:annotation>
<xs:element name=“sql2-data_pass_mv-TINYINT”>
xs:annotation
xs:appinfo
tsd:elementInfo
tsd:physical
tsd:map
<tsd:subTreeSQL datasource=“Microsoft SQL Server:sql2” table=““TINYINT”” userid=“mvaleria” password=“2257mjva”>
tsd:primarykeyColumnnumero</tsd:primarykeyColumn>
tsd:primarykeyColumntext</tsd:primarykeyColumn>
</tsd:subTreeSQL>
</tsd:map>
</tsd:physical>
</tsd:elementInfo>
</xs:appinfo>
</xs:annotation>
xs:complexType
xs:sequence
<xs:element name=“numero” type=“xs:short”>
xs:annotation
xs:appinfo
tsd:elementInfo
tsd:physical
tsd:map
<tsd:nodeSQL column=“numero”/>
</tsd:map>
</tsd:physical>
</tsd:elementInfo>
</xs:appinfo>
</xs:annotation>
</xs:element>
<xs:element name=“text” type=“xs:string”>
xs:annotation
xs:appinfo
tsd:elementInfo
tsd:physical
tsd:map
<tsd:nodeSQL column=“text”/>
</tsd:map>
</tsd:physical>
</tsd:elementInfo>
</xs:appinfo>
</xs:annotation>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>