This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 69846

Summary:	Display database-specific data types in the column properties
Product:	db	Reporter:	Andrei Badea <abadea>
Component:	Code	Assignee:	Jiri Rechtacek <jrechtacek>
Status:	RESOLVED FIXED
Severity:	blocker	CC:	apireviews, danilchenko_anton
Priority:	P1	Keywords:	API_REVIEW_FAST, NETFIX, PATCH_AVAILABLE
Version:	5.x
Hardware:	All
OS:	All
Issue Type:	ENHANCEMENT	Exception Reporter:
Bug Depends on:
Bug Blocks:	152818, 163595
Attachments:	proposed patch part1 v1 proposed patch part2 v1

Description Andrei Badea 2005-12-04 16:19:24 UTC

The Database Explorer currently displays types from java.sql.Types as the colum
data type in the column properties. The column database-specific data type
should also be displayed.

Some databases map multiple database-specific data types to a single type from
java.sql.Types or map them to java.sql.Types.OTHER (see issue 69243 for an
example). Therefore it's not possible currently to tell the column type just by
looking at the node's properties.

Comment 1 David Vancouvering 2007-05-29 21:34:29 UTC

Isn't this the same as 63708?

Comment 2 David Vancouvering 2007-05-29 21:35:51 UTC

Ignore my question, this is not the same.

Comment 3 Jiri Rechtacek 2009-10-16 14:11:40 UTC

Reassigned to new owner.

Comment 4 PrplHaz4 2013-03-11 20:16:03 UTC

This proved extremely frustrating for me in using MySQL "DateTime" column type.  NetBeans was reporting it as type "TimeStamp", which also exists in MySQL, but does not function the same.

I beleive it should be default for the database explorer/database services to report the correct db-centric column types as the Java type is irrelevant when you're not developing in Java.

Comment 5 matthias42 2013-05-09 11:24:56 UTC

*** Bug 175747 has been marked as a duplicate of this bug. ***

Comment 6 matthias42 2013-05-09 11:27:27 UTC

Created attachment 134252 [details]
proposed patch part1  v1

Comment 7 matthias42 2013-05-09 11:28:00 UTC

Created attachment 134253 [details]
proposed patch part2  v1

Comment 8 Jaroslav Havlin 2013-05-20 17:06:10 UTC

Thank you very much, Matthias, patches work just fine.

Comment 9 Jaroslav Havlin 2013-05-20 17:10:07 UTC

Please review API changes in friend-private module db.metadata.model.

New methods:
org.netbeans.modules.db.metadata.model.api.Value.getTypeName()
org.netbeans.modules.db.metadata.model.spi.ValueImplementation.getTypeName()

Thank you.

Comment 10 Jaroslav Havlin 2013-05-28 14:44:47 UTC

If there are no objections, I'll integrate the patch tomorrow.
Thank you for reviewing.

Comment 11 Jaroslav Havlin 2013-05-29 14:58:09 UTC

Integrated as http://hg.netbeans.org/core-main/rev/67430df76120
Thank you again, Matthias.

Comment 12 Quality Engineering 2013-05-31 01:23:15 UTC

Integrated into 'main-golden', will be available in build *201305302301* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress)
Changeset: http://hg.netbeans.org/main-golden/rev/67430df76120
User: Jaroslav Havlin <jhavlin@netbeans.org>
Log: #69846: Display database-specific data types in the column properties

Patch by Matthias42.