Bug 780811 (SOA-3256) - Teiid Designer "Import from JDBC" for SQL Server only shows dbo schema under the "Select Data Objects" screen
Summary: Teiid Designer "Import from JDBC" for SQL Server only shows dbo schema under ...
Keywords:
Status: CLOSED NEXTRELEASE
Alias: SOA-3256
Product: JBoss Enterprise SOA Platform 5
Classification: JBoss
Component: EDS
Version: 5.1.0 GA
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ---
: JBDS
Assignee: Van Halbert
QA Contact:
URL: http://jira.jboss.org/jira/browse/SOA...
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2011-08-10 20:06 UTC by dsteigne
Modified: 2011-11-30 19:50 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2011-11-30 19:50:59 UTC
Type: Bug

Attachments (Terms of Use)
Additionalschemas.doc (293.50 KB, application/msword)
2011-08-10 20:06 UTC, dsteigne 		no flags Details
View All Add an attachment (proposed patch, testcase, etc.)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker SOA-3256 0 None None None Never
Red Hat Issue Tracker TEIIDDES-1026 0 None None None Never

Description dsteigne 2011-08-10 20:06:08 UTC 
Help Desk Ticket Reference: https://c.na7.visual.force.com/apex/Case_View?id=500A0000007r11j
project_key: SOA

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.
Comment 1 dsteigne 2011-08-10 20:06:29 UTC 
Attachment: Added: Additionalschemas.doc
Comment 2 Van Halbert 2011-08-10 20:31:35 UTC 
Link: Added: This issue Cloned to SOA-3257
Comment 3 Van Halbert 2011-08-23 14:31:47 UTC 
Committed by Teiid Designer and is available via their nightly updates.  Will be in the 5.2.
Comment 4 David Le Sage 2011-08-25 23:45:11 UTC 
Release Notes Docs Status: Added: Documented as Resolved Issue
Writer: Added: dlesage
Release Notes Text: Added: https://issues.jboss.org/browse/SOA-3256

The Teiid Designer's  "Import from JDBC" for SQL Server only showed one dbo schema under the "Select Data Objects" screen.  If there were multiple schemas under a SQL Server database, the importer would not show them. As a result, the user would be  unable to choose and import the tables under any schema other than dbo. This has now been corrected so that the user can choose and import tables under alternative schemas.
Comment 5 Paul Nittel 2011-11-30 19:50:59 UTC 
Tested and closed.
Note You need to log in before you can comment on or make changes to this bug.