[JBoss JIRA] Created: (TEIIDDES-968) Catalog and Schema should use different icons so that they can be distinquished as to their type
9:55 p.m.
Catalog and Schema should use different icons so that they can be distinquished as to
their type
------------------------------------------------------------------------------------------------
Key: TEIIDDES-968
URL: https://issues.jboss.org/browse/TEIIDDES-968
Project: Teiid Designer
Issue Type: Enhancement
Components: Modeling
Affects Versions: 7.1.1
Reporter: Van Halbert
Priority: Minor
The catalog and schema should use different icons so that they can be distinguishable in
the tree. The mouse-over type would also be helpful.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:10 p.m.
New subject: [JBoss JIRA] Commented: (TEIIDDES-968) Catalog and Schema should use different icons so that they can be distinquished as to their type
[
https://issues.jboss.org/browse/TEIIDDES-968?page=com.atlassian.jira.plug...
]
Steven Hawkins commented on TEIIDDES-968:
-----------------------------------------
it would be nice to remove the designer schema/catalog concepts altogether as they have no
real runtime representation - they simply become part of the table name. This would also
remove potential name ambiguities due to how child catalogs/schemas can be added in the
relational model.
The only usefulness of these constructs is in having designer attempt to represent the
exact form of the source metadata.
Catalog and Schema should use different icons so that they can be
distinquished as to their type
------------------------------------------------------------------------------------------------
Key: TEIIDDES-968
URL: https://issues.jboss.org/browse/TEIIDDES-968
Project: Teiid Designer
Issue Type: Enhancement
Components: Modeling
Affects Versions: 7.1.1
Reporter: Van Halbert
Priority: Minor
The catalog and schema should use different icons so that they can be distinguishable in
the tree. The mouse-over type would also be helpful.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:16 p.m.
New subject: [JBoss JIRA] Commented: (TEIIDDES-968) Catalog and Schema should use different icons so that they can be distinquished as to their type
[
https://issues.jboss.org/browse/TEIIDDES-968?page=com.atlassian.jira.plug...
]
Van Halbert commented on TEIIDDES-968:
--------------------------------------
Are schema/catalog not used in DatabaseMetaData? Asking for specific tables in a
specified schema.
Catalog and Schema should use different icons so that they can be
distinquished as to their type
------------------------------------------------------------------------------------------------
Key: TEIIDDES-968
URL: https://issues.jboss.org/browse/TEIIDDES-968
Project: Teiid Designer
Issue Type: Enhancement
Components: Modeling
Affects Versions: 7.1.1
Reporter: Van Halbert
Priority: Minor
The catalog and schema should use different icons so that they can be distinguishable in
the tree. The mouse-over type would also be helpful.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:29 p.m.
New subject: [JBoss JIRA] Commented: (TEIIDDES-968) Catalog and Schema should use different icons so that they can be distinquished as to their type
[
https://issues.jboss.org/browse/TEIIDDES-968?page=com.atlassian.jira.plug...
]
Steven Hawkins commented on TEIIDDES-968:
-----------------------------------------
This is a key divergence between a source level view of metadata and a runtime view of
metadata. Teiid Designer is somewhere in the middle of the two.
At runtime the Teiid catalog is always the vdb name and the schema is the model name. Any
design time catalog/schema contained in the model is simply squashed into the table name
of its children.
Catalog and Schema should use different icons so that they can be
distinquished as to their type
------------------------------------------------------------------------------------------------
Key: TEIIDDES-968
URL: https://issues.jboss.org/browse/TEIIDDES-968
Project: Teiid Designer
Issue Type: Enhancement
Components: Modeling
Affects Versions: 7.1.1
Reporter: Van Halbert
Priority: Minor
The catalog and schema should use different icons so that they can be distinguishable in
the tree. The mouse-over type would also be helpful.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
2:54 a.m.
New subject: [JBoss JIRA] Commented: (TEIIDDES-968) Catalog and Schema should use different icons so that they can be distinquished as to their type
[
https://issues.jboss.org/browse/TEIIDDES-968?page=com.atlassian.jira.plug...
]
Ramesh Reddy commented on TEIIDDES-968:
---------------------------------------
+1 for getting rid of it, then use the NameInSource for the source models to define the
schema and catalog information.
Catalog and Schema should use different icons so that they can be
distinquished as to their type
------------------------------------------------------------------------------------------------
Key: TEIIDDES-968
URL: https://issues.jboss.org/browse/TEIIDDES-968
Project: Teiid Designer
Issue Type: Enhancement
Components: Modeling
Affects Versions: 7.1.1
Reporter: Van Halbert
Priority: Minor
The catalog and schema should use different icons so that they can be distinguishable in
the tree. The mouse-over type would also be helpful.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:19 p.m.
New subject: [JBoss JIRA] Assigned: (TEIIDDES-968) Catalog and Schema should use different icons so that they can be distinquished as to their type
[
https://issues.jboss.org/browse/TEIIDDES-968?page=com.atlassian.jira.plug...
]
Barry LaFond reassigned TEIIDDES-968:
-------------------------------------
Assignee: Barry LaFond
Catalog and Schema should use different icons so that they can be
distinquished as to their type
------------------------------------------------------------------------------------------------
Key: TEIIDDES-968
URL: https://issues.jboss.org/browse/TEIIDDES-968
Project: Teiid Designer
Issue Type: Enhancement
Components: Modeling
Affects Versions: 7.1.1
Reporter: Van Halbert
Assignee: Barry LaFond
Priority: Minor
Fix For: 7.5
The catalog and schema should use different icons so that they can be distinguishable in
the tree. The mouse-over type would also be helpful.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:28 p.m.
New subject: [JBoss JIRA] Commented: (TEIIDDES-968) Catalog and Schema should use different icons so that they can be distinquished as to their type
[
https://issues.jboss.org/browse/TEIIDDES-968?page=com.atlassian.jira.plug...
]
Barry LaFond commented on TEIIDDES-968:
---------------------------------------
So 2 possible directions.
1) create 2 different icons
or
2) remove the Catalog/Schema as objects a user can create.
- Remove the options from the New Child/New Sibling contributions
- Remove the options from the JDBC Import wizard and assume they are "unchecked
always"
- Add the schema/catalog names to the nameInSource property on import
Catalog and Schema should use different icons so that they can be
distinquished as to their type
------------------------------------------------------------------------------------------------
Key: TEIIDDES-968
URL: https://issues.jboss.org/browse/TEIIDDES-968
Project: Teiid Designer
Issue Type: Enhancement
Components: Modeling
Affects Versions: 7.1.1
Reporter: Van Halbert
Assignee: Barry LaFond
Priority: Minor
Fix For: 7.5
The catalog and schema should use different icons so that they can be distinguishable in
the tree. The mouse-over type would also be helpful.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:37 p.m.
New subject: [JBoss JIRA] Commented: (TEIIDDES-968) Catalog and Schema should use different icons so that they can be distinquished as to their type
[
https://issues.jboss.org/browse/TEIIDDES-968?page=com.atlassian.jira.plug...
]
Steven Hawkins commented on TEIIDDES-968:
-----------------------------------------
The importer logic already covers adding catalog/schema to the nameInSource. The
difference in not utilizing the metadata entries would be in the naming of the
tables/procedures. Now that Designer allows it, it's fine to set the metadata name of
a table to something like catalog.schema.table rather than creating the catalog and schema
metamodel entries.
Catalog and Schema should use different icons so that they can be
distinquished as to their type
------------------------------------------------------------------------------------------------
Key: TEIIDDES-968
URL: https://issues.jboss.org/browse/TEIIDDES-968
Project: Teiid Designer
Issue Type: Enhancement
Components: Modeling
Affects Versions: 7.1.1
Reporter: Van Halbert
Assignee: Barry LaFond
Priority: Minor
Fix For: 7.5
The catalog and schema should use different icons so that they can be distinguishable in
the tree. The mouse-over type would also be helpful.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:29 p.m.
New subject: [JBoss JIRA] Commented: (TEIIDDES-968) Catalog and Schema should use different icons so that they can be distinquished as to their type
[
https://issues.jboss.org/browse/TEIIDDES-968?page=com.atlassian.jira.plug...
]
Debbie Steigner commented on TEIIDDES-968:
------------------------------------------
How would we handle 1 Source Model with multiple schemas containing tables with the same
names? We have several customers that Input Source Models where the db user has access to
2 or more schemas and they want all schemas underneath the same Model and it happens that
there are tables with the same name under each schema.
Catalog and Schema should use different icons so that they can be
distinquished as to their type
------------------------------------------------------------------------------------------------
Key: TEIIDDES-968
URL: https://issues.jboss.org/browse/TEIIDDES-968
Project: Teiid Designer
Issue Type: Enhancement
Components: Modeling
Affects Versions: 7.1.1
Reporter: Van Halbert
Assignee: Barry LaFond
Priority: Minor
Fix For: 7.5
The catalog and schema should use different icons so that they can be distinguishable in
the tree. The mouse-over type would also be helpful.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:48 p.m.
New subject: [JBoss JIRA] Commented: (TEIIDDES-968) Catalog and Schema should use different icons so that they can be distinquished as to their type
[
https://issues.jboss.org/browse/TEIIDDES-968?page=com.atlassian.jira.plug...
]
Steven Hawkins commented on TEIIDDES-968:
-----------------------------------------
See the last comment, the design time name of the table would be the same as the effective
runtime name - catalog.schema.table. This is what happens on the runtime side anyway when
design time catalog/schemas are used. The actual runtime table name becomes
catalog.schema.table, and there is no runtime concept of a source level catalog/schema.
So we're really just proposing that designer mirror the runtime.
Catalog and Schema should use different icons so that they can be
distinquished as to their type
------------------------------------------------------------------------------------------------
Key: TEIIDDES-968
URL: https://issues.jboss.org/browse/TEIIDDES-968
Project: Teiid Designer
Issue Type: Enhancement
Components: Modeling
Affects Versions: 7.1.1
Reporter: Van Halbert
Assignee: Barry LaFond
Priority: Minor
Fix For: 7.5
The catalog and schema should use different icons so that they can be distinguishable in
the tree. The mouse-over type would also be helpful.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
2:36 p.m.
New subject: [JBoss JIRA] Issue Comment Edited: (TEIIDDES-968) Catalog and Schema should use different icons so that they can be distinquished as to their type
[
https://issues.jboss.org/browse/TEIIDDES-968?page=com.atlassian.jira.plug...
]
Barry LaFond edited comment on TEIIDDES-968 at 6/28/11 8:35 AM:
----------------------------------------------------------------
So 2 possible directions.
1) create 2 different icons
or
2) remove the Catalog/Schema as objects a user can create.
- Remove the options from the New Child/New Sibling contributions
- Remove the options from the JDBC Import wizard and assume they are "unchecked
always"
- Add the schema/catalog names to the nameInSource property on import
- Transformation Editor addSource() method and reconciler would have to deal with
NameInSource ??
was (Author: blafond):
So 2 possible directions.
1) create 2 different icons
or
2) remove the Catalog/Schema as objects a user can create.
- Remove the options from the New Child/New Sibling contributions
- Remove the options from the JDBC Import wizard and assume they are "unchecked
always"
- Add the schema/catalog names to the nameInSource property on import
Catalog and Schema should use different icons so that they can be
distinquished as to their type
------------------------------------------------------------------------------------------------
Key: TEIIDDES-968
URL: https://issues.jboss.org/browse/TEIIDDES-968
Project: Teiid Designer
Issue Type: Enhancement
Components: Modeling
Affects Versions: 7.1.1
Reporter: Van Halbert
Assignee: Barry LaFond
Priority: Minor
Fix For: 7.5
The catalog and schema should use different icons so that they can be distinguishable in
the tree. The mouse-over type would also be helpful.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:47 p.m.
New subject: [JBoss JIRA] Commented: (TEIIDDES-968) Catalog and Schema should use different icons so that they can be distinquished as to their type
[
https://issues.jboss.org/browse/TEIIDDES-968?page=com.atlassian.jira.plug...
]
Barry LaFond commented on TEIIDDES-968:
---------------------------------------
So here's the latest proposal
1) Change the visible New > Catalog/Schema to say "New > Schema Folder"
& "New > Catalog Folder"
2) Change the JDBC Import Options page "Include in Model" group label to
"Add Folders" and change the check-box labels to say "Create folders for
each schema/catalog"
3) Add check-box labeled "Use Fully-Qualified Names" in the "Model Object
Names" group.
4) Add a simple "Example: 'PARTSSUPPLIER.PARTS.PART_NAME'" to some of
the toggle options on the page (for clarity)
5) create separate icons for the Catalog Folder and the Schema Folder objects
Catalog and Schema should use different icons so that they can be
distinquished as to their type
------------------------------------------------------------------------------------------------
Key: TEIIDDES-968
URL: https://issues.jboss.org/browse/TEIIDDES-968
Project: Teiid Designer
Issue Type: Enhancement
Components: Modeling
Affects Versions: 7.1.1
Reporter: Van Halbert
Assignee: Barry LaFond
Priority: Minor
Fix For: 7.5
The catalog and schema should use different icons so that they can be distinguishable in
the tree. The mouse-over type would also be helpful.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:19 p.m.
New subject: [JBoss JIRA] Commented: (TEIIDDES-968) Catalog and Schema should use different icons so that they can be distinquished as to their type
[
https://issues.jboss.org/browse/TEIIDDES-968?page=com.atlassian.jira.plug...
]
Barry LaFond commented on TEIIDDES-968:
---------------------------------------
The behavior of the JDBC Importer currently ONLY implements the "Fully Qualified Name
in Source" when there are name conflicts within a Model. There is a unique name check
ahead of the option check which overrides the option. Did not expect this behavior based
on the UI labels
Catalog and Schema should use different icons so that they can be
distinquished as to their type
------------------------------------------------------------------------------------------------
Key: TEIIDDES-968
URL: https://issues.jboss.org/browse/TEIIDDES-968
Project: Teiid Designer
Issue Type: Enhancement
Components: Modeling
Affects Versions: 7.1.1
Reporter: Van Halbert
Assignee: Barry LaFond
Priority: Minor
Fix For: 7.5
The catalog and schema should use different icons so that they can be distinguishable in
the tree. The mouse-over type would also be helpful.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:45 p.m.
New subject: [JBoss JIRA] Commented: (TEIIDDES-968) Catalog and Schema should use different icons so that they can be distinquished as to their type
[
https://issues.jboss.org/browse/TEIIDDES-968?page=com.atlassian.jira.plug...
]
Barry LaFond commented on TEIIDDES-968:
---------------------------------------
From a Teiid standpoint
- there is no fully qualify NIS option
(it rarely makes sense to not fully qualify the name in source)
- useCatalog => if true the catalog can be used in both the runtime name and the name
in source
> "Include Catalog" checkbox that relates to the Fully
Qual. NIS only
- useFullSchemaName => make the Teiid runtime name the unquoted
qualified name
Catalog and Schema should use different icons so that they can be
distinquished as to their type
------------------------------------------------------------------------------------------------
Key: TEIIDDES-968
URL: https://issues.jboss.org/browse/TEIIDDES-968
Project: Teiid Designer
Issue Type: Enhancement
Components: Modeling
Affects Versions: 7.1.1
Reporter: Van Halbert
Assignee: Barry LaFond
Priority: Minor
Fix For: 7.5
The catalog and schema should use different icons so that they can be distinguishable in
the tree. The mouse-over type would also be helpful.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:56 p.m.
New subject: [JBoss JIRA] Updated: (TEIIDDES-968) Catalog and Schema should use different icons so that they can be distinquished as to their type
[
https://issues.jboss.org/browse/TEIIDDES-968?page=com.atlassian.jira.plug...
]
Barry LaFond updated TEIIDDES-968:
----------------------------------
Attachment: jdbc-import-options.png
Catalog and Schema should use different icons so that they can be
distinquished as to their type
------------------------------------------------------------------------------------------------
Key: TEIIDDES-968
URL: https://issues.jboss.org/browse/TEIIDDES-968
Project: Teiid Designer
Issue Type: Enhancement
Components: Modeling
Affects Versions: 7.1.1
Reporter: Van Halbert
Assignee: Barry LaFond
Priority: Minor
Fix For: 7.5
Attachments: jdbc-import-options.png
The catalog and schema should use different icons so that they can be distinguishable in
the tree. The mouse-over type would also be helpful.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:58 p.m.
New subject: [JBoss JIRA] Updated: (TEIIDDES-968) Catalog and Schema should use different icons so that they can be distinquished as to their type
[
https://issues.jboss.org/browse/TEIIDDES-968?page=com.atlassian.jira.plug...
]
Barry LaFond updated TEIIDDES-968:
----------------------------------
Attachment: jdbc-import-options-include-catalog-tooltip.png
Catalog and Schema should use different icons so that they can be
distinquished as to their type
------------------------------------------------------------------------------------------------
Key: TEIIDDES-968
URL: https://issues.jboss.org/browse/TEIIDDES-968
Project: Teiid Designer
Issue Type: Enhancement
Components: Modeling
Affects Versions: 7.1.1
Reporter: Van Halbert
Assignee: Barry LaFond
Priority: Minor
Fix For: 7.5
Attachments: jdbc-import-options-full-names-tooltip.png,
jdbc-import-options-include-catalog-tooltip.png, jdbc-import-options.png
The catalog and schema should use different icons so that they can be distinguishable in
the tree. The mouse-over type would also be helpful.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:58 p.m.
New subject: [JBoss JIRA] Updated: (TEIIDDES-968) Catalog and Schema should use different icons so that they can be distinquished as to their type
[
https://issues.jboss.org/browse/TEIIDDES-968?page=com.atlassian.jira.plug...
]
Barry LaFond updated TEIIDDES-968:
----------------------------------
Attachment: jdbc-import-options-full-names-tooltip.png
Catalog and Schema should use different icons so that they can be
distinquished as to their type
------------------------------------------------------------------------------------------------
Key: TEIIDDES-968
URL: https://issues.jboss.org/browse/TEIIDDES-968
Project: Teiid Designer
Issue Type: Enhancement
Components: Modeling
Affects Versions: 7.1.1
Reporter: Van Halbert
Assignee: Barry LaFond
Priority: Minor
Fix For: 7.5
Attachments: jdbc-import-options-full-names-tooltip.png,
jdbc-import-options-include-catalog-tooltip.png, jdbc-import-options.png
The catalog and schema should use different icons so that they can be distinguishable in
the tree. The mouse-over type would also be helpful.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
6:26 p.m.
New subject: [JBoss JIRA] Resolved: (TEIIDDES-968) Catalog and Schema should use different icons so that they can be distinquished as to their type
[
https://issues.jboss.org/browse/TEIIDDES-968?page=com.atlassian.jira.plug...
]
Barry LaFond resolved TEIIDDES-968.
-----------------------------------
Resolution: Done
Per the screen caps, we removed the ability to create schema/catalog objects during
import. Added a fully-qualified name option that applies to both object names (table,
view, procedure, index) and Name In Source value.
Name In Source is now ALWAYS quoted if a quoted character exists. Previously, it only
quoted only if character exists, there was a naming conflict or the name contained an
"extra" character defined in the database metadata.
Added tooltips to new check-boxes.
Placed model info in it's own "group/panel" at top of page.
Catalog and Schema should use different icons so that they can be
distinquished as to their type
------------------------------------------------------------------------------------------------
Key: TEIIDDES-968
URL: https://issues.jboss.org/browse/TEIIDDES-968
Project: Teiid Designer
Issue Type: Enhancement
Components: Modeling
Affects Versions: 7.1.1
Reporter: Van Halbert
Assignee: Barry LaFond
Priority: Minor
Fix For: 7.5
Attachments: jdbc-import-options-full-names-tooltip.png,
jdbc-import-options-include-catalog-tooltip.png, jdbc-import-options.png
The catalog and schema should use different icons so that they can be distinguishable in
the tree. The mouse-over type would also be helpful.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
4730
days inactive
4775
days old
teiid-designer-issues@lists.jboss.org
17 comments
5 participants
participants (5)
-
Barry LaFond (JIRA) -
Debbie Steigner (JIRA)
-
Ramesh Reddy (JIRA)
-
Steven Hawkins (JIRA)
-
Van Halbert (JIRA)