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

Summary:	Schema for sample DBs is created before script execution
Product:	db	Reporter:	Roman Mostyka <romanmostyka>
Component:	MySQL	Assignee:	David Vancouvering <davidvc>
Status:	VERIFIED FIXED
Severity:	blocker	Keywords:	UI
Priority:	P3
Version:	6.x
Hardware:	All
OS:	All
Issue Type:	DEFECT	Exception Reporter:

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.