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 207664 - Sub. days from Date by 2.
Summary: Sub. days from Date by 2.
Status: RESOLVED WORKSFORME
Alias: None
Product: db
Classification: Unclassified
Component: Show Data (show other bugs)
Version: 7.1
Hardware: PC Windows 7
: P3 normal (vote)
Assignee: Jiri Rechtacek
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-01-24 08:50 UTC by arminm
Modified: 2012-02-13 14:22 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description arminm 2012-01-24 08:50:55 UTC 
Product Version = NetBeans IDE 7.1 (Build 201112071828)
Operating System = Windows 7 version 6.1 running on x86
Java; VM; Vendor = 1.7.0_02
Runtime = Java HotSpot(TM) Client VM 22.0-b10

When i use a INSERT-INTO-QUERY for (MS SQL Server) > 2012-02-30
And then try to get them back from DB, i get 2012-02-28, and also when i try to execute a CURRENT_DATE command, i get a value sub. by 2.
It is the same as i try to instert and get data by Java-Code.

If i try it with MS SQL-Editor its's everything okay.

So i don't know if it is a because of Java7 or Netbeans7.1, because with Netbeans 7.0.1 and a lower Java-Version it runs how it should.
Comment 1 Jiri Rechtacek 2012-02-13 14:11:50 UTC 
(In reply to comment #0)
> Product Version = NetBeans IDE 7.1 (Build 201112071828)
> Operating System = Windows 7 version 6.1 running on x86
> Java; VM; Vendor = 1.7.0_02
> Runtime = Java HotSpot(TM) Client VM 22.0-b10
> 
> When i use a INSERT-INTO-QUERY for (MS SQL Server) > 2012-02-30
> And then try to get them back from DB, i get 2012-02-28, and also when i try to
> execute a CURRENT_DATE command, i get a value sub. by 2.
> It is the same as i try to instert and get data by Java-Code.
> 
> If i try it with MS SQL-Editor its's everything okay.
> 
> So i don't know if it is a because of Java7 or Netbeans7.1, because with
> Netbeans 7.0.1 and a lower Java-Version it runs how it should.
Thanks for report. Could you try run NetBeans 7.0.1 with Java7? It works for me with NetBeans 7.1 with Java7 with Java DB and Oracle DB. What are your steps to reproduce in detail? Thanks