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 57995 - Add Table action is not atomic
Summary: Add Table action is not atomic
Status: NEW
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 4.x
Hardware: All Windows XP
: P4 blocker (vote)
Assignee: Libor Fischmeistr
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-04-18 19:12 UTC by Martin Schovanek
Modified: 2013-08-01 12:53 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 Martin Schovanek 2005-04-18 19:12:48 UTC 
[#200404171930, jdk1.5.0, jdbc.net.DB2Driver]

to reproduce:
-------------
0) have a table with index
1) right-click the table node
2) chose 'Add Column...'
3) fill [Name: xyz, Type: BLOB, Index: true]
4) press [OK]
NOTE: IDE Throws message:
'Enable to execute command: drop index ....'

5) close the message
6) uncheck the Index check-box
7) press [OK] again
NOTE: IDE Throws message:
'Enable to execute command: ... 'xyz' is duplicate name.

ERROR: The previuos action action was not finish suceffuly but modified the DB
(the column was created).
Comment 1 Petr Blaha 2006-03-13 13:32:17 UTC 
TM 5.0 -> TBD
Comment 2 Andrei Badea 2006-05-25 17:04:24 UTC 
This is difficult to implement in the current architecture. It requires
disabling the auto commit on the database connection, which is risky, since the
connection is shared by multiple components in the IDE. Not for 5.5.
Comment 3 David Vancouvering 2008-01-09 23:09:43 UTC 
Not staffed to solve this sort of problem right now.
Comment 4 David Vancouvering 2008-01-12 01:28:06 UTC 
I don't believe this is a big issue, and has not been complained about by users.  Downgrading
Comment 5 Jiri Rechtacek 2009-07-01 07:57:41 UTC 
Reassigned to new owner.