Bug 1166248 - Inconsistent column datatypes when importing
Summary: Inconsistent column datatypes when importing
Keywords:
Status: CLOSED NOTABUG
Alias: None
Product: JBoss Data Virtualization 6
Classification: JBoss
Component: Tooling
Version: 6.1.0
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
: ---
Assignee: Barry LaFond
QA Contact:
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2014-11-20 16:22 UTC by Andrej Smigala
Modified: 2016-09-27 14:12 UTC (History)
4 users (show)

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2016-02-05 08:29:15 UTC
Type: Bug
Embargoed:

Attachments (Terms of Use)
datatypes (74.55 KB, image/png)
2014-11-20 16:22 UTC, Andrej Smigala 		no flags Details
View All


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker JBDVPL-149 0 Blocker New Lack of configuration to set default datatype mapping for columns in source model when importing jdbc datasource 2016-09-27 14:22:10 UTC
Red Hat Issue Tracker TEIIDDES-2398 0 Major Resolved Inconsistent column datatypes when importing 2016-09-27 14:22:10 UTC

Description Andrej Smigala 2014-11-20 16:22:38 UTC 
Created attachment 959438 [details]
datatypes

There are multiple discrepancies in the column datatypes when importing using JDBC importer vs when using Teiid Connection importer.

Also some of the imported datatypes seem completely wrong (e.g. bigdecimal for almost all numeric datatypes in oracle)
Comment 2 Barry LaFond 2014-11-24 14:24:35 UTC 
Plan is to work TEIIDDES-2398 for Designer 9.1 and 8.6.2 patch release. The design would insert an extra page on the importers (JDBC & Teiid Connection) that displays the datatype mappings that will be used by default. User can then switch/change any of the datatype mappings before the model is actually constructed at the end of the import.  Should be able to utilize the same page in both importers.
Comment 3 Matus Makovy 2016-02-05 08:29:15 UTC 
Closing this since we are tracking issues for tooling only in JIRA from now on.
Comment 4 JBoss JIRA Server 2016-09-27 14:12:01 UTC 
Barry LaFond <blafond> updated the status of jira TEIIDDES-2398 to Resolved
Note You need to log in before you can comment on or make changes to this bug.