So someone asked us on Twitter this morning about a new Document that opens on an Export of a query result set.
How can I prevent the "Export Tool" log in SQL Developer 18.3?
I get it whenever I create some DDL over the navigation menu.@oraesque @OracleSQLDev #sqldeveloper pic.twitter.com/8zyfquqxZ6
— Tobias Arnhold (@tobias_arnhold) November 15, 2018
The short answer is, that wasn’t intentional – it’s a BUG. Good news – we HAVE cleaned that up for version 18.4.
But, what exactly are we doing for 18.4?
Kill All the Bugs
For this version, it will just include bug fixes – no new features. So for Holiday Season, you can expect the most stable and reliable version of 18.
So to fix the aforementioned bug, we will write notes on doing things like database copies, exports, etc – in a new Utilities log panel. You won’t see this unless you have opened the Log panel, so it won’t be intrusive. Plus, you’ll see how long it took for us to do something, and if we spit out a file, we’ll include links to make them easier for you to open.
Several releases ago we had to disable a popular feature, due to performance issues when working with larger code blocks – Breadcrumbs.
Well, I’m happy to report we’re working to bring that back. It’s apparently ‘wicked fast’ now, and it’s getting the info from our Abori parser, which you can see in the Code Outline.
So, some of the bug fixes will result in improved features – we have a list of things that are getting added to our Real Time SQL Monitoring Reports for example, so it should offer quite a it of value over just saying ‘we close a ton of bugs.’
Also, I’m not sure we can get to Zero published/known bugs for version 18.4, but that’s our goal!
Please contact your My Oracle Support rep on any open bugs or service requests you want updates on.
Required Legal Notice
I reserve the right to change my mind, and please don’t make a buying decision based on what I’ve said above – even though SQL Developer is practically free.
Just updated SQL Developer 18.4. Whenever I run any statement ex. Update / Dbms_output I see strange characters in Script Output.
Below is the sample I receive for Update
0 rows updated.
Do I need to change any settings?
what editor font are you using?
Droid Sans Mono. Default one. I did not change it.
We are now in 2019, and 18.4 is not released yet. Will it become 19.1 instead? Thanks in advance.
It’ll be out soon. As 18.4
What is with the licence cost for the Java platform SQL Developer is using.
Is the Java platform of the included Java free of charge or is a licence required to pay?
Current Oracle Java 8 is free.
When necessary we’ll move to OpenJDK.
I hope you guys will not forget about bugs in SQL Editor code templates !
Wasn’t sure were to put this, so I’m dropping it here.
I just upgraded from 18.2 to 18.3 and noticed the XML to JSON conversion of o.jdeveloper.db.connection\connections.json inserts an incorrectly formatted customURL property for TNS connections. Specifically it inserts an unnecessary client string “jdbc:oracle:oci8:@”, when all that is needed is just the TNS name. The lazy onetime workaround is to connect the first time via the connections properties window, which overwrites the customURL property in o.jdeveloper.db.connection\connections.json.
Not a major problem, just a bit annoying, but understandable given how brittle converting between XML and JSON can be.
Will we be able to import connections.xml files from an older SQL Developer export? I have a large file I want to import after recently having to re-image my MacBook.
yes, that was broken going from 18.2 to 18.3 – 18.4 won’t be a problem
if you grab 18.2 and import your connections, you should be fine…and then run 18.3 and move over – sorry for the inconvenience here
The comment about 18.4 being all about “bug squashing” just made my day. SQL Developer is something I use every day, and there are so many releases where the new version is so buggy, I can’t use it, and I have to go back to using an older version. Please keep up the bug-squashing…. Doing this (rather than rolling out new features) will make a significant portion of your users happier I believe (I know I’m speaking for most, if not all the SQL Developer users at my company…they would rather see annoying bugs removed rather than new features added).
Any particular annoying bugs you want to go away or are suffering from the most?
Absolutely! I’d love to send some screen shots. I don’t think I can readily do that here. What’s the best way to do something like that? Email? LinkedIn messaging?
You’re technically paying for it when you buy the database license(s) – but we would never charge you specifically for just SQL Developer.
I make the distinction between a ‘no-cost option of the database’ and ‘free’ because you actually get access to My Oracle Support for SQL Developer via your database contracts.
I hope my answer didn’t muddy the waters further!
But there are no licensing issues with using SQL Developer with the XE version of the database, correct?
As long as you’re not using it to build weapons of mass destruction – you’re good!
Aw, now you took all of the fun out of it! What is the cost if I want to do that?