Session reconnect problem when sql windows opened

[blogin]

Hello,

I noticed new behavior of the PLSQLDev v.9 which is quite dangerous to me. Given that I have PLSQLDev with some SQL windows opened, logged-on to production database. Then I relog to the test database. After that all windows are still logged-on to Production database which is not obvious after using "Session->Log off" before. This leads to mistakes and executing sql queries on a production database rather than on the test.

Is that a designed behavior and if so, is there any possibility to re-login to another connection in that way, that it will relate to all open windows ?

Thanks,
Bertrand

 

[Marco Kalter]

Version 9.0 added support for multiple simultaneous connections, where each window or tool can have its own connection. If a Window is connected as user A, changing the PL/SQL Developer main (default) connection to user B will not affect this window. The main connection is displayed in the main window title. The individual window connections are displayed in the status bar of that Window. To change an individual Window connection, click on the connection name in the status bar of that Window and select a different connection or "Other".

To revert to 8.0 behavior, go to Tools > Preferences > Oracle / Connection and disable the "Allow multiple connections" option.

 

[adler5]

I think you should remove the user@database text from main window and show only user@database on status bar on each Window as it is now.

Regards
Mike

 

[Roeland]

This "multiple connection" feature is maybe nice for some of us, but I find it dangerous and have disabled it.
So, I think that the 8.0 behavior (=NO multiple connections) should be the default.

Regards,

Roeland

 

[blogin]

Thanks for the tip concerning tunrning off multiple connections.

If I may, I would say that the functionality of multiple connections should consider the user's habits of previos versions, just to avoid confusion which I (probably not only I) experienced. For example, I'm often using the drop-down list bound to the "Log on" button to switch to a different database, along with all the sql windows opened. Now, with "multiple connections" enabled it is no longer possible - I need to reconnect each one window manually. I think that much better bahaviour would be if there were a question "Do you want to reconnect all windows opened ?" in this case. Similarly: if I execute "Session->Log off->All" I would rather expect that this concerns all windows opened, and if I choose "Session->Log on" after that, it will pinn a new connection to all windows, which in the meantime shuld be connectionless.

The functionality of multiple connections can be so useful that it would no be good if most of users switch it off just because it requires intensive attention to avoid expensive mistakes.

Kind regards
Bertrand