error about the vdb.xml

[uuliver]

<?xml version="1.0" ?><vdb name="ln622" version="1">

<description>VDB for: ln622, Version: 1</description>

<connection-type>BY_VERSION</connection-type>

<model name="bln" type="PHYSICAL" visible="true">

<source name="test" translator-name="oracle" connection-jndi-name="java:/OracleGeol"></source>

<metadata type="DDL"><![CDATA[CREATE TABLE A1_GEOL_DESIGN_FILE(LOGIC_ID VARCHAR2,DESIGN_ID VARCHAR2,CREATE_DATE  DATE);]]></metadata>

</model>

</vdb>

the ddl run in oracle is ok,but run in teiid service has error,org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "CREATE [*]TABLE[*] A1_GEOL_DESIGN_FILE(" at line 1, column 9. Was expecting: "foreign" | "function" | "global" | "procedure" | "trigger" | "virtual" | "view"

how can i update the ddl

[rareddy]

Edit the vdb.xml file and redeploy the file. You have to undeploy the previous one first.

[uuliver]

what means undeploy the previous one first,and how to edit vdb.xml,i can't find error in the file.

[rareddy]

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 [1]. I think you are missing keyword "FOREIGN" in your table definition.

CREATE FOREIGN TABLE A1_GEOL_DESIGN_FILE(

     LOGIC_ID VARCHAR2,

     DESIGN_ID VARCHAR2,

     CREATE_DATE  DATE

);

And make sure you have the "A1_GEOL_DESIGN_FILE" in the Oracle database defined.

[1] Schema Object DDL · Teiid Documentation

[uuliver]

my sql is run in oracle is ok,but in teiid has error

is the DDL syntax is common,or is only for teiid

[rareddy]

Teiid DDL is little different from standard DDL, since it deals with multiple stores Teiid uses SQL-MED based DDL with few custom extensions.