Connection of unshared worksheet created by utPLSQL extension stays open after closing worksheet

[PhilippSalvisberg]

If in the preferences "Open an unshared worksheet?" is checked, then a unshared worksheet is opened for every "Run utPLSQL test" call. So far so good.

When this unshared worksheet is closed, the connection stays open in the background. Even "Disconnect" is issued from Connections navigator tree on various levels.

[PhilippSalvisberg]

Using a temporary connection instead of a private connection seems to solve the problem. However, temporary Connections are a newer concept. They have been introduced in SQL Developer 17.4.0.

Fixing this issue by breaking compatibility to SQLDev versions < 17.4.0 seems wrong.

Further investigation is required.

[PhilippSalvisberg]

Looks like the behavior of private connections changed in SQLDev 17.4.0. Solution is to use private connections in older SQLDev versions and temporary connenctions in newer SQLDev versions. Newer = 17.4.0 and higher.