Your #1 Reason for Upgrading SQL Developer to Version 4.2

thatjeffsmith SQL Developer 13 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.

Related Posts Plugin for WordPress, Blogger...
Tell Others About This Story:

Comments 13

  1. 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
      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?.


  2. 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

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

    1. thatjeffsmith Post
  3. 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.

    1. thatjeffsmith Post
      1. Yes, I am using version 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.

  4. 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

      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.

  5. Hello,

    4.2 seems slow compared to 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


    1. thatjeffsmith Post

Leave a Reply

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