Bug 1082871
| Summary: | JDBC Importer fails when importing Access 2013 metadata via JDBC ODBC bridge | ||||||
|---|---|---|---|---|---|---|---|
| Product: | [JBoss] JBoss Data Virtualization 6 | Reporter: | Anu Saji <asaji> | ||||
| Component: | Tooling | Assignee: | Barry LaFond <blafond> | ||||
| Status: | CLOSED NOTABUG | QA Contact: | Andrej Smigala <asmigala> | ||||
| Severity: | medium | Docs Contact: | |||||
| Priority: | unspecified | ||||||
| Version: | 6.0.0 | CC: | atangrin, mbaluch, mmakovy, vhalbert | ||||
| Target Milestone: | --- | ||||||
| Target Release: | --- | ||||||
| Hardware: | Unspecified | ||||||
| OS: | Unspecified | ||||||
| Whiteboard: | |||||||
| Fixed In Version: | Doc Type: | Bug Fix | |||||
| Doc Text: | Story Points: | --- | |||||
| Clone Of: | Environment: | ||||||
| Last Closed: | 2016-02-05 08:03:57 UTC | Type: | Bug | ||||
| Regression: | --- | Mount Type: | --- | ||||
| Documentation: | --- | CRM: | |||||
| Verified Versions: | Category: | --- | |||||
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||
| Cloudforms Team: | --- | Target Upstream Version: | |||||
| Embargoed: | |||||||
| Attachments: |
|
||||||
The work-around should be the suggested path for users connecting to MS Access since Teiid exposes applicable importer properties to properly import desired tables. Recommend we cover this in the doc, if we haven't already and close this issue as resolved? Barry, given comment #2 - Documenting the workaround should in my opinion be sufficient. Closing this since we are tracking issues for tooling only in JIRA from now on. Barry LaFond <blafond> updated the status of jira TEIIDDES-2097 to Resolved Matus Makovy <mmakovy> updated the status of jira TEIIDDES-2097 to Closed |
Created attachment 881187 [details] Image file showing tables not being listed while importing the DB(MS-ACCESS) using JDBC Description of problem: Unable to import metadata from MS-ACCESS in to the Teiid designer. Version-Release number of selected component (if applicable): -Tooling JBDS 7.x - Customer has tested this on MS-Access 2000, MS-Access 2010 and MS-Access 2013 - Windows 7 Professional on Desktop, - Windows Server 2008 R2 Standard on server. How reproducible: 1. Create a JDBC ODBC bridge connection profile (class: sun.jdbc.odbc.JdbcOdbcDriver) 2. Try importing using JDBC importer, no tables are shown Actual results: **************** Attaching No_ODBC_metadata.pdf (from client sent file) No tables listed. Expected results: ***************** While importing the database via JDBC, there should be a list of tables created in MS-ACCESS Additional info: