Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

21.2.1 under Windows 10 may hang while doing drag&drop from the Windows Explorer

user_2DKLAAug 18 2021

Hi,
The latest SQL Developer 21.2.1 (Windows 64-bit with JDK 8 included) may hang when drag-and-dropping a file from the Windows Explorer. Both SQL Developer and the originating Explorer window freeze as a result.
Screenshot:
sqldev-21.2.1-hang.pngThe freeze happens while dragging the file-to-opened (which doesn't have to be a package BTW), even before releasing the left mouse button: the whole action gets hopelessly frozen in the middle as shown above, and then there's nothing left to do but kill the SQL Developer process—which also unlocks the originating Windows Explorer.
This seems very easy to reproduce (at least now, and on my workstation) using 21.2.1, but not using 20.4.1.
Tested on:
Windows 10 Professional, release 20H2
And if that counts: dual monitor configuration, with the Windows desktop extended over the 2 monitor screens
Sample thread dump:
full_thread_dump.txt (22.79 KB)Conditions:
A condition for the freeze to happen seems to be that the originating Windows Explorer window does not have keyboard focus, while the SQL Developer window has it, as shown in the above screen shot: even though the keyboard focus is in the SQL Developer window, the Windows Explorer in the background reacts to mouse inputs, and it is happy to let the mouse initiate a file drag & drop action.
On the contrary, if the originating Windows Explorer window has the keyboard focus—and all it takes is 1 mouse click in that window—the freeze does not seem to happen.
Therefore:
Work-around: click in the originating Windows Explorer (to ensure it has keyboard focus) before doing the drag & drop to the SQL Developer window. This adds 2 mouse clicks to the whole maneuver: 1 to give focus to the Windows Explorer window, the other to give it back to SQL Developer, but it's not as bad as a frozen SQL Developer.
Regards,

This post has been answered by thatJeffSmith-Oracle on Aug 20 2021
Jump to Answer
Comments
Post Details
Added on Aug 18 2021
4 comments
718 views