My Oracle Support Banner

'Unexpected token in statement...' Or 'Reverse table ... for model ... already exists' Message When Testing The Connection To An XML File With The ODI XML Driver (Doc ID 423870.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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


Although XML instances of the DTD (or XSD) are well-formed and valid, the following message is received when using Oracle Data Integrator (ODI) and either:

0 : null : java.sql.SQLException: ... a class java.sql.SQLException occurred and said: java.sql.SQLException: java.sql.SQLException: Unexpected token in statement [select ...

   == or == (in the case of an XSD file that contains an element called ORDERS) Reverse table ORDERS for model TEST_XML already exists.
  at com.sunopsis.dwg.reverse.Reverse.getMetaData(
  at com.sunopsis.dwg.reverse.Reverse.getMetaData(
  at com.sunopsis.graphical.frame.edit.EditFrameSnpModel$7.doInBackground(


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
 Specific case

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