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.
Isn't this the same as 63708?
Ignore my question, this is not the same.
Reassigned to new owner.
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.
*** Bug 175747 has been marked as a duplicate of this bug. ***
Created attachment 134252 [details]
proposed patch part1 v1
Created attachment 134253 [details]
proposed patch part2 v1
Thank you very much, Matthias, patches work just fine.
Please review API changes in friend-private module db.metadata.model.
If there are no objections, I'll integrate the patch tomorrow.
Thank you for reviewing.
Integrated as http://hg.netbeans.org/core-main/rev/67430df76120
Thank you again, Matthias.
Integrated into 'main-golden', will be available in build *201305302301* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress)
User: Jaroslav Havlin <email@example.com>
Log: #69846: Display database-specific data types in the column properties
Patch by Matthias42.