My Oracle Support Banner

"No DTD found and no XML file provided: the XML schema cannot be created" Message when Loading Data from OC4J JMS Queue Using an ODI Scenario Launched from the Startscen Script (Doc ID 794361.1)

Last updated on NOVEMBER 08, 2019

Applies to:

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

Symptoms

The following message is signaled when loading data from an OC4J JMS Queue using an Oracle Data Integrator (ODI) Integration Interface executed as a Scenario from the startscen.bat (.sh) script:

0 : 08001 : java.sql.SQLException: Cannot load connection class because of underlying exception:
'java.sql.SQLException: No DTD found and no XML file provided: the XML schema cannot be created'.


However, when the same Scenario is launched from ODI Designer / ODI Studio > Designer navigator, no problems are encountered.

Example of JNDI URL is as follows:

ormi://<HOST>:<PORT>?d=../demo/<USER>/<XSD_FILE>.xsd&re=<ROOT_ELEMENT>&s=<SCHEMA_NAME>&JMS_DESTINATION=jms/demoQueue

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
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.