Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 369748

Summary:

Unable to identify specific datatypes in Oracle,MySql and SQL Server

Product:

[Tools] Data Tools

Reporter:

Swati Sapar <swati.udas>

Component:

Enablement

Assignee:

Brian Payton <bpayton>

Status:

RESOLVED FIXED

QA Contact:

Severity:

major

Priority:

CC:

bpayton

Version:

unspecified

Target Milestone:

1.10

Hardware:

OS:

Windows 7

Whiteboard:

Attachments:

Description	Flags
Oracle_10.xmi and Oracle_11.xmi files jdbcenumtypes updated	bpayton: iplog+

Description Swati Sapar

2012-01-25 16:35:08 EST

Build Identifier: Eclipse 3.7.2, DTP1.9

I am using the DTP Framework with Eclipse 3.7.2
I can connect to various databases including MySql , Oracle,
Sql Server etc. However some of the columns do not show proper datatypes.
E.g for Oracle the NCLOB datatype column shows blank as shown in attached screenshot.

Similarly if I access the table from Java code and try to get the datatype using ColumnImpl.getDatatype() function, then the datatype is returned as null for some specific datatypes(NCLOB in Oracle,NVARCHAR2() in Oracle,etc )


Reproducible: Always

Steps to Reproduce:
1.Create a connection to Oracle 10 db
2.Create a table with columns having data types NCLOB,NVARCHAR2
3.View the tab;e columns in DTP view. The column data type show up as blank

Comment 1 Swati Sapar

2012-01-25 17:25:45 EST

Created attachment 210086 [details]
Oracle_10.xmi and Oracle_11.xmi files jdbcenumtypes updated

This patch applies to the 
org.eclipse.datatools.enablement.oracle.dbdefinition  plugin 1_9_0 branch

This will enable viewing columns with datatypes NCLOB/NVARCHAR/BFILE/NCHAR correctly in DTP explorer.

Comment 2 Swati Sapar

2012-01-25 17:31:38 EST

I would like to submit similar patch for other databases (SQLite,SQLServer) soon.
Please let me know if any more information is required for getting the changes into the open source code.

Comment 3 Brian Payton

2012-05-17 21:01:31 EDT

OK, I've checked in the changes for the Oracle 10 and 11 .xmi files.  Here's the Git commit record:
http://git.eclipse.org/c/datatools/org.eclipse.datatools.enablement.oracle.git/commit/?id=ef8b7daacc45e1d83b5c78fccc89cc02eac61731

Go ahead and open new bugs for changes to the other database types.

Comment 4 Swati Sapar

2012-05-29 19:45:12 EDT

Create bugs : Bugzilla – Bug 380977 and Bug 380976 for Sql Server and Sqlite resoectively. Also submitted the relevant patch files.