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 144844 - Schema for sample DBs is created before script execution
Summary: Schema for sample DBs is created before script execution
Status: VERIFIED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: MySQL (show other bugs)
Version: 6.x
Hardware: All All
: P3 blocker (vote)
Assignee: David Vancouvering
URL:
Keywords: UI
Depends on:
Blocks:
 
Reported: 2008-08-22 12:20 UTC by Roman Mostyka
Modified: 2008-09-11 11:30 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 Roman Mostyka 2008-08-22 12:20:23 UTC 
1. Add MySQL Server to the IDE.
2. Rightclick it's node and choose "Create Database...".
3. Choose "travel" sample DB and click OK.
4. Click "Cancel" button in "New Database Connection" dialog.

Result: Script isn't executed, but schema "travel" is created. Next time user will get message that schema already exists.
Comment 1 David Vancouvering 2008-08-25 19:33:08 UTC 
I had a discussion with another user about this, and we agreed the right approach here will be to ask the user if they
want to drop the database (aka schema) if the user cancels the new connection dialog.
Comment 2 David Vancouvering 2008-09-02 20:50:31 UTC 
This requires a UI change where we ask the user if they want to drop the database if they Cancel the new connection dialog.
Comment 3 David Vancouvering 2008-09-05 18:57:13 UTC 
48a33856c0a2
Comment 4 Quality Engineering 2008-09-07 16:43:39 UTC 
Integrated into 'main-golden', will be available in build *200809071401* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress)
Changeset: http://hg.netbeans.org/main/rev/48a33856c0a2
User: David Van Couvering <davidvc@netbeans.org>
Log: #144844: Schema for sample DBs is created before script execution
This is solved by asking the user if they want to delete the database that was created if they cancel
Comment 5 Roman Mostyka 2008-09-11 11:30:12 UTC 
Verified with build 080910.