My Oracle Support Banner

"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 FEBRUARY 27, 2019

Applies to:

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

Symptoms

NOTE: In the examples below, source (JMS_QUEUE_XML) and connection (MYQUEUE) names represent a fictitious sample for clarity. Any similarity to actual environments, past or present, is purely coincidental and not intended in any manner.

 

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 MYQUEUE.
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://<HOST_DOMAIN_NAME>/notifyitemmaster}ActionExpression" from "{http://<HOST_DOMAIN_NAME>/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)

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.