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 118124 - need shorter names for SQL connections
Summary: need shorter names for SQL connections
Status: RESOLVED DUPLICATE of bug 144112
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 6.x
Hardware: All All
: P2 blocker (vote)
Assignee: David Vancouvering
URL:
Keywords:
: 119667 (view as bug list)
Depends on:
Blocks:
 
Reported: 2007-10-08 17:00 UTC by athompson
Modified: 2008-10-16 22:55 UTC (History)
0 users

See Also:
Issue Type: ENHANCEMENT
Exception Reporter:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description athompson 2007-10-08 17:00:26 UTC
currently, if you create an SQL connection it is added with a concatenation of the JDBC URL, the user, and schema as its
name.  the problem is that often these names wind up quite long.  so if you have more than one database from a similar
source (which also happens often) you can't tell which connection is which unless you scroll all the way to the right. 
it's also annoying that space is wasted on a horizontal scrollbar just because the names are so long.

but the big problem is that since the 'connection' drop down list in the SQL editor truncates the connection name if
it's too long to display, you can't tell which connection you're running the SQL commands against.  hence, this IMO is a
defect and not an enhancement because of the usability issue.

providing the ability for users to name/rename the SQL connection would solve all of these problems and makes for a much
more pleasant experience.
Comment 1 Peter Pis 2007-10-10 11:53:19 UTC
Reassigning to "db"...
Comment 2 Andrei Badea 2007-10-10 13:26:23 UTC
The tooltip of the connection combo box shows the full name of the connection. I guess this makes the issue an
enhancement more than a defect. But the change is doable.

Comment 3 athompson 2007-10-10 14:26:42 UTC
yup, you're right.
Comment 4 Andrei Badea 2007-10-23 11:28:10 UTC
*** Issue 119667 has been marked as a duplicate of this issue. ***
Comment 5 Andrei Badea 2007-10-23 11:28:39 UTC
See also issue 119667 desc2.
Comment 6 jaro 2008-09-15 21:46:30 UTC
This issue is still valid for Netbeans 6.5. Please consider implementing this small enhancement for the next version 7.0.
If you have an Oracle RAC database, connection URL can be quite long, and tooltip doesn't help anymore much.
Comment 7 David Vancouvering 2008-09-15 22:50:41 UTC
Yes, we should fix this.  We pay attention to votes so that helps.  I think it's an appearance/usability issue too,
particularly for non-Java users.
Comment 8 David Vancouvering 2008-10-16 22:55:31 UTC

*** This issue has been marked as a duplicate of 144112 ***