5 Replies Latest reply on Jun 23, 2017 7:18 AM by Ramesh Reddy

    error about the vdb.xml

    cute u Newbie

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