[JBoss JIRA] (TEIIDDES-2624) When importing via Teiid Connection, no way to set(change) the global tables updateable OPTION
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2624?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2624:
----------------------------------------
I think we could easily toggle the default relational table EMF property too via RelationalPackageImpl, but we'd be changing the default behavior that's been around for 13 years. Maybe it's best if we do?
{code}
initEAttribute(getTable_SupportsUpdate(), ecorePackage.getEBoolean(), "supportsUpdate", "true", 0, 1, Table.class, !IS_TRANSIENT, !IS_VOLATILE, IS_CHANGEABLE, !IS_UNSETTABLE, !IS_ID, IS_UNIQUE, !IS_DERIVED, IS_ORDERED); //$NON-NLS-1$ //$NON-NLS-2$
{code}
> When importing via Teiid Connection, no way to set(change) the global tables updateable OPTION
> ----------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2624
> URL: https://issues.jboss.org/browse/TEIIDDES-2624
> Project: Teiid Designer
> Issue Type: Enhancement
> Components: Import/Export
> Reporter: Van Halbert
> Assignee: Mark Drilling
> Fix For: 9.0.4, 9.2
>
>
> When using Teiid Connection importer, need the ability to change the default table updatable flag. The default is "true". Would like to be able to override that with "false" for the imported DDL
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 10 months
[JBoss JIRA] (TEIIDDES-2624) When importing via Teiid Connection, no way to set(change) the global tables updateable OPTION
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2624?page=com.atlassian.jira.plu... ]
Van Halbert edited comment on TEIIDDES-2624 at 9/4/15 3:30 PM:
---------------------------------------------------------------
There's 2 reasons -
1) Our recommended approach to designing VDB's is to do the following:
- create source model
- create base layer views (1-to-1) for adaptability
- then create object layer(s) and/or abstraction layer
The source model, in most cases, will be not updatable. It will not be thru (directly accessed) which updates are performed.
2) when importing large number of tables, this becomes a usability issue of going thru every table.
was (Author: van.halbert):
There's 2 reasons -
1) Our recommended approach to designing VDB's is to do the following:
- create source model
- create base layer views (1-to-1) for adaptability
- then create object layer(s) and/or abstraction layer
The source model, in most cases, will be not updatable. It will not be thru which updates are performed.
2) when importing large number of tables, this becomes a usability issue of going thru every table.
> When importing via Teiid Connection, no way to set(change) the global tables updateable OPTION
> ----------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2624
> URL: https://issues.jboss.org/browse/TEIIDDES-2624
> Project: Teiid Designer
> Issue Type: Enhancement
> Components: Import/Export
> Reporter: Van Halbert
> Assignee: Mark Drilling
> Fix For: 9.0.4, 9.2
>
>
> When using Teiid Connection importer, need the ability to change the default table updatable flag. The default is "true". Would like to be able to override that with "false" for the imported DDL
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 10 months
[JBoss JIRA] (TEIIDDES-2624) When importing via Teiid Connection, no way to set(change) the global tables updateable OPTION
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2624?page=com.atlassian.jira.plu... ]
Van Halbert commented on TEIIDDES-2624:
---------------------------------------
There's 2 reasons -
1) Our recommended approach to designing VDB's is to do the following:
- create source model
- create base layer views (1-to-1) for adaptability
- then create object layer(s) and/or abstraction layer
The source model, in most cases, will be not updatable. It will not be thru which updates are performed.
2) when importing large number of tables, this becomes a usability issue of going thru every table.
> When importing via Teiid Connection, no way to set(change) the global tables updateable OPTION
> ----------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2624
> URL: https://issues.jboss.org/browse/TEIIDDES-2624
> Project: Teiid Designer
> Issue Type: Enhancement
> Components: Import/Export
> Reporter: Van Halbert
> Assignee: Mark Drilling
> Fix For: 9.0.4, 9.2
>
>
> When using Teiid Connection importer, need the ability to change the default table updatable flag. The default is "true". Would like to be able to override that with "false" for the imported DDL
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 10 months
[JBoss JIRA] (TEIIDDES-2624) When importing via Teiid Connection, no way to set(change) the global tables updateable OPTION
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2624?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2624:
----------------------------------------
Designer currently doesn't have a model-level flag in any importer that will globally set a Table OPTION( UPDATEABLE, "FALSE") during the import. It hasn't come up until now.
Updating the metadata in a model is common (JDBC, Teiid Connection, DDL) but that's not the same as controlling whether or not the actual source data is updatable or not. It's 2 different concepts.
> When importing via Teiid Connection, no way to set(change) the global tables updateable OPTION
> ----------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2624
> URL: https://issues.jboss.org/browse/TEIIDDES-2624
> Project: Teiid Designer
> Issue Type: Enhancement
> Components: Import/Export
> Reporter: Van Halbert
> Assignee: Mark Drilling
> Fix For: 9.0.4, 9.2
>
>
> When using Teiid Connection importer, need the ability to change the default table updatable flag. The default is "true". Would like to be able to override that with "false" for the imported DDL
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 10 months
[JBoss JIRA] (TEIIDDES-2624) When importing via Teiid Connection, no way to set(change) the global tables updateable OPTION
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2624?page=com.atlassian.jira.plu... ]
Ramesh Reddy commented on TEIIDDES-2624:
----------------------------------------
[~blafond] How is this done in JDBC Importer? Can somebody set this preference import wide?
[~vhalbert] What is need driving this? I believe this default behavior across all the translator importers, and what I know importers in the Designers to date. Typically user if he does not want to update, sets the update flag to false.
> When importing via Teiid Connection, no way to set(change) the global tables updateable OPTION
> ----------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2624
> URL: https://issues.jboss.org/browse/TEIIDDES-2624
> Project: Teiid Designer
> Issue Type: Enhancement
> Components: Import/Export
> Reporter: Van Halbert
> Assignee: Mark Drilling
> Fix For: 9.0.4, 9.2
>
>
> When using Teiid Connection importer, need the ability to change the default table updatable flag. The default is "true". Would like to be able to override that with "false" for the imported DDL
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 10 months
[JBoss JIRA] (TEIIDDES-2624) When importing via Teiid Connection, no way to set(change) the global tables updateable OPTION
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2624?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2624:
-----------------------------------
Description: When using Teiid Connection importer, need the ability to change the default table updatable flag. The default is "true". Would like to be able to override that with "false" for the imported DDL (was: When using Teiid Connection importer, need the ability to change the default model updatable flag. The default is "true". Would like to be able to change to "false".)
> When importing via Teiid Connection, no way to set(change) the global tables updateable OPTION
> ----------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2624
> URL: https://issues.jboss.org/browse/TEIIDDES-2624
> Project: Teiid Designer
> Issue Type: Enhancement
> Components: Import/Export
> Reporter: Van Halbert
> Assignee: Mark Drilling
> Fix For: 9.0.4, 9.2
>
>
> When using Teiid Connection importer, need the ability to change the default table updatable flag. The default is "true". Would like to be able to override that with "false" for the imported DDL
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 10 months