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 XML Driver Version 3 (compat_mode=3) (Doc ID 1570192.1)

Last updated on MAY 21, 2021

Applies to:

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


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 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 ODI-40798: Unknown type: {0}element
 at com.sunopsis.jdbc.driver.xml.SnpsXmlFile.readDocument(
 at com.sunopsis.jdbc.driver.xml.SnpsXmlConnection.readStream(
 at com.sunopsis.jdbc.driver.JMSXMLPreparedStatement.loadJMS(
 at com.sunopsis.jdbc.driver.JMSXMLPreparedStatement.execute(

 Moreover, when testing the associated XSD file with the ODI version 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(
 at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(
 at com.sunopsis.sql.SnpsConnection.testConnection(


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

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