[JBoss JIRA] (TEIIDDES-2828) VDBs, created with Teiid Designer that import other VDB do not respect the specified version.
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2828?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2828:
----------------------------------------
Importing Models from a deployed VDB via JDBC does not provide the ability to discover the VDB version from the JDBC metadata.
Since the JDBC importer *is* aware that the source is a VDB, we could provide a text entry field to allow users to set the version, which would be stored in the model along with the "import-vdb" name. Then on *preview*, we would set the proper VDB version number.
> VDBs, created with Teiid Designer that import other VDB do not respect the specified version.
> ---------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2828
> URL: https://issues.jboss.org/browse/TEIIDDES-2828
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 9.0.6
> Reporter: Colin Mondesir
> Assignee: Barry LaFond
> Fix For: 10.0.2
>
>
> When using:
> project -> Import...
> JDBC Database >> Source Model,
> Despite including the URL property VirtualDatabaseVersion=2 during the import process the version of the imported vdb I see when I create a deployable vdb archive is given as "1":
> ...
> <import-vdb name="fileData" version="1" import-data-policies="false"/>
> As an alternative I have tried setting the "version" property given here:
> https://access.redhat.com/documentation/en-US/Red_Hat_JBoss_Data_Virtuali...
> But saw the same results the version of my imported VDB always seems to be "1"
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months
[JBoss JIRA] (TEIIDDES-2832) Unable to preview imported SF model
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2832?page=com.atlassian.jira.plu... ]
Barry LaFond resolved TEIIDDES-2832.
------------------------------------
Resolution: Done
https://github.com/Teiid-Designer/teiid-designer/commit/bbd599e81dd083542...
> Unable to preview imported SF model
> -----------------------------------
>
> Key: TEIIDDES-2832
> URL: https://issues.jboss.org/browse/TEIIDDES-2832
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dynamic VDBs
> Affects Versions: 10.0
> Reporter: Mark Drilling
> Assignee: Barry LaFond
> Fix For: 10.0.1
>
> Attachments: server.log
>
>
> Import from salesforce using SF importer, then attempt to preview Account table, results in the attached server.log exception.
> The dynamic VDB content:
> <vdb name="PREVIEW-f118338c-1837-4973-ae81-61092ac55eb9" version="1">
> <description>Importer VDB</description>
> <property name="UseConnectorMetadata" value="true" />
> <property name="deployment-name" value="PREVIEW-f118338c-1837-4973-ae81-61092ac55eb9-vdb.xml" />
> <model name="SFModel" type="PHYSICAL" visible="true">
> <source name="SFModel" translator-name="salesforce" connection-jndi-name="null" />
> <metadata type="DDL"><![CDATA[
> CREATE FOREIGN TABLE Account (
> Id string(18) NOT NULL OPTIONS(NAMEINSOURCE 'Id', NATIVE_TYPE 'id', "teiid_sf:Defaulted on Create" 'TRUE'),
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months
[JBoss JIRA] (TEIIDDES-2832) Unable to preview imported SF model
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2832?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2832:
----------------------------------------
The preview data features has changed under the hood and affected all the importers. retargeting 10.0.1 to finish the feature
> Unable to preview imported SF model
> -----------------------------------
>
> Key: TEIIDDES-2832
> URL: https://issues.jboss.org/browse/TEIIDDES-2832
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dynamic VDBs
> Affects Versions: 10.0
> Reporter: Mark Drilling
> Assignee: Barry LaFond
> Fix For: 10.0.1
>
> Attachments: server.log
>
>
> Import from salesforce using SF importer, then attempt to preview Account table, results in the attached server.log exception.
> The dynamic VDB content:
> <vdb name="PREVIEW-f118338c-1837-4973-ae81-61092ac55eb9" version="1">
> <description>Importer VDB</description>
> <property name="UseConnectorMetadata" value="true" />
> <property name="deployment-name" value="PREVIEW-f118338c-1837-4973-ae81-61092ac55eb9-vdb.xml" />
> <model name="SFModel" type="PHYSICAL" visible="true">
> <source name="SFModel" translator-name="salesforce" connection-jndi-name="null" />
> <metadata type="DDL"><![CDATA[
> CREATE FOREIGN TABLE Account (
> Id string(18) NOT NULL OPTIONS(NAMEINSOURCE 'Id', NATIVE_TYPE 'id', "teiid_sf:Defaulted on Create" 'TRUE'),
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months
[JBoss JIRA] (TEIIDDES-2832) Unable to preview imported SF model
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2832?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2832:
-----------------------------------
Summary: Unable to preview imported SF model (was: Unable to preview - connection-jndi-name is null in dynamic vdb)
> Unable to preview imported SF model
> -----------------------------------
>
> Key: TEIIDDES-2832
> URL: https://issues.jboss.org/browse/TEIIDDES-2832
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dynamic VDBs
> Affects Versions: 10.0
> Reporter: Mark Drilling
> Assignee: Barry LaFond
> Fix For: 10.0.1
>
> Attachments: server.log
>
>
> Import from salesforce using SF importer, then attempt to preview Account table, results in the attached server.log exception.
> The dynamic VDB content:
> <vdb name="PREVIEW-f118338c-1837-4973-ae81-61092ac55eb9" version="1">
> <description>Importer VDB</description>
> <property name="UseConnectorMetadata" value="true" />
> <property name="deployment-name" value="PREVIEW-f118338c-1837-4973-ae81-61092ac55eb9-vdb.xml" />
> <model name="SFModel" type="PHYSICAL" visible="true">
> <source name="SFModel" translator-name="salesforce" connection-jndi-name="null" />
> <metadata type="DDL"><![CDATA[
> CREATE FOREIGN TABLE Account (
> Id string(18) NOT NULL OPTIONS(NAMEINSOURCE 'Id', NATIVE_TYPE 'id', "teiid_sf:Defaulted on Create" 'TRUE'),
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months
[JBoss JIRA] (TEIIDDES-2832) Unable to preview imported SF model
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2832?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2832:
-----------------------------------
Fix Version/s: 10.0.1
(was: 10.0.2)
> Unable to preview imported SF model
> -----------------------------------
>
> Key: TEIIDDES-2832
> URL: https://issues.jboss.org/browse/TEIIDDES-2832
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dynamic VDBs
> Affects Versions: 10.0
> Reporter: Mark Drilling
> Assignee: Barry LaFond
> Fix For: 10.0.1
>
> Attachments: server.log
>
>
> Import from salesforce using SF importer, then attempt to preview Account table, results in the attached server.log exception.
> The dynamic VDB content:
> <vdb name="PREVIEW-f118338c-1837-4973-ae81-61092ac55eb9" version="1">
> <description>Importer VDB</description>
> <property name="UseConnectorMetadata" value="true" />
> <property name="deployment-name" value="PREVIEW-f118338c-1837-4973-ae81-61092ac55eb9-vdb.xml" />
> <model name="SFModel" type="PHYSICAL" visible="true">
> <source name="SFModel" translator-name="salesforce" connection-jndi-name="null" />
> <metadata type="DDL"><![CDATA[
> CREATE FOREIGN TABLE Account (
> Id string(18) NOT NULL OPTIONS(NAMEINSOURCE 'Id', NATIVE_TYPE 'id', "teiid_sf:Defaulted on Create" 'TRUE'),
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months
[JBoss JIRA] (TEIIDDES-2832) Unable to preview imported SF model
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2832?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2832:
-----------------------------------
Affects Version/s: 10.0
(was: 10.0.2)
> Unable to preview imported SF model
> -----------------------------------
>
> Key: TEIIDDES-2832
> URL: https://issues.jboss.org/browse/TEIIDDES-2832
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dynamic VDBs
> Affects Versions: 10.0
> Reporter: Mark Drilling
> Assignee: Barry LaFond
> Fix For: 10.0.1
>
> Attachments: server.log
>
>
> Import from salesforce using SF importer, then attempt to preview Account table, results in the attached server.log exception.
> The dynamic VDB content:
> <vdb name="PREVIEW-f118338c-1837-4973-ae81-61092ac55eb9" version="1">
> <description>Importer VDB</description>
> <property name="UseConnectorMetadata" value="true" />
> <property name="deployment-name" value="PREVIEW-f118338c-1837-4973-ae81-61092ac55eb9-vdb.xml" />
> <model name="SFModel" type="PHYSICAL" visible="true">
> <source name="SFModel" translator-name="salesforce" connection-jndi-name="null" />
> <metadata type="DDL"><![CDATA[
> CREATE FOREIGN TABLE Account (
> Id string(18) NOT NULL OPTIONS(NAMEINSOURCE 'Id', NATIVE_TYPE 'id', "teiid_sf:Defaulted on Create" 'TRUE'),
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months