SQL Developer v17.2 is now Available.

thatjeffsmith SQL Developer 65 Comments

Tell Others About This Story:

Time to download!

Mostly bug fixes.

  • the frequent ‘connection reset’ message should be GONE
  • entering text data in a data grid cell and the cursor doesn’t advance should be FIXED
  • having a @ or a ; in a comment in your query should work AGAIN
  • many, many more bug fixes – see the release notes for details

Should work for F9 and F5

  • SQLcl updated, more bug fixes
  • ORDS 3.0.10 is included, even more bug fixes + Auto PLSQL feature

Brand New Features

You can search your RESTful Service handler code now using the Database Search panel! View > Find DB Object. Expand Code section. Check ‘ORDS’ – this will search everything in the ORDS Handler P_SOURCE area.

ORDS integration is one of my favorite new features in SQLDev.

Speaking of ORDS, you can now quickly export your ORDS RESTful Service definitions to the clipboard, worksheet, or a file.

Just a ‘touch’ feature, but very handy.

DBA Toys

We have two new items in the DBA panel. We have FX viewers and reports for Data Guard and Sharding.

A very simple setup, but you get the idea.

And, if you right-click you can get into the DG info for the Standby west.dbs2 setup.

 

You don’t have to be running a Sharded 12c database to get the Data Guard support.

Remember When I Told You We Were Changing Up Our Release Schedules/Process?

No? Read this. 

So in about 3 months, we’ll have a 17.3 update. Again, mostly bug fixes, but maybe a few toys as well.

 

Tell Others About This Story:

Comments 65

  1. Hey Jeff,

    I’ve recently updated SQLDeveloper to the latest version (17.3) and I can’t find the formatting options that used to be on previous version (4.0).

    On 4.0, under Preferences -> Database -> SQL Formatter -> Oracle Formatting, there was a drop down menu with profile name (SQL) and an edit button which brings up a screen with lots of options

    https://imgur.com/a/TPGeX

    Now, on the newer version, the formatter seems to have been moved to : Code Editor -> Format -> Advanced format with very less options

    https://imgur.com/a/fesAt

    is that right? I can’t get back my pretty code indentation nor I’m able to import the old settings (I’ve read on a reply above that there’s no retro compatibility) nor I can (since the are few options) to set it
    back as I like.

    BR

    1. thatjeffsmith Post
      Author

      You missed a lot from version 4.1, 4.2, and 17.2. We completely changed the formatter. It’s a few less options, but the options that are there are more reliable.

      Can you show an example of what you are looking for in ‘pretty code indentation?’

  2. Hello, Jeff. Thank you for replying. Unfortunately it is still doing the same. The bblue “loading” bar has not moved a pixel li e since reaching the same location. Not sure what could be causing this issue.

  3. Well, I can’t seem to get passed this screen… I am running 64-bit Windows ( Win10 ), and this software is for my college SQL course. I will never get homework done with this happening. It hangs right at this point for ever. 🙁 Please help!

    https://imgur.com/sJTyzxf

    1. thatjeffsmith Post
      Author

      Ok, this happens from time to time, but we can get you going.

      Open Windows explorer, find your user AppData directory – make sure you tell Windows to show hidden directories.

      Now, go into your os users roaming profiles directory. In there will be a system17.2.X.Y…. sql developer directory. If you’re running version 4.2 it would be system4.2.X.Y…. directory.

      DELETE this directory.

      Restart SQL Developer.

        1. thatjeffsmith Post
          Author
          1. I have 2 issues:
            1- I have to make frequent deletion on SQL Developer 4 for this folder on my machine (I have windows 10 x64) the same incident occurred once again for version 17, and each time I lost my saved connections …

            2- even I try to copy the connections for the new folder it hangs and SQL Developer refuses to restart and go into hang mode.

            Does it have compatibility issue on Windows10

          2. thatjeffsmith Post
            Author

            1 – are you removing the software, if so, how? Exactly what folders are you deleting? Your connections are stored in a connections.xml file. You can always export them and import them when moving machines. Doing upgrades should always bring over the old settings, so install new software and run it before you drop/delete old versions.

            2 – don’t do this, let the software do this for you. what are you doing SHOULD work, but it won’t carry over the passwords for security reasons

            No known issues with Windows10 – i’m running version 17.3.1 with no issues on Win10 today.

    1. thatjeffsmith Post
      Author
  4. Hi
    in 17.2 the code editor displays Hebrew characters in reverse.
    I remember it was like that on some earlier version.
    The characters are displayed in Hebrew but in reverse order like I type ‘abcd’ and it displays ‘dcba’
    (Dont know if you see this -I type ‘אבגד’ it shows ‘דגבא’)
    Changing fonts does not help.
    It worked well in 4.1.3

  5. Hi,
    it’s a very nice tools for oracle and very useful :-).
    I try to use SQLDeveloper for connect Mysql DB too and to connect is very simple (i use mysql-connector-java-5.1.42-bin.jar) but i want to use some features like Edit for modify content for Procedures, Tables and index and the only option enabled is “open” for “preview “objects.

    This is a bug or i need to configure some preferences for enabled this options?

    Thanks for your Help.

    1. thatjeffsmith Post
      Author

      the MySQL connectivity is there to help with Migrations from MySQL to Oracle. If you want an advanced, feature-rich experience, you’ll need to use their MySQL Workbench product

        1. thatjeffsmith Post
          Author
  6. As a DBA I’ve used and loved SD for a very long time – under both Windows and Linux. Just installed 17.2 in an Ubuntu 16.04 VBox guest under Win10 host. One of my problems is that I can’t get the DBA pane to display, along with Connections and Reports on the left. What’s the secret? Also, I successfully imported all my many connections, as well as User Defined Reports, but can’t import my SQL Formatter profile. My last export was in XML and that doesn’t seem to work. Any advice?
    Even with these relatively minor problems I am still a HUGE fan of SD.
    Thanks.
    Jack

    1. thatjeffsmith Post
      Author

      Can you post a screenshot of what your desktop looks like? And ‘draw’ where you want what to go where.

      As for the formatter, we changed that completely, so unless it was a 4.2/17.2 version of the formatter preferences, you won’t be able move them into 17.2.

      1. I can’t seem to paste my Snipping Tool small screenshot into this box. However, all I want is that the pane on the left side of SD have three sections like this…
        Connections
        Reports
        DBA
        …stacked one below the other. I have Connections and Reports, but can’t get DBA to show anywhere. I get it in the SD 17.2 Windows version, but that replaces a 4.2.0.17 version I’d been using, so is not like the fresh SD 17.2 under Ubuntu.
        Thanks.

        1. thatjeffsmith Post
          Author

          Just use something like http://imgur.com/upload and share the link back here. You want your desktop to look like this?

          ‘Pick up’ the DBA panel, drag it to where you want – DO NOT LET GO OF THE MOUSE – until you see SQLDev paint the drop area…you’ll see it go from vertical to horizontal to whatever…just move it around until it gets the idea of where you want it to go.

          1. If I had a DBA panel anywhere, I’d do that. I click on Views / DBA and nothing happens – no DBA panel anywhere. I can close and open Connections, Reports, Cart, SQL History, etc. repeatedly, but clicking DBA does nothing. In 17.2 Windows, the DBA panel can be opened and closed just like the rest. Not under Ubuntu 16.04.

          2. thatjeffsmith Post
            Author
          3. Yup. Reset to Factory Settings worked. Now I can open and close the DBA pane at will. I’ve never had to do that, but now I know how useful it can be.
            Thanks so much for your time and patience!

          4. thatjeffsmith Post
            Author
    1. thatjeffsmith Post
      Author
  7. Hey, Jeff!
    One thing I can not understand, why is it 17.2? There were versions 1.1, 2.1, 3.0, 4.0, 4.1, 4.2 and then… 17.2! Did I miss something? Where did 5.0, 6.2, 12.3, etc. go? Which one going to be the next one, 189.73?
    I know it’s kind of stupid question, but I’m just trying to understand what’s going on with this world.
    Thanks!

    1. thatjeffsmith Post
      Author
  8. Good morning please , I’ve dificult to create new connection with Sqldeveloper version 17.2 ,
    can you help me?

    1. thatjeffsmith Post
      Author
  9. Jeff,

    Great to see quarterly updates to a great tool.

    I ran into an issue on 17.2 that most would not have. I had created custom actions in 4.1.5 & 4.2.x on SCHEDULER->Jobs. These migrated as I have updated version

    Now on 17.2 when bringing up the context menu, right-click, Nothing happened. I dropped my custom action and restarted SQL Developer. The now work as expected. The fact that my custom code failed is not a SQLDEV issue, Not giving a better error my code was broken, maybe.

    BTW the most important part of my code was running jobs is no longer needed. Thanks

    1. thatjeffsmith Post
      Author
  10. Code outline still shows a red dot (and no outline) for some large packages.

    community . oracle . com / thread / 4053955

    I’m staying on 4.1.5 for the time being.

  11. Hi Jeff,

    Any way we can enable DG in DBA panel without DG broker enabled? Our client current setup doesn’t uses the DG broker in 11g due to the need to use SYS password , and in our case sys password is not being used to due to security concerns, please advise 🙂

    1. thatjeffsmith Post
      Author
  12. While connecting to a database where DG is configured and logging in with SYS user, still unable to see DG icon under View > DBA…

    1. thatjeffsmith Post
      Author
        1. thatjeffsmith Post
          Author
          1. thatjeffsmith Post
            Author
    1. thatjeffsmith Post
      Author
  13. I noticed 17.2 also fixes a small issue I was having on Windows 10. On previous versions (4.1, 4.2) when I pinned SQL Developer to the task bar and then opened it I would get 2 SQL developer Icons on the task bar.

    In 17.2 I just get 1. I guess this could also be from the updated JAVA version it ships with.

    And no “Your connection has been reset” messages so far.

    Nice – I Like it!

    1. thatjeffsmith Post
      Author
      1. Hi Jeff,

        I’ve recently moved from a Windows 7 machine to a Windows 10 one and I had to install everything from scratch (including the Oracle client, SQL Developer and JDK). I’m noticing a lot of disconnections (I would say an average of every 5 minutes). It doesn’t matter if I leave the machine in an idle status, if I work with SQL Developer, or if there is an active SQL query running. Every time the connection drops.

        The following software versions have been successfully installed (no errors during
        the installation process):
        – SQL Developer 17.2.0.188 Build 188.1159 (64bits).
        – Java version “1.8.0_144” (64bits).
        – Oracle Client Release 12.1.0.2.0 (64bits).

        SQL Developer is configured to use Oracle Client (Tools -> Preferences -> Database: Advanced: Use Oracle Client (checked and the path to the oracle client was provided).

        It’s been 3 months since you’ve posted your reply and you seemed optimistic at that time, so I wonder if I am an isolated case and I need to search for answers in some other place (antivirus, firewall, network card, etc) or maybe this issue has been raised by many other users in the meanwhile and it is already on your plate.

        I must add that:
        -> there is a Logging Page that pops up every time I run a query or compile a stored procedure/package/etc. I’m not sure if this is the expected behavior. BTW, is there anything I can do to permanently hide that Logging Page? (sorry to bring two problems in the same reply). The Logging Page contains a LOT of errors, I’m listing here just a few:

        – SEVERE 13000 1853252 oracle.dbtools.worksheet.commands.scriptrunner.task.DBCommandRunnerTask oracle.net.ano.CryptoNIONSDataChannel.readDataFromSocketChannel(Unknown Source)
        – SEVERE 7150 3646 oracle.dbtools.raptor.utils.DBObject Could not get schema Object:java.lang.NegativeArraySizeException
        – SEVERE 5144 1455291 oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$1 232 at oracle.dbtools.parser.Matrix.get(Matrix.java:35)
        – SEVERE 12559 13438 oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$1 *******@****** expired 971895us ago at oracle.ide.model.ExpiredTextBuffer.newExpiredTextBufferException(ExpiredTextBuffer.java:73)

        -> no other software except SQL Developer has connectivity issues on my machine.
        -> SQL Developer used to work just fine before this new setup.
        -> I started using SQL Developer a long time ago (since it was called Raptor) and I LOVE IT!!! I’m a big fun of it.

        Thanks,
        Justin

        1. thatjeffsmith Post
          Author

          Those errors are stop, do not pass go, types of messages. You should open a Service Request with My Oracle Support.

          Two things:

          1. why do you need an instant client? If you disable thick connection, does this still happen?
          2. can you try a 12.2 instant client? 12.1 is already…old. And 17.2 uses a 12.2 JDBC driver
          1. Thanks, Jeff!

            Actually, after ENABLING think connection (it was disabled before), and after installing a 12.2. client (full client, not only the instant one) SQL Developer became stable. No errors in the last 3 days, not a single error!

  14. Windows Defender SmartScreen won’t allow sqldeveloper.exe to execute.

    Running Windows 10 with administrator privileges, I unzipped the files to a directory and double-clicked the .EXE. Defender immediately displays a dialog stating “Windows Defender SmartScreen prevented an unrecognized app from starting. Running this app might put your PC at risk.” Clicked on the “More Info” link to display the “Run anyway” button, then clicked it.

    Windows then displays a dialog “Windows cannot access the specified device, path, or file. You may not have the appropriate permissions to access the item”.

    After clicking “Ok” (the only button available), sqldeveloper.exe is removed from the SQL*Developer directory.

    Any ideas? I’m a Linux/Unix guy, not a Windows person.

    1. thatjeffsmith Post
      Author

      Nope, we didn’t change anything with the EXE.

      >>Windows then displays a dialog “Windows cannot access the specified device, path, or file. You may not have the appropriate permissions to access the item”.
      Where did you extract SQLDev to?

      1. I extracted to C:\Oracle\SQLDeveloper 17.2, which is a sibling directory to the 4.1 and 4.2 installs that work for me.

          1. thatjeffsmith Post
            Author
  15. I have downloaded sqlcl 17.2.0.184.1230 but version showed by running executable is not exactly the same:

    SQL> show version
    Oracle SQL Developer, comandos (SQLcl) versión: 17.2.0.184.0917

    Is this a simple mistake in the version showed?

  16. Hi,

    The bug while printing a ref_cursor, with linesize set to max and sqlformat to ansiconsole remains!

    var rc1 refcursor;

    BEGIN

    open :rc1 for
    select * from TABLE;

    END;
    /

    print rc1;

    1. thatjeffsmith Post
      Author
    2. thatjeffsmith Post
      Author
        1. thatjeffsmith Post
          Author

          No, what I’m saying is, it’s not a bug without a bug ID from My Oracle Support or if you have a reference/test case on the forums and someone on our team has told you it’s a bug.

Leave a Reply

Your email address will not be published. Required fields are marked *