SQL Developer version 4.2 Early Adopter 2 Now Available

thatjeffsmith SQL Developer 16 Comments

Tell Others About This Story:

Tons of bugs fixes based on your feedback, especially with the formatter.

A few more changes with the formatter:

  • we added more preferences for more flexibility
  • we let you submit code to ‘shape’ the formatting preferences automatically
  • we exposed the brains of the formatter so you can do pretty much whatever you want

An example of the formatter ‘by example’

Type code, as the formatter sees 'stuff' it changes the formatting options - these are highlighted in Green so you can see what's changed.

Type code, as the formatter sees ‘stuff’ it changes the formatting options – these are highlighted in Green so you can see what’s changed.

I’ll talk about the formatting ‘gut’ being exposed in a later post.

But we did a bit more than the formatter stuff.

The Real Time SQL Monitor has been enhanced to show you more stuff – everything you’d expect to see like you see it in Enterprise Manager.

Pruning, projection, and all that jazz - thanks to @SQLMaria for keeping us honest :)

Pruning, projection, and all that jazz – thanks to @SQLMaria for keeping us honest 🙂

How about re-setting passwords while not connected, and WITHOUT requiring a Thick Client?

THICK CLIENT = ORACLE_HOME/Oracle Client.

SQL Developer 4.2 ships with a 12.2 JDBC driver. And the JDBC Driver supports password resets while not connected now. Might be the #1 reason to upgrade to v4.2 when we go live for your production and ‘real’ work environments.

No connection, no Oracle client - no problem.

No connection, no Oracle client – no problem.

One Last Thing – RESTful Services Development Just Got a Lot Easier

No need to login with your ORDS user via REST to publish a RESTful service. You can do that directly from the database/connection tree now.

The REST (http/s) interface is still available if a database connection isn't handy.

The REST (http/s) interface is still available if a database connection isn’t handy.

There’s a lot more to talk about – but enjoy the rest of 2016. Please go download, give it a spin, and share your feedback on the Forums!

Tell Others About This Story:

Comments 16

  1. Open jdk folder, create a new folder and name it ‘bin” then copy msvcr100.dll from jre\bin into the created bin folder then launch sqldeveloper

  2. I usually have a couple of different versions of SQL Developer on my computer — older release that I’m used to and is very stable, and latest early adopter version. Is there a way to keep the connections between multiple versions of SQL Developer in sync? For example, can I configure them to use the same connections file? I know I can export/import the connections, but I don’t want to have to do that every day as I switch between versions and have to change things like adding new connections and updating passwords.

  3. Jeff, not sure if this is a known issue, we found a bug in Sql Developer 4.1 with the “Enter Binds” dialog. If a number is applied greater than max two’s complement 32 bit integer, the value doesn’t get applied:

    declare
    v_number number(19);
    begin
    select :bindvar into v_number from dual;
    dbms_output.put_line(‘Bindvar=[‘ || v_number || ‘]’);
    end;
    /

    2147483647 works but 2147483648 gives Bindvar=[0]

    Letting you know in case it’s not addressed yet in 4.2. We have OIDs > 2147483647.

    Thanks,
    Brian

    1. thatjeffsmith Post
      Author
  4. I used a slightly different solution – replaced the entire JDK directory with the JDK directory from my SQL Developer 4.1.5 install and it worked.

    Jeff – I believe this is a problem with the JDK included in 4.2 – not “A Windows thing”

    Jim

    1. thatjeffsmith Post
      Author
  5. I get the following error:
    Unable to launch the Java Virtual Machine
    Located at path:
    e:\sqldeveloper\jdk\bin\msvcr100.dll

    A google search says to copy the file from the jdk\bin to sqldeveloper\sqldeveloper\bin. Did that, still fails.

    Also tried removing the ‘setjavahome’ line from the conf file.

    Tried on a couple of PCs.

      1. Andy, I just realized that it’s looking for the file under jdk\bin instead of jdk\jre\bin. I created the bin directory directly under jdk and copied over the file and it’s working now.

Leave a Reply

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