Your #1 Reason for Upgrading SQL Developer to Version 4.2

thatjeffsmith SQL Developer 22 Comments

Tell Others About This Story:

Password resets.

It used to be a pain – it required installing and configuring an Oracle client.

But, no more!

Simply get version 4.2, and you’re good to go.

Here’s the video.

So go get version 4.2 already.

Tell Others About This Story:

Comments 22

  1. i am getting error every time I am connecting to my database in sql developer app.
    Your database connection has been reset. Any pending transactions or session state has been lost.

  2. I have upgraded the SQL Developer on macOS.
    I can’t connect to my database anymore. Every time I try to connect, I get this message:
    “Your database connection has been reset. Any pending transactions or session state has been lost.”

    1. thatjeffsmith Post
      Author
      1. I have found that SQL Developer 4.2.0.17.089 is un-useable for databases that are not local to my machine. Always getting a “Reconnect” window with the error “Your database connection has been reset. Any pending transactions or session state has been lost.”. The query results window will show “Closed Connection”. I cannot execute any command without the error being thrown.

        When I attempt to open the connection node in the Connections window, I get a “Error Connecting” window showing “An error has occurred. Click Details for information that may be useful when diagnosing or reporting this problem.” The Exception Stack Trace:
        java.lang.NullPointerException
        at oracle.dbtools.raptor.navigator.db.xml.NavigatorHook.getConnectionType(NavigatorHook.java:252)
        at oracle.dbtools.raptor.navigator.ObjectFactoryRegistry.createFactory(ObjectFactoryRegistry.java:164)
        at oracle.dbtools.raptor.navigator.ObjectFactoryRegistry.getFactory(ObjectFactoryRegistry.java:153)
        at oracle.dbtools.raptor.navigator.db.impl.DatabaseTreeNode.getObjectFactory(DatabaseTreeNode.java:91)
        at oracle.dbtools.raptor.navigator.db.impl.DatabaseTreeNode$LoadTask.doWork(DatabaseTreeNode.java:145)
        at oracle.dbtools.raptor.navigator.db.impl.DatabaseTreeNode$LoadTask.doWork(DatabaseTreeNode.java:119)
        at oracle.dbtools.raptor.backgroundTask.RaptorTask.call(RaptorTask.java:193)
        at java.util.concurrent.FutureTask.run(FutureTask.java:266)
        at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask.run(RaptorTaskManager.java:629)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        at java.util.concurrent.FutureTask.run(FutureTask.java:266)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at java.lang.Thread.run(Thread.java:745)

        The connection works fine in SQLPlus on the same system. Any assistance would be appreciated.

        1. thatjeffsmith Post
          Author

          it’s not local or remote databases – it’s a bug based on the new jdbc driver

          you can:
          a)configure thick connections – the bad behavior will immediately go away
          b)wait for our upcoming patch where we’ll have this fixed

          Sorry for the inconvenience, I thought we had this taken care of for the release, but this somehow slipped through the cracks.

  3. This is very good news, I cannot stress enough on how common users hate to use sql*plus just to change expired passwords (because thin driver did not support that mechanism)…
    It would be even better if you could catch ORA-28001 and instead of showing this error (or showing some more user-friendly message) run this form automatically, so the poor users won’t have to bother helpline wondering what to do with it.
    Regards,
    Piotr

    1. thatjeffsmith Post
      Author

      I’m not sure the driver supports it, but we can see what we can do. I know this doesn’t sound like a ‘sexy’ reason for most, but for rank and file IT folks, definitely is a much nicer setup now.

  4. Hello, I’m testing SQLDeveloper 4.2 but I don’t see the contextual menu for ‘Advance Format’… All ways I use for change my select code from PLSQL to JAVA… Where I can found in this version?.

    Thanks Jeff

    1. thatjeffsmith Post
      Author
      1. Thanks Jeff… last question, in 4.1x we can to format in many formats for Java…now I’m seeing just one way to format for Java.. Do you know if we as a user we can add more Java formats in Preferences?.

        Regards,

      2. Similar question to Mauricio… I often used the “advanced format” feature to format code for VB.NET. Now with 17.2 I’m only seeing options for Java, Python, and PL/SQL. Is there any way we can add a custom format?

  5. I installed 4.2 and suddenly I get 2 windows- one with the actual sqldeveloper and
    another a dos command window with several lines like:
    UsersCache.fillIn() time = 160 ret==null?: false
    Failed to read custom formatting program /C:/Users/username1/AppData/Roaming/SQL
    Developer/system4.2.0.17.089.1709/o.sqldeveloper.12.2.1.17.89.1709/format.arbori

    C:\Users\username1\AppData\Roaming\SQL Developer\system4.2.0.17.089.1709\o.sqldev
    eloper.12.2.1.17.89.1709\format.arbori (The system cannot find the file specifie
    d)
    Failed to read custom formatting program /C:/Users/username1/AppData/Roaming/SQL
    Developer/system4.2.0.17.089.1709/o.sqldeveloper.12.2.1.17.89.1709/format.arbori

    1. thatjeffsmith Post
      Author
  6. Hello.

    Even if we do not need Oracle Instant Client for resetting password,
    OCI/Thick driver is still better for cancelling queries.

    I have done small check and without it while executing a simple CTAS
    and trying to cancel it, query was still executing and finally table was created.

    But when Oracle Instant Client with OCI/Thick driver was used instead
    query was cancelled with the following error:
    ORA-01013: “user requested cancel of current operation”,
    which is what we should see.

    Best Regards.
    Piotr

    1. thatjeffsmith Post
      Author
      1. Yes, I am using version 4.2.0.17.089 and without using OCI/Thick driver when I tried to cancel a query (simple CTAS) it was still running (even if in Task Progress on the right side of the timer “Task cancelled” replaced “Executing query:..” information) and finally CTAS completed, while with it query was cancelled like it should.

  7. Seems 4.2 is even more buggy than 4.2EA =):
    1. Bug with the explaining of a plan of some internal query instead of query what I’ve asked for is still exists.
    2. New bug: connecting to the account in ‘EXPIRED(GRACE)’ state returns devision by zero error and produces a broken worksheet.

    1. thatjeffsmith Post
      Author

      Not possible Andrey. We close more than a hundred bugs in that time frame.

      Can you give me a test case for #1?

      I’ll have to test/reproduce #2, although bug reports should be going to My Oracle Support.

  8. Hello,

    4.2 seems slow compared to 4.1.5.21 with respective to Reports feature.. I had move back to older version due to slowness. Report starts with brief pause (in terms of seconds) with 4.2

    Thanks,
    Balaji.

    1. thatjeffsmith Post
      Author

Leave a Reply

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