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

Summary:	"Insert Record" failed to insert record with INTEGER type
Product:	db	Reporter:	Roman Mostyka <romanmostyka>
Component:	Show Data	Assignee:	_ ahimanikya <ahimanikya>
Status:	VERIFIED FIXED
Severity:	blocker	CC:	blaha
Priority:	P1
Version:	6.x
Hardware:	All
OS:	All
Issue Type:	DEFECT	Exception Reporter:

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.