[JBoss JIRA] (TEIIDDES-2982) Missing Table settings in dynamic VDB
by Mario Majernik (JIRA)
Mario Majernik created TEIIDDES-2982:
----------------------------------------
Summary: Missing Table settings in dynamic VDB
Key: TEIIDDES-2982
URL: https://issues.jboss.org/browse/TEIIDDES-2982
Project: Teiid Designer
Issue Type: Bug
Components: Dynamic VDBs, Import/Export
Affects Versions: 10.0.2
Reporter: Mario Majernik
Attachments: DynamicVDBtesting.zip
There are missing Table setiings in dynamic vdb:
* System(Is System Table checkbox in table dialog) column is always false.(No mention in dynamicVDB)
* Name In Source and Description is empty in PrimaryKeys tab and Unique Constraint tab.(No mention in dynamic VDB)
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 11 months
[JBoss JIRA] (TEIIDDES-2981) Missing Table settings in dynamic VDB
by Mario Majernik (JIRA)
Mario Majernik created TEIIDDES-2981:
----------------------------------------
Summary: Missing Table settings in dynamic VDB
Key: TEIIDDES-2981
URL: https://issues.jboss.org/browse/TEIIDDES-2981
Project: Teiid Designer
Issue Type: Bug
Components: Dynamic VDBs, Import/Export
Affects Versions: 10.0.2
Reporter: Mario Majernik
There are missing Table setiings in dynamic vdb:* System(Is System Table checkbox in table dialog) column is always false.(No mention in dynamicVDB)* Name In Source and Description is empty in PrimaryKeys tab and Unique Constraint tab.(No mention in dynamic VDB)
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 11 months
[JBoss JIRA] (TEIIDDES-2980) When Clear Materialization is selected, not clearing the extension properties
by Van Halbert (JIRA)
Van Halbert created TEIIDDES-2980:
-------------------------------------
Summary: When Clear Materialization is selected, not clearing the extension properties
Key: TEIIDDES-2980
URL: https://issues.jboss.org/browse/TEIIDDES-2980
Project: Teiid Designer
Issue Type: Bug
Components: Modeling
Affects Versions: 10.0.3
Reporter: Van Halbert
Priority: Optional
When the Clear Materialize option is selected, the view extension properties are not being reset to their default value. And so, when the subsequent Materialize is done, and a different name is used for the source model, the extension properties no longer match.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 11 months
[JBoss JIRA] (TEIIDDES-2979) View table is interpreted as Table in dynamic VDB
by Mario Majernik (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2979?page=com.atlassian.jira.plu... ]
Mario Majernik updated TEIIDDES-2979:
-------------------------------------
Description:
View table is interpreted in dynamic VDB as Table
This is example from dynamic vdb:
{{CREATE FOREIGN {color:red}TABLE{color} ViewTable (
newColumn_1 string(4000)
) OPTIONS(NAMEINSOURCE 'ViewTableNameInSource', UPDATABLE 'TRUE')}}
Should be there VIEW instead TABLE.
So when I try generate source model from dynamic VDB I get Table no View Table
was:
View table is interpreted in dynamic VDB as Table
This is example from dynamic vdb:
_CREATE FOREIGN {color:red}TABLE{color} ViewTable (
newColumn_1 string(4000)
) OPTIONS(NAMEINSOURCE 'ViewTableNameInSource', UPDATABLE 'TRUE')_
Should be there VIEW instead TABLE.
So when I try generate source model from dynamic VDB I get Table no View Table
> View table is interpreted as Table in dynamic VDB
> -------------------------------------------------
>
> Key: TEIIDDES-2979
> URL: https://issues.jboss.org/browse/TEIIDDES-2979
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dynamic VDBs
> Affects Versions: 10.0.2
> Reporter: Mario Majernik
>
> View table is interpreted in dynamic VDB as Table
> This is example from dynamic vdb:
> {{CREATE FOREIGN {color:red}TABLE{color} ViewTable (
> newColumn_1 string(4000)
> ) OPTIONS(NAMEINSOURCE 'ViewTableNameInSource', UPDATABLE 'TRUE')}}
> Should be there VIEW instead TABLE.
> So when I try generate source model from dynamic VDB I get Table no View Table
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 11 months
[JBoss JIRA] (TEIIDDES-2979) View table is interpreted as Table in dynamic VDB
by Mario Majernik (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2979?page=com.atlassian.jira.plu... ]
Mario Majernik updated TEIIDDES-2979:
-------------------------------------
Description:
View table is interpreted in dynamic VDB as Table
This is example from dynamic vdb:
CREATE FOREIGN {color:red}TABLE{color} ViewTable (
newColumn_1 string(4000)
) OPTIONS(NAMEINSOURCE 'ViewTableNameInSource', UPDATABLE 'TRUE')
Should be there VIEW instead TABLE.
So when I try generate source model from dynamic VDB I get Table no View Table
was:
View table is interpreted in dynamic VDB as Table
This is example from dynamic vdb:
{{CREATE FOREIGN {color:red}TABLE{color} ViewTable (
newColumn_1 string(4000)
) OPTIONS(NAMEINSOURCE 'ViewTableNameInSource', UPDATABLE 'TRUE')}}
Should be there VIEW instead TABLE.
So when I try generate source model from dynamic VDB I get Table no View Table
> View table is interpreted as Table in dynamic VDB
> -------------------------------------------------
>
> Key: TEIIDDES-2979
> URL: https://issues.jboss.org/browse/TEIIDDES-2979
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dynamic VDBs
> Affects Versions: 10.0.2
> Reporter: Mario Majernik
>
> View table is interpreted in dynamic VDB as Table
> This is example from dynamic vdb:
> CREATE FOREIGN {color:red}TABLE{color} ViewTable (
> newColumn_1 string(4000)
> ) OPTIONS(NAMEINSOURCE 'ViewTableNameInSource', UPDATABLE 'TRUE')
> Should be there VIEW instead TABLE.
> So when I try generate source model from dynamic VDB I get Table no View Table
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 11 months
[JBoss JIRA] (TEIIDDES-2979) View table is interpreted as Table in dynamic VDB
by Mario Majernik (JIRA)
Mario Majernik created TEIIDDES-2979:
----------------------------------------
Summary: View table is interpreted as Table in dynamic VDB
Key: TEIIDDES-2979
URL: https://issues.jboss.org/browse/TEIIDDES-2979
Project: Teiid Designer
Issue Type: Bug
Components: Dynamic VDBs
Affects Versions: 10.0.2
Reporter: Mario Majernik
View table is interpreted in dynamic VDB as Table
This is example from dynamic vdb:
_CREATE FOREIGN {color:red}TABLE{color} ViewTable (
newColumn_1 string(4000)
) OPTIONS(NAMEINSOURCE 'ViewTableNameInSource', UPDATABLE 'TRUE')_
Should be there VIEW instead TABLE.
So when I try generate source model from dynamic VDB I get Table no View Table
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 11 months
[JBoss JIRA] (TEIIDDES-2975) Teiid cannot generate VDB Arcive and Models because of error
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2975?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2975:
----------------------------------------
[~mmajerni] Yep.. I found one issue that result set column options were being added twice. I also fixed in TEIIDDES-2942 the extra "result" being added to the parameter string per the logic below
* The exporter will treat OUT's as straight OUT parameters and if a RETURN parameter exists,
* Then it'll be treated as an OUT parameter with a *result* added.
> Teiid cannot generate VDB Arcive and Models because of error
> ------------------------------------------------------------
>
> Key: TEIIDDES-2975
> URL: https://issues.jboss.org/browse/TEIIDDES-2975
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dynamic VDBs, Import/Export
> Affects Versions: 10.0.2
> Reporter: Mario Majernik
> Attachments: OtherStaticVDBsettings.zip, Screen1.png, VDBwithOnlySourceModel-vdb.xml
>
>
> When I created dynamic vdb there was no error that Procedure or Source model or static VDB was corrupted. Then I tried generate back static vdb and source model. The following error shows (Screen1)
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 11 months
[JBoss JIRA] (TEIIDDES-2975) Teiid cannot generate VDB Arcive and Models because of error
by Mario Majernik (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2975?page=com.atlassian.jira.plu... ]
Mario Majernik commented on TEIIDDES-2975:
------------------------------------------
[^OtherStaticVDBsettings.zip]
[~blafond] here it is.
I think that problem is in dynamic vdb generator. Some things with Procedure ResultSet(I think) do not set properly.
> Teiid cannot generate VDB Arcive and Models because of error
> ------------------------------------------------------------
>
> Key: TEIIDDES-2975
> URL: https://issues.jboss.org/browse/TEIIDDES-2975
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dynamic VDBs, Import/Export
> Affects Versions: 10.0.2
> Reporter: Mario Majernik
> Attachments: OtherStaticVDBsettings.zip, Screen1.png, VDBwithOnlySourceModel-vdb.xml
>
>
> When I created dynamic vdb there was no error that Procedure or Source model or static VDB was corrupted. Then I tried generate back static vdb and source model. The following error shows (Screen1)
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 11 months
[JBoss JIRA] (TEIIDDES-2978) In the materialize wizard, split out the cacheTypeMap
by Van Halbert (JIRA)
Van Halbert created TEIIDDES-2978:
-------------------------------------
Summary: In the materialize wizard, split out the cacheTypeMap
Key: TEIIDDES-2978
URL: https://issues.jboss.org/browse/TEIIDDES-2978
Project: Teiid Designer
Issue Type: Enhancement
Components: Modeling, Usability
Affects Versions: 10.0.3
Reporter: Van Halbert
Priority: Optional
- change the cacheTypeMap to be split out into 3 separate text boxes for the user (cache name, class name, primary key)
a. the primary key from the view (if it exists) can be use to set the default for the primary key
b. the class name can be defaulted to what the pojo class to be created
c. The user then only needs to enter the cache name
All three must be entered to complete process
under the covers, the property will be assembled: cacheName + ":" + classname + ":" + primarykey
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 11 months