I'm able to execute queries while not being "logged on"

[Roeland]

Hi,

- Version 9.0.2.1621
- Multiple Connections: Unchecked

The Problem:
------------
In the evening, when I go home, I sometimes forget to disconnect from our developers database.
Every night this database is shutdown, backed up and then restarted.

1) The next morning I see that PL/SQL Developer is logged off. I assume without errors because I don't see any message boxes. Is this the desired behavior?

2) When I open a new SQL-window, I'm still being able to execute queries, but the application is still mentioning that it's logged off?!?

The Test:
---------
I have tried to reproduce this behavior in the working hours, and these are my findings:

1) When the DB is shutdown, after some time PL/SQL Developer automatically indicates that the connection is logged off by changing the application caption. Does the application knows (or can it know this?) that the Database is shutdown or is it just losing it's connection? Is it normal that we don't receive any other mention, like a visual clue, for this occurrence?

2) I have waited, but I couldn't reproduce the executing of queries while being disconnected (or so it says). It's no dream though, because I have still 1 instance running in "Logged off" mode where I can execute queries.

Kind regards,

Roeland

 

[Marco Kalter]

1) The next morning I see that PL/SQL Developer is logged off. I assume without errors because I don't see any message boxes. Is this the desired behavior?

If the "Check Connection" preference is enabled, then this is indeed expected. PL/SQL Developer will log off when the server is no longer available.

2) When I open a new SQL-window, I'm still being able to execute queries, but the application is still mentioning that it's logged off?!?

That is not by design. We'll fix it.