Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-5761

ConvertVDB incorrectly converts older style chained imports

XMLWordPrintable

    • Icon: Quality Risk Quality Risk
    • Resolution: Done
    • Icon: Major Major
    • 12.3
    • None
    • Tooling
    • None

      <vdb name="{vdb-name}" version="1">
          <model name="{model-name}" type="PHYSICAL">
              <source name="AccountsDB" translator-name="oracle" connection-jndi-name="java:/oracleDS"/>
              <metadata type="NATIVE,DDL"><![CDATA[
                 CREATE FOREIGN FUNCTION SCORE (val integer) RETURNS integer;
               ]]>
              </metadata>
          </model>
      </vdb>
      

      Results in:

      CREATE DATABASE "{vdb-name}" VERSION '1';
      USE DATABASE "{vdb-name}" VERSION '1';
      
      --############ Translators ############
      CREATE FOREIGN DATA WRAPPER oracle;
      
      --############ Servers ############
      CREATE SERVER AccountsDB FOREIGN DATA WRAPPER oracle OPTIONS ("jndi-name" 'java:/oracleDS');
      
      --############ Schemas ############
      CREATE SCHEMA "{model-name}" SERVER AccountsDB;
      
      
      --############ Schema:{model-name} ############
      SET SCHEMA "{model-name}";
      
      IMPORT FROM REPOSITORY "NATIVE,DDL" INTO "{model-name}";
      

              rhn-engineering-shawkins Steven Hawkins
              rhn-engineering-shawkins Steven Hawkins
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: