Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
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 22:04 Go to next message
Swati Sapar is currently offline Swati SaparFriend
Messages: 20
Registered: September 2010
Junior Member
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 509 times)

Report message to a moderator

Re: DTP - Unable to identify some datatypes [message #725037 is a reply to message #693142] Tue, 13 September 2011 19:00 Go to previous messageGo to next message
Swati Sapar is currently offline Swati SaparFriend
Messages: 20
Registered: September 2010
Junior Member
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.

Report message to a moderator

Re: DTP - Unable to identify some datatypes [message #733494 is a reply to message #725037] Tue, 04 October 2011 21:42 Go to previous message
Brian Payton is currently offline Brian PaytonFriend
Messages: 154
Registered: July 2009
Senior Member
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.

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 13:44:04 GMT 2024

Powered by FUDForum. Page generated in 0.03395 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly