[
https://jira.jboss.org/browse/TEIID-108?page=com.atlassian.jira.plugin.sy...
]
Steve Hawkins commented on TEIID-108:
-------------------------------------
The workaround for 7.0 when using timestamp, date, or time types with xmltable is to wrap
the xpath expression in an appropriate function, e.g.
columns t timestamp path 'xs:dateTime(<some path>/text())'
after this fix, you'll be able to just use
columns t timestamp path '<some path>'
xsd type conversion should be consistent
----------------------------------------
Key: TEIID-108
URL:
https://jira.jboss.org/browse/TEIID-108
Project: Teiid
Issue Type: Bug
Components: SOAP Services, XML Connector
Affects Versions: 6.0.0
Reporter: Steven Hawkins
Fix For: 7.1
Defect Tracker #23654: [This came from our consultant Jimmy Fernandez' Case 4795, for
customer MITRE].
Jimmy wrote: "When modeling Web Services with our Web Service to relational importer
and the column type on the request table out are dateTime objects; the SOAP/XML connectors
should be converting the specific column to the xsd:dateTime object specifications. It
would not hurt to ensure that we are following the correct specification for other xsd
objects as well."
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira