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 155596 - "Insert Record" failed to insert record with INTEGER type
Summary: "Insert Record" failed to insert record with INTEGER type
Status: VERIFIED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: Show Data (show other bugs)
Version: 6.x
Hardware: All All
: P1 blocker (vote)
Assignee: _ ahimanikya
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-12-16 18:05 UTC by Roman Mostyka
Modified: 2009-02-19 20:38 UTC (History)
1 user (show)

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 Roman Mostyka 2008-12-16 18:05:10 UTC 
1. Connect to "travel" Java DB.
2. Rightclick "Tables" node and choose "Create Table...".
3. Enter table name, column name, choose INTEGER and click "OK".
4. Rightclick recently created table and choose "View Data".
5. Click "Insert Record" button, enter '1' for the column and click "OK".

Result: Error message "Insert command failed: No rows inserted" appears and record isn't inserted.
Comment 1 Petr Blaha 2008-12-17 09:51:34 UTC 
The workaround is to insert data in table by SQL INSERT execution. This is regression over NB 6.5 since this
functionality works in NB 6.5 fine. Since there is a workaround the issue isn't considered as M1 stopper.
Comment 2 _ ahimanikya 2008-12-17 12:02:55 UTC 
With the new Insert Dialog this works fine.
Comment 3 Petr Blaha 2008-12-17 12:12:22 UTC 
What is the change that fixes the issue?
Comment 4 Roman Mostyka 2008-12-18 16:48:27 UTC 
Verified with build 081218.