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 255594 - Error "Please enter valid values for not nullable columns" when trying to insert row
Summary: Error "Please enter valid values for not nullable columns" when trying to ins...
Status: RESOLVED DUPLICATE of bug 254904
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 8.1
Hardware: PC Windows 7
: P3 normal (vote)
Assignee: Libor Fischmeistr
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-09-28 04:24 UTC by skomisa
Modified: 2015-09-29 19:04 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments
NetBeans\8.1beta\var\log\messages.log with stack trace (237.87 KB, application/octet-stream)
2015-09-28 04:24 UTC, skomisa
Details
Screenshot when DBException occurred (110.86 KB, image/png)
2015-09-28 04:50 UTC, skomisa
Details

Note You need to log in before you can comment on or make changes to this bug.
Description skomisa 2015-09-28 04:24:22 UTC
Created attachment 156452 [details]
NetBeans\8.1beta\var\log\messages.log with stack trace

I got a DBException ("Please enter valid values for not nullable columns") when trying to insert the first row into an Oracle 11g Expresss table I had just created.

This is the table:

SQL> DESC JUNK
 Name                                      Null?    Type
 ----------------------------------------- -------- --------------
 CITY                                      NOT NULL CHAR(24)
 STATE                                              CHAR(2)
 ZIP                                                NUMBER(38)


The data I tried to insert into table JUNK was valid and trivial:

CITY   Delray Beach
STATE  FL
ZIP    33446

See the attached messages.log file for the stack trace.

Bug 254904 may be relevant.

NetBeans environment details:

Product Version: NetBeans IDE 8.1 Beta (Build 201508041349)
Java: 1.8.0_60; Java HotSpot(TM) 64-Bit Server VM 25.60-b23
Runtime: Java(TM) SE Runtime Environment 1.8.0_60-b27
System: Windows 7 version 6.1 running on amd64; Cp1252; en_US (nb)
User directory: C:\Users\JohnDoe\AppData\Roaming\NetBeans\8.1beta
Cache directory: C:\Users\JohnDoe\AppData\Local\NetBeans\Cache\8.1beta
Comment 1 skomisa 2015-09-28 04:50:15 UTC
Created attachment 156453 [details]
Screenshot when DBException occurred
Comment 2 matthias42 2015-09-29 19:04:22 UTC
Thank you skomisa for your report. The fix from the referenced bug went in after netbeans 8.1-beta. The fix is in the current nightly build.

Your screenshot in fact shows the same problem as bug 254904. CITY may not be null, but your second row has it NULL.

With a current nightly build you'll get a "normal" error dialog with the message, but not an exception.

*** This bug has been marked as a duplicate of bug 254904 ***