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 150271

Summary:	Connections with the same name are removed by removing by removing DB with this name
Product:	db	Reporter:	Roman Mostyka <romanmostyka>
Component:	MySQL	Assignee:	David Vancouvering <davidvc>
Status:	VERIFIED FIXED
Severity:	blocker	CC:	sustaining
Priority:	P2
Version:	6.x
Hardware:	All
OS:	All
Issue Type:	DEFECT	Exception Reporter:

Description Roman Mostyka 2008-10-15 18:46:35 UTC

1. Add MySQL connection for "travel" DB on remote MySQL server.
2. Register local MySQL server.
3. Add MySQL connection for "travel" DB on local MySQL server.
4. Expand registered MySQL server's node, rightclick "travel" DB and choose "Delete".

Result: Both connection (for local and remote servers) to "travel" DB are deleted.
I'm not sure that it is P1, since there is workaround (add all necessary connections again), but it is very, very
inconvenient.
But anyway, if you think that it is P2, then I don't have objections.

Comment 1 David Vancouvering 2008-10-15 18:52:14 UTC

I don't believe this is a showstopper, I don't think this is a common scenario.  But it's an easy fix, so I will let it
be your call.  I'll work on a fix.

Comment 2 David Vancouvering 2008-10-15 19:09:55 UTC

7d3ae7ed7801
a99b3f12dea2

Check to make sure host name in connection matches host name for MySQL server before deleting connection.  Also use IP
address as a possibility, and also check to make port number matches.

Comment 3 David Vancouvering 2008-10-15 22:05:49 UTC

Roman, after further consideration, I don't believe this is a P1 - such that it needs to be integrated into RC branch. 
But let's definitely get this into patch1.

Comment 4 Quality Engineering 2008-10-16 04:16:55 UTC

Integrated into 'main-golden', will be available in build *200810160201* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress)
Changeset: http://hg.netbeans.org/main/rev/7d3ae7ed7801
User: David Van Couvering <davidvc@netbeans.org>
Log: #150271: Connections with the same name are removed by removing by removing DB with this name

Comment 5 Roman Mostyka 2008-10-16 13:36:22 UTC

Verified with build 081016.

Comment 6 rbalada 2008-11-18 13:47:49 UTC

I've transplanted the two referred changesets into release65_fixes repository in following way:
http://hg.netbeans.org/main/rev/7d3ae7ed7801 as http://hg.netbeans.org/release65_fixes/rev/58be968fe970
http://hg.netbeans.org/main/rev/a99b3f12dea2 as http://hg.netbeans.org/release65_fixes/rev/4b50efb306cb