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 118782 - Unable to connect if you have saved the password and the the database password has changed
Summary: Unable to connect if you have saved the password and the the database passwo...
Status: RESOLVED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 6.x
Hardware: Macintosh All
: P3 blocker (vote)
Assignee: David Vancouvering
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-10-13 05:00 UTC by David Vancouvering
Modified: 2007-11-01 04:44 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description David Vancouvering 2007-10-13 05:00:46 UTC 
Scenario:

- Save password
- Administrator changes the password on the database
- You try to connect, it fails, and you don't get the Connect dialog so you can change the password

The workaround is to go to the Properties... choice for the connection and disable 'Save Password'  Now you can try to
connect, get the connect dialog, and change the password.
Comment 1 Andrei Badea 2007-10-22 16:30:50 UTC 
*** Issue 119665 has been marked as a duplicate of this issue. ***
Comment 2 David Vancouvering 2007-10-25 18:07:41 UTC 
I think there are two separate issues here:

- The password or other information is changed on the server, and the connection information that is saved in NetBeans
is no longer valid.  The result will be the connection fails.  In this case we should bring up the Connect dialog and
let the user change the information.

- The server hasn't changed, but the developer wants to change something, like the schema or the user.  In this case we
have to allow the user to make these changes without having to bring up the connection dialog.  The right approach IMHO
is to create a better properties sheet that has the standard stuff you may want to change in a user-friendly dialog much
like the Connect dialog, with an [Advanced] tab for viewing/setting advanced properties.

This is actually similar to the idea Andrei had about creating a better New Connection dialog that has the properties
separated out rather than embedded in the URL.

I will work on fixing the first issue, where the connection fails and we need to bring up the Connect dialog.  The
second issue needs to be tracked separately as a feature enhancement.

Note that for 119665 you can also edit the schema directly in the properties sheet, but you had better know the schemas,
because it doesn't give you a drop-down list.  I'll add that to the comment.
Comment 3 David Vancouvering 2007-11-01 04:43:17 UTC 
Fixed, db/src/netbeans/org/modules/db/actions/ConnectionAction.java, revision 1.50
Comment 4 David Vancouvering 2007-11-01 04:44:14 UTC 
Sorry, that's ConnectAction.java, not ConnectionAction.java