SQL Developer Dropping Connections – Solved

I work fast, most often across several database at once, multitasking across projects. Recently with one client I noticed SQL Developer dropping connections, repeatedly, but only on certain database connections. Most often I would need to reconnect upon opening a table or view, package, trigger, almost any object from the navigator. After successfully compiling something, need to reconnect. After creating a trigger, reconnect. Forget about an After-Update trigger – that visibly disconnected me – so I got in the habit of creating things outside of SQL Dev.  Wait a minute..that’s just wrong. I knew this had to be something easy to fix.

That’s when I started looking … After a bit of research I found this link :

Brendan Tierney – Oralytics Blog: SQL Developer is dropping connections

which explained my problem – and offered a solution:

The solution (since that’s what you care about):

Add this line:

AddVMOption -Doracle.net.disableOob=true

to the sqldeveloper.conf file.

I actually added mine to the sqldeveloper_nodebug.conf file.

For SQL Developer 4.1, for my install on Windows 7, this falls in the …\sqldeveloper\bin\ directory for the SQL Developer install directory.

The problem (the short version):

The theory is that this is being caused by and Out of Bands (OOB) error in the jdbc driver or on the network.  Whatever the error, jdbc driver or network, the constant need to reconnect was rendering SQL Developer almost useless for those connections for which this occurred.   It is not doing that any more – Yeah!

I do expect that this option will block times when SQL Dev should disconnect – so I am paying attention and watching for side effects.  So far, so good.  Hope this helps someone else,


KScope 14 Wrap-up – APEX 5 Highlights


I am just back from KScope14 in Seattle, WA – what a week. No “Low-T” here!

APEX 5.0 Early Adopter 2 was featured on Sunday by the Oracle APEX team, after which I was able to complete prep for my APEX Interactive Reports, The Good, The Bad and The Ugly, Revisited.  I demoed APEX 5 IR new features, including multiple IRs on a single page with links between those reports – we now have a simple way to quickly generate dashboard-like layouts.  The big news with IRs in APEX 5 is Change – there is a new scheme of classes and Id’s for the IR elements – the old apexir_* set are gone.  There is completely new jQuery widget that controls IRs – sooooo… any custom code – dynamic actions, plugins, javascript, whatever – that does not use the standard API’s will need to be refactored.  I’ll be posting more in APEX 5 Interactive Reports in the coming week.

There were many highlights – APEX 5, great sessions, an awesome party at EMP, great people.  A standout for me was seeing Mike Riley there, smiling, and receive the ODTUG Volunteer of the Year Award – Congratulations Mike!  To read more about Mike Riley, and his journey in life and with ODTUG, see the ODTUG Technical Journal Corner.Volunteer Spotlight by John King.

While there check out two articles on SQL Developer – one by Jeff Smith, on making your job easier with SQL Developer, and one from Galo Balda, Using SQL Developer to Work With GitHub.  Great stuff, by two great people.