5 Replies Latest reply on May 28, 2015 6:43 PM by Gary Graham-Oracle

SQL Developer v 4.1 - Freeze/ No response after clicking Add Connection

skrishnan May 26, 2015 8:01 PM

I downloaded JDK 8 and then unzipped using these instructions (java - How can I get the latest JRE / JDK as a zip file rather than EXE or MSI installer? - Stack Overflow)

I downloaded SQL Developer v 4.1 and unzipped it and then clicked on sqldeveloper.exe, and gave the JDK path.

Window opened up. I tried adding a DB connection by clicking on the green Plus + symbol. The window freezes after about 15 seconds, and then there is no response. I then have to kill using the Task manager.

If i dont click on the + Connection, then the window works ok - as in I can click on the menus, check for updates etc. The moment I click on + Connection, the window freezes. Attempted multiple times with the same behaviour.

Has anyone else experienced the same ? Any fixes ?

Message was edited by: skrishnan - attached debug info

sqldeveloper_debug_info.txt.zip 2.9 K

1. Re: SQL Developer v 4.1 - Freeze/ No response after clicking Add Connection

Gary Graham-Oracle May 26, 2015 8:01 PM (in response to skrishnan)

Why not try to collect some debug information to see if the non-standard JDK install is causing the issue?
http://www.thatjeffsmith.com/archive/2012/06/how-to-collect-debug-info-for-oracle-sql-developer/
Like Show 0 Likes(0)

Actions
2. Re: SQL Developer v 4.1 - Freeze/ No response after clicking Add Connection

skrishnan May 26, 2015 8:02 PM (in response to Gary Graham-Oracle)

Hi Gary,

Attached the debug info to the original post as requested.

Regards,

S. Krishnan
Like Show 0 Likes(0)

Actions
3. Re: SQL Developer v 4.1 - Freeze/ No response after clicking Add Connection

Gary Graham-Oracle May 26, 2015 9:17 PM (in response to skrishnan)

Well, the full thread dump does not shed any light on this. Possibly the way you installed the JDK could be an issue, not really sure.

Here is a recent post on a somewhat similar issue someone had (but on a Mac):
[4.1] SQL Developer can't add connection, connection panel empty

It should get investigated, so I would keep an eye on that discussion for additional suggestions. Otherwise, the standard suggestion for this sort of thing is to...
1. Try running the application as Administrator
2. Try renaming the user settings folder, then restart SQL Developer, possibly skipping the migrate user settings step.

That folder, for Windows Vista and other recent Windows releases, will be something like...
C:\Users\<youruserid>\AppData\Roaming\SQL Developer\system4.1.0.19.07, where AppData is a hidden folder.
Like Show 0 Likes(0)

Actions
4. Re: SQL Developer v 4.1 - Freeze/ No response after clicking Add Connection

skrishnan May 28, 2015 5:30 PM (in response to Gary Graham-Oracle)

I have an update - I noticed on the task manager that the exe was running and consuming CPU, so I waited... and after 20 mins the Connection window opened up. I was then able to add the DB connections.

After closing the app and then opening it again, on clikcing the + Connections the delay was ~1 min, and the Add connections window opened up after that. So really good progress!

Any idea when a download with JDK 8 integrated would be available ?

Regards,
S. Krishnan
Like Show 0 Likes(0)

Actions
5. Re: SQL Developer v 4.1 - Freeze/ No response after clicking Add Connection

Gary Graham-Oracle May 28, 2015 6:43 PM (in response to skrishnan)

Any idea when a download with JDK 8 integrated would be available ?

I believe the plan is to include a JDK 8 for the 64-bit Windows download in an upcoming 4.1.1 full patch release (not a Check for Updates patch). The policy is not to announce release dates, but you'll see it here first on this forum.
Like Show 0 Likes(0)

Actions

Go to original post