'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 08, 2017

Applies to:

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

Symptoms

 ODI 10g

When either :

  1. testing the connection to an XML Technology Data Server in ODI Topology Manager > Physical Architecture
  2. reverse engineering ODI Models from XML DTDs or XSDs 
  3. or generating an XML file from a DTD (or XSD) provided:

the following message may be signaled although XML instances of the DTD (or XSD) are well-formed and valid :

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

 

ODI 11g

In ODI 11g the error message has changed.

For example, in the case of an XSD file that contains an element called ORDERS, it fails with :

com.sunopsis.tools.core.exception.SnpsSimpleMessageException: Reverse table ORDERS for model TEST_XML already exists.
at com.sunopsis.dwg.reverse.Reverse.getMetaData(Reverse.java:1204)
at com.sunopsis.dwg.reverse.Reverse.getMetaData(Reverse.java:1569)
at com.sunopsis.graphical.frame.edit.EditFrameSnpModel$7.doInBackground(EditFrameSnpModel.java:2566)
at com.sunopsis.graphical.tools.utils.swingworker.SwingWorker$1.call(SwingWorker.java:240)


Please consult : http://hsqldb.org/doc/guide/lists-app.html

Appendix A. Lists of Keywords
...
List of SQL Keywords Disallowed as HyperSQL Identifiers

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