Pin / Unpin Connection with Windows 7

[Jurivamo]

Hi everyone,

We have a problems with this option(pin/unpin connection). We think is not OK with Windows 7 system.

Any solution?.

Thank you so much.

Best Regards.

Juan.

 

[Jurivamo]

Sorry, Below my configuration:

PL/SQL Developer
Version 10.0.5.1710
18.82201 - 10 user license
Windows 7 (64-bit) 6.1 Build 7601 (Service Pack 1)

Physical memory : 3.128.636 kB (1.512.100 available)
Paging file : 4.194.304 kB (4.194.304 available)
Virtual memory : 2.097.024 kB (1.902.376 available)

Parameters
C:\Program Files (x86)\PLSQL Developer\plsqldev.exe

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False
Allow Multiple Connections: True

Preference Files
C:\Users\jpachon\AppData\Roaming\PLSQL
Developer\Preferences\default\Default.ini
C:\Users\jpachon\AppData\Roaming\PLSQL
Developer\Preferences\jpachon\default.ini

Plug-Ins
*Active Query Builder (C:\Program Files (x86)\PLSQL
Developer\PlugIns\ActiveQueryBuilder.dll)
*PL/SQL Documentation (plsqldoc) (C:\Program Files (x86)\PLSQL
Developer\PlugIns\plsqldoc.dll)
*Version Control Interface 1.2 (C:\Program Files (x86)\PLSQL
Developer\PlugIns\VCS.dll)
(* is Active)

Aliases
CESTRACK
DESTR0
DESTR0_1
DESTR0_2
DESTR0_3
...

Homes
OH480220306 (C:\oracle\product\11.1.1\as_1)

DLLs
C:\oracle\product\11.1.1\as_1\bin\oci.dll

TNS File
C:\oracle\product\11.1.1\as_1\network\admin\tnsnames.ora

Using
Home: OH480220306
DLL: C:\oracle\product\11.1.1\as_1\bin\oci.dll
OCI: version 11.1
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0

Character Sets
Character size: 4 byte(s)
CharSetID: 873
NCharSetID: 2000
Unicode Support: True
NLS_LANG: SPANISH_SPAIN.WE8MSWIN1252
NLS_NCHAR_CHARACTERSET: AL16UTF16
NLS_CHARACTERSET: AL32UTF8
.

 

[Marco Kalter]

What exactly goes wrong?

 

[Jurivamo]

Hi Marco,

If we have two connection simultaneously, one of this with two sql window, each one has the option(pin) disabled, all windows don't move to the other connection window when you press it with double click.

Thanks.

Best regards.

 

[Jurivamo]

Hi Marco,

We have deleted all configuration, and now it's ok.

Thanks for your time.

Best Regards.
Juan.

 

[AWegierski]

There's no possibility to change window connection pin state with one-click using buton or context menu. In conjunction with no possibility to change all windows connections using one-click it's the most iritating property of PL/SQL Dev in versions above 10.x

 

[Hilarion]

Not sure what you mean by "one-click using button". Are you referring to a keyboard buttons? If so, you can define a keyboard shortcut in Tools / Preferences / User Interface / Key configuration. It's called "Window: Pin connection" (scroll down to the bottom of the list and then a bit up).
If you mean one click of a mouse, than it's possible - just click the pin icon in the status bar of a window.

In regard to changing all windows connections, you have at least three options:

• Change your preferences to have all the windows created as unpinned, then all windows will change their connection to the main one when the main connection is changed (unless you switch a connection for a specific window, which causes that window to get it's connection pinned, so you would have to unpin it).
• Completely switch off the multi-connection feature, so the application has only a one connection active and all the windows are always connected to it.
• There is a plugin (I can recall it's name) that introduces additional connection management options, which included a menu item (and keyboard shortcut) to switch connections of all wintows to the main one.

 

[AWegierski]

No, no. I usually use about 15 windows and 9 databases, so I always make some errors while reconnecting them... Maybe plugin will be helpful for me. Thx.