Eclipse Community Forums: DTP » DTP - Unable to identify some datatypes

Home » Eclipse Projects » DTP » DTP - Unable to identify some datatypes (Data Explorer View shows some datatypes as blank)

DTP - Unable to identify some datatypes [message #693142]

Tue, 05 July 2011 18:04

Eclipse User

I am using the DTP Framework with Eclipse 3.5.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 )

Is this DTP limitation or am I missing something ?

Attachment: DTPISSUE.png
(Size: 24.50KB, Downloaded 569 times)

Re: DTP - Unable to identify some datatypes [message #725037 is a reply to message #693142]

Tue, 13 September 2011 15:00

Eclipse User

Problem Solved :

I was able to fix the issue by changing the typecode for the concerned data types
in the .xmi files from the plugins below

org.eclipse.datatools.enablement.msft.sqlserver.dbdefinition_1.0.0.v200906161800
org.eclipse.datatools.enablement.oracle.dbdefinition_1.0.100.v200906161800
org.eclipse.datatools.enablement.sqlite.dbdefinition_1.0.1.v201002041110

I would like to contribute the changes to the open source plugins. Please suggest the right way to do so.

Re: DTP - Unable to identify some datatypes [message #733494 is a reply to message #725037]

Tue, 04 October 2011 17:42

Eclipse User

Hi Swati,

Please open bug on DTP in Eclipse Bugzilla and attach your changes as
patch files.

On 9/13/2011 12:00 PM, Swati Sapar wrote:
> Problem Solved :
>
> I was able to fix the issue by changing the typecode for the concerned
> data types
> in the .xmi files from the plugins below
>
> org.eclipse.datatools.enablement.msft.sqlserver.dbdefinition_1.0.0.v200906161800
>
> org.eclipse.datatools.enablement.oracle.dbdefinition_1.0.100.v200906161800
> org.eclipse.datatools.enablement.sqlite.dbdefinition_1.0.1.v201002041110
>
> I would like to contribute the changes to the open source plugins.
> Please suggest the right way to do so.

Previous Topic:	connecting to a MS Access (mdb) database?
Next Topic:	Create table using SQL Scrapbook

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 23 22:22:52 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter