Unwanted connection

[Maxmix]

Hi!

Given:
Plsqldev v.9.0.1
Multiple connections: false

I am trying to start the app without making any connection.
To achieve this, I double-click shortcut - connections tree is presented. I click on the Cancel button.

However, the some connection is established, which I can see in window title, and also if I open new CommandWindow:

Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.5.0
Connected as Tangibles@nOVOSIB

SQL>

Even worse: I can 'Log off', and window title now displays:

(Not logged on)

, BUT: Any command window is created connected as the same 'Tangibles' user.

What's going on?

 

[Marco Kalter]

Have you enabled the "AutoSave Desktop" preference? If so, it can be that even if you do not connect during startup, the restored windows will connect with their original connection.

 

[Maxmix]

Yes and yes.
But it is confusing and something new behavior.
And with new windows... what is their "original connection"?
With 'Allow Multiple Connections' set to FALSE, it is unclear to me, what the "original connection" is.
It's also unclear, why _new_ Command-windows have some implicit connection, but Sql-windows don't (or I am unaware of it: though 'Execute' button is disabled in all windows, but in Command window I can just type 'select * from dual;' and press ENTER - query will be executed.)
And... this connection is fully invisible.
Please restore the behavior like PSD v.8 had.

 

[Maxmix]

Addition, which might appear important: query to v$session lists some sessions with action 'Primary Session'

Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.5.0
Connected as shal@egp

SQL>

MODULE                                           ACTION                           LOGON_TIME
------------------------------------------------ -------------------------------- -----------
PL/SQL Developer                                 Command Window - New             16.09.2011
PL/SQL Developer                                 Primary Session                  16.09.2011
PL/SQL Developer                                 Command Window - New             16.09.2011
PL/SQL Developer                                 Primary Session                  16.09.2011
PL/SQL Developer                                 Command Window - New             16.09.2011

SQL>

 

[Marco Kalter]

We'll check it out.

 

[Maxmix]

I am observing new troubles, which I believe, are related to the original problem.

Let's make the following actions:
1) Connect as UserA, which has DBA role.
2) Execute any query in SqlWindow and go to Statistics tab: statistics is displayed.
3) Reconnect to the same or another (cloned) DB, as the same UserA.
4) Execute the same query and go to Statistics tab: statistics is absent (please see screenshot

). In addition, before query executes, the warning dialog opens (please see second screenshot

)
5) To get the statistics back, I should first Log Off, then Log on again as UserA. Simple reconnect is not enough.

We are still on 9.0.1 with multiple connections set to false.

 

[Marco Kalter]

We'll check it out.

 

[Marco Kalter]

This should be fixed in this version.