[JBoss JIRA] Commented: (TEIIDDES-1026) Teiid Designer "Import from JDBC" for SQL Server only shows dbo schema under the "Select Data Objects" screen
- First Post
- Replies
- Stats
-
Go to
- ----- 2025 -----
- January
- ----- 2024 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2023 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2022 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2021 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2020 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2019 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2018 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2017 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2016 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2015 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2014 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2013 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2012 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2011 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2010 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2009 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
[
https://issues.jboss.org/browse/TEIIDDES-1026?page=com.atlassian.jira.plu...
]
Barry LaFond commented on TEIIDDES-1026:
----------------------------------------
SQL2005SchemaLoader class in DTP is executing a different query:
select
CATALOG_NAME as 'TABLE_CATALOG', SCHEMA_NAME as 'TABLE_SCHEM'
from bqt2.INFORMATION_SCHEMA.SCHEMATA
ORDER BY TABLE_SCHEM
Designer is currently sending queries for getSchema() like:
select
sys.database_principals.default_schema_name 'TABLE_CATALOG',
sys.database_principals.name 'TABLE_SCHEM'
from sys.database_principals
where not sid is null order by sys.database_principals.name
Teiid Designer "Import from JDBC" for SQL Server only shows
dbo schema under the "Select Data Objects" screen
-------------------------------------------------------------------------------------------------------------
Key: TEIIDDES-1026
URL: https://issues.jboss.org/browse/TEIIDDES-1026
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.4
Reporter: Debbie Steigner
Attachments: JdbcCatalogImpl.java.patch, modeler_jdbc_metadata_impl.patch,
PATCH-JdbcTableTypeImpl.txt
Teiid Designer "Import from JDBC" for SQL Server only shows dbo schema under
the "Select Data Objects" screen. If a SQL Server database has multiple schemas
underneath it, the importer will not show them, so you will be unable to choose and import
the tables under any other schema besides dbo. I've attached a printscreen document
explaining further.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
4885
days inactive
4885
days old
teiid-designer-issues@lists.jboss.org
0 comments
1 participants
tags (0)
participants (1)
-
Barry LaFond (JIRA)