[Bug 226136] New: Wrong Datatye Reported by Netbeans

  • From:
  • To:
  • Subject: [Bug 226136] New: Wrong Datatye Reported by Netbeans
  • Date: Thu, 14 Feb 2013 19:27:54 +0000
  • Auto-submitted: auto-generated

http://netbeans.org/bugzilla/show_bug.cgi?id=226136

             Bug #: 226136
        Issue Type: DEFECT
           Summary: Wrong Datatye Reported by Netbeans
    Classification: Unclassified
           Product: db
           Version: Dev
          Platform: PC
        OS/Version: Windows 7
            Status: NEW
          Priority: P3
         Component: SQL Editor
        AssignedTo: 

        ReportedBy: 

         QAContact: 



Some background info:

Product Version: NetBeans IDE Dev (Build 2013-01-24_09-04-16 )
Java: 1.7.0_11; Java HotSpot(TM) 64-Bit Server VM 23.6-b04
Runtime: Java(TM) SE Runtime Environment 1.7.0_11-b21
System: Windows 7 version 6.1 running on amd64; Cp1252; en_US (nb)

Using jTDS 1.3.0 JDBC driver to connect to a MS SQL Server.
Any column that is of the datatype of datetime is interpreted as a timestamp
datatype inside of Netbeans.


How to replicate:
1) Create a table on a mssql server that has a column of type datetime. You 
can
use Netbeans or any tool, it doesn't matter.

2) Verify that the column really is of type datetime by using SQL Server
Management Studio, or a SQL Client written in Java like Aqua Data Studio.

3) Go to Netbeans database browser and right-click on the datetime column and
select the "Properties" context menu item.

4) See what it says for "Data type"

Actual Results:
TIMESTAMP

Expected Results:
DATETIME

-- 
Configure bugmail: http://netbeans.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA Contact for the bug.


[Bug 226136] New: Wrong Datatye Reported by Netbeans

cwt137 02/14/2013

[Bug 226136] Wrong Datatye Reported by Netbeans

jhavlin 02/15/2013

Project Features

About this Project

DB was started in November 2009, is owned by Antonin Nebuzelsky, and has 113 members.
By use of this website, you agree to the NetBeans Policies and Terms of Use (revision 20131025.e7cbc9d). © 2013, Oracle Corporation and/or its affiliates. Sponsored by Oracle logo
 
 
Close
loading
Please Confirm
Close