Bug 208203 - Suggestions for improved usability of the new jdbc connection wizard
Summary: Suggestions for improved usability of the new jdbc connection wizard
Status: NEW
Alias: None
Product: Data Tools
Classification: Tools
Component: JDBC Conn Profile (show other bugs)
Version: 1.5.1   Edit
Hardware: PC Windows XP
: P3 enhancement (vote)
Target Milestone: future   Edit
Assignee: Brian Fitzpatrick CLA
QA Contact:
URL:
Whiteboard:
Keywords: usability
Depends on: 213146 213147
Blocks:
  Show dependency tree
 
Reported: 2007-10-31 04:58 EDT by Eden Klein CLA
Modified: 2008-04-23 10:36 EDT (History)
5 users (show)

See Also:
bfitzpat: review-


Attachments
the exported plugins (81.33 KB, application/x-zip-compressed)
2007-10-31 04:58 EDT, Eden Klein CLA
no flags Details
RSD for the added features (94.50 KB, application/msword)
2007-10-31 05:07 EDT, Eden Klein CLA
no flags Details
The plugins without the license requirements (80.71 KB, application/x-zip-compressed)
2007-11-11 07:24 EST, Eden Klein CLA
no flags Details

Note You need to log in before you can comment on or make changes to this bug.
Description Eden Klein CLA 2007-10-31 04:58:46 EDT
Created attachment 81700 [details]
the exported plugins

Attached 2 plugins with some enhancements to make the creation of a new jdbc connection much easier and intuitive to the user. In order see the code working you just need to add the jdbc drivers in the relevant folders.
In addition, the code provides a double click action on tables in order to edit them (acts like the right click->edit action)
Comment 1 Eden Klein CLA 2007-10-31 05:00:28 EDT
My team would be willing to continue working on this code with DTP
Comment 2 Eden Klein CLA 2007-10-31 05:07:10 EDT
Created attachment 81701 [details]
RSD  for the added features

The requirements and specification document includes the list of chnages/enhacements included in the attached plugins
Comment 3 Eden Klein CLA 2007-10-31 05:08:21 EDT
My team would be willing to continue working on this code with DTP
Comment 4 Brian Fitzpatrick CLA 2007-11-09 19:18:58 EST
Hi there... Where would I find the com.zend.license & com.zend.license.ui plug-ins so I can take a look at this? Thanks. --Fitz
Comment 5 Eden Klein CLA 2007-11-11 07:24:11 EST
Created attachment 82616 [details]
The plugins without the license requirements

In the attachment you can file the plugins modified so that they don't require a license
Comment 6 Eden Klein CLA 2007-11-11 07:29:50 EST
you can get the org.eclipse.php.ui plugin (which is a dependency of com.zend.php.datatools.ui) from http://download.eclipse.org/tools/pdt/downloads/
Comment 7 Brian Fitzpatrick CLA 2007-11-12 13:28:17 EST
Hi there...

I've had some time to take a look at your proposed contributions and have a few concerns and comments...

I think the way you streamlined the process in the wizard and property pages is fine. My concern here is that if there are custom pages available for a particular driver/DBMS/profile, you're not allowing the user access to that updated functionality by boiling the interface down to URL, user name, and password. If extenders provide their own profile wizards or categories, they're going to want access to them in the DSE. 

My biggest concern with this approach is that it's not additive, it changes the look and feel of the DSE by removing/changing categories and then overrides the base JDBC profile wizard. Since the DSE is used in a variety of contexts, this may not be the best approach. 

We are working on adding some functionality for filters that would allow extenders and users to add their own filters to customize the view. For example, if you wanted to hide the ODA categories, you could add a filter to the DSE that would do that. Or if you wanted to only see tables and stored procedures, you could filter out all the other assorted object types in the SQL model to minimize the clutter in the view.

Another possibility is having a custom Common Navigator that brings in the DSE content and actions and providing the ability for you to override the look and feel in your own viewer at that point. We have done some refactoring for 1.6 to move the DSE content and action providers as much as possible into connectivity.ui to allow other viewers to pull in that functionality without having to bring in the entire DSE.

So though I think you have some great ideas, I think we need to look at how they can get integrated in an additive fashion. If this functionality is being used extensively in the PHP, maybe a customized DSE view would make more sense. But I think that some of the changes you're suggesting could definitely be worked in as alternatives for adopters/extenders to use if they see the benefits. 

--Fitz
Comment 8 Larry Dunnell CLA 2007-11-19 18:18:06 EST
One of my big concerns is that the wizard appears to bypass the connection profile type selection wizard page.  This means that adopters cannot contribute new connection profile wizards to create SQL connections.

However, there are several features of the wizard that would be very useful for DTP including but no limited to:

1)  Providing a default connection profile name.
2)  Providing a mechanism for populating the jar list at runtime.
3)  Pre-populating driver instances in the wizard.  I'm not sure if it is appropriate to populate them in DTP or just provide a mechanism for adopters to do this.  See:  https://bugs.eclipse.org/bugs/show_bug.cgi?id=202641
Comment 9 Eden Klein CLA 2007-12-17 03:42:58 EST
we opened 2 separate bugs for the features that are not connected to the "quick connection" feature.
(see "depends on" bugs)
Comment 10 John Graham CLA 2008-01-10 12:50:43 EST
Assigning to Brian, since he will drive the Connectivity usability effort in 1.6.
Comment 11 Brian Fitzpatrick CLA 2008-04-23 10:36:43 EDT
Have addressed what we can for Ganymede