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 141797 - [65cat] org.netbeans.modules.db.dataview.meta.DBException: Error code 1364, SQL state HY000Insert Commandfailed:Field 'user' doesn't have a default value -- java.sql.SQLException: Field 'user' doesn't have a
Summary: [65cat] org.netbeans.modules.db.dataview.meta.DBException: Error code 1364, S...
Status: RESOLVED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: Show Data (show other bugs)
Version: 6.x
Hardware: All All
: P3 blocker (vote)
Assignee: _ ahimanikya
URL: http://statistics.netbeans.org/except...
Keywords:
Depends on:
Blocks:
 
Reported: 2008-07-27 02:29 UTC by sunbiz
Modified: 2008-07-30 17:14 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Exception Reporter: 82511

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 sunbiz 2008-07-27 02:29:47 UTC 
Build: NetBeans IDE Dev (Build 080725)
VM: Java HotSpot(TM) Client VM, 11.0-b12, Java(TM) SE Runtime Environment, 1.6.0_10-beta-b25
OS: Windows Vista, 6.0, x86

User Comments: 
Incorrect data type entry inside the add record to MySQL database colum

Stacktrace: 
org.netbeans.modules.db.dataview.meta.DBException: Error code 1364, SQL state HY000Insert Commandfailed:Field 'user' doesn't have a default value -- java.sql.SQLException: Field 'user' doesn't have a default value
        at org.netbeans.modules.db.dataview.output.SQLStatementExecutor.commitOrRollback(SQLStatementExecutor.java:139)
        at org.netbeans.modules.db.dataview.output.SQLExecutionHelper$1.finished(SQLExecutionHelper.java:163)
        at org.netbeans.modules.db.dataview.output.SQLStatementExecutor.run(SQLStatementExecutor.java:107)
        at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)
        at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997)
Comment 1 _ ahimanikya 2008-07-28 08:17:49 UTC 
I error message comes from the driver, I think works as expected.
Comment 2 _ ahimanikya 2008-07-28 08:18:42 UTC 
The error message comes from the driver, I think it works as expected.
Comment 3 sunbiz 2008-07-28 08:28:11 UTC 
Since this is thrown by the driver, Netbeans should be able to cleanly show a dialog instead of throwing an exception 
dialog. Whenever we miss an entry or have incorrect data, it generally shows the Information dialog, so why not in this 
case??
Comment 4 Roman Mostyka 2008-07-28 10:33:26 UTC 
Not sure that we can handle all driver's exceptions. We can handle main, but not sure that it is appropriate way to
replace all driver's exception by IDE's Information dialog.
Comment 5 _ ahimanikya 2008-07-28 11:07:31 UTC 
I agree with Roman. Anyway, let me know whether we still try to fix these exception issues.
Comment 6 Andrei Badea 2008-07-28 12:33:20 UTC 
What exactly makes the driver throw this exception?
Comment 7 _ ahimanikya 2008-07-28 12:53:33 UTC 
See the 1st entry.
Comment 8 Andrei Badea 2008-07-28 14:52:47 UTC 
Thank you.
Comment 9 _ ahimanikya 2008-07-30 10:07:16 UTC 
http://hg.netbeans.org/main/rev/8f298b66e8f1
Comment 10 Roman Mostyka 2008-07-30 17:14:36 UTC 
sunbiz, can You check the fix?