"The XML construct ... is not supported by XML JDBC driver" When Testing The Connection To An XSD File With The ODI Version 11.1.1.7 XML Driver Version 3 (compat_mode=3) (Doc ID 1570192.1)

Last updated on SEPTEMBER 21, 2017

Applies to:

Oracle Data Integrator - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

Symptoms

When extracting an XML instance file from an Oracle Data Integrator (ODI) version 11.1.1.6.0 JMS QUEUE XML Dataserver, the following message is signaled:

ODI-1227: Task SrcSet0 (Loading) fails on the source JMS_QUEUE_XML connection LOCAL_ITEMMAST_XSD.
Caused By: java.sql.SQLException: class java.sql.SQLException
com.sunopsis.tools.core.exception.SnpsRuntimeException: ODI-40798: Unknown type: {0}element
 at com.sunopsis.jdbc.driver.xml.SnpsXmlFile.readDocument(SnpsXmlFile.java:459)
 at com.sunopsis.jdbc.driver.xml.SnpsXmlConnection.readStream(SnpsXmlConnection.java:1500)
 at com.sunopsis.jdbc.driver.JMSXMLPreparedStatement.loadJMS(JMSXMLPreparedStatement.java:768)
 at com.sunopsis.jdbc.driver.JMSXMLPreparedStatement.execute(JMSXMLPreparedStatement.java:154)

 Moreover, when testing the associated XSD file with the ODI version 11.1.1.7 XML driver version 3 (compat_mode=3), the following error message is signaled:

java.sql.SQLException: ODI-40738: A SAXException was caught while reading the model saying:
ODI-40946: Error processing XSD/DTD(cause: oracle.odi.jdbc.driver.xml.model.exceptions.OdiXmlUnsupportedDataTypeException:
ODI-40939: The XML construct "Mixed type" in "{http://www.server.com/notifyitemmaster}ActionExpression" from "{http://www.server.com/notifyitemmaster}ns.ActionExpression" is not supported by XML JDBC driver)
 at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:133)
 at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:62)
 at com.sunopsis.sql.SnpsConnection.testConnection(SnpsConnection.java:1125)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms