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 119665 - Need abillity to change database schema after authentication.
Summary: Need abillity to change database schema after authentication.
Status: NEW
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 6.x
Hardware: All All
: P3 blocker (vote)
Assignee: Libor Fischmeistr
URL:
Keywords:
Depends on:
Blocks: 152818
  Show dependency tree
 
Reported: 2007-10-22 16:12 UTC by rptmaestro
Modified: 2013-09-04 08:22 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 rptmaestro 2007-10-22 16:12:00 UTC
The user needs a way to change the database schema after connecting with "Remember password" checked.

To illustrate the need for this feature, do the following:
1. Create a database connection (I'm using an Oracle DB connection, in case that matters)
2. When the "Connect" dialog comes up, enter the username and password and check the "Remember password" checkbox.
3. Pick a schema on the "Advanced" tab.
4. Click "OK"

Notice that there is no way to change the schema after connecting with the "Remember password" checkbox. Even
disconnecting  won't allow this. The user has to end his NetBeans session.
Comment 1 Andrei Badea 2007-10-22 16:30:58 UTC
See the workaround in issue 118782.


*** This issue has been marked as a duplicate of 118782 ***
Comment 2 David Vancouvering 2007-10-26 20:22:32 UTC
Re-opening, it's a slightly different problem than 118782.  In 118782, the server changes somehow, and the connection
information saved in NetBeans is no longer valid.

In this case, the developer wants to change the schema from a drop down, and it's not clear how because you can't get
back to the Connect dialog.

There are two workarounds.  The first way is to uncheck "Remember Password" in the Properties sheet and then connect. 
The other way is to change the schema in the Properties sheet, rather than in the Connect dialog.  This isn't the *best*
way, because you don't get a drop-down list of schemas and you have to know what your schema names are.

So I'm opening this as a future enhancement where we look to see if there is a better way to do this.
Comment 3 Jiri Rechtacek 2009-10-16 14:04:44 UTC
Reassigned to new owner.