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

Summary: need shorter names for SQL connections
Product: db Reporter: athompson <athompson>
Component: CodeAssignee: David Vancouvering <davidvc>
Status: RESOLVED DUPLICATE    
Severity: blocker    
Priority: P2    
Version: 6.x   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Exception Reporter:

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 ***