1 of 1 people found this helpful
Edit the vdb.xml file and redeploy the file. You have to undeploy the previous one first.
what means undeploy the previous one first,and how to edit vdb.xml,i can't find error in the file.
The error is saying that there is an error in your DDL that you defined in the VDB. Then you need to fix that. for complete DDL syntax see . I think you are missing keyword "FOREIGN" in your table definition.
CREATE FOREIGN TABLE A1_GEOL_DESIGN_FILE(
And make sure you have the "A1_GEOL_DESIGN_FILE" in the Oracle database defined.
my sql is run in oracle is ok,but in teiid has error
is the DDL syntax is common,or is only for teiid
Teiid DDL is little different from standard DDL, since it deals with multiple stores Teiid uses SQL-MED based DDL with few custom extensions.