Oracle SQL Developer 4.0 Is Finally Here

thatjeffsmith Expired 296 Comments

Tell Others About This Story:

So go download it.

I’m at the beach this week, not working. Mostly.

I’ll be talking about our newest addition to the family, pretty much non-stop, starting next week and stopping when version.NEXT is released. You have plenty to look forward to πŸ™‚

SQL Developer version 4.0 - lots of yummy goodness inside :)

SQL Developer version 4.0 – lots of yummy goodness inside πŸ™‚

For now, just a few points:

  1. We’re not distributing the JDK on Windows 32 bit distributions anymore
  2. We now require Java 1.7 JDK by default
  3. Windows installs will attempt to auto-find the JDK for you on the first run – if you’re in 64-bit mode, run the 64.exe in the bin directory and we’ll look for the 64bit JDK – once it’d defined, you can run the main dir exe again
  4. We’re shipping an 11.2.0.3 JDBC driver now, so you’ll need an 11.2.0.3 client to use OCI/thick connections – this will SOON change to 12cR1 driver/client requirement
  5. All 3rd party extensions are currently disabled – our framework has changed such that they will need to be updated to be compatible with the new version – more to follow early next week
  6. This is the first EA release for 4.0 – there will be more as you help us fine tune and tweak the new features and identify bugs
  7. Don’t be shy with your feedback, you won’t hurt our feelings

Now, back to the beach πŸ™‚

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

Comments 296

  1. Hi Jeff Smith,

    Why i am not able to upgrade to latest version of sqldeveloper or not able to install / download updates from check for updates tab? it’s asking for OTN username and passwrod, which is not taking my current credential after resetting password even.

    Any help appriciated…

    1. thatjeffsmith Post
      Author
  2. By any chance, do you know where the SQL Developer saving its features options? Are they in an configuration file or in the registry?

    Thanks so much for your help.

    1. thatjeffsmith Post
      Author
  3. In Windows 7 I have SQL Developer pinned to my taskbar and when I open it the pinned icon still looks pinned and another icon of SQL Developer shows up on my taskbar. Normal function would change the pinned icon to show that the program is open.

    This is actually 4.1.0.17

  4. For one thing, these units are completely eco-friendly,
    relying on nothing more than the power of super-heated steam to loosen and remove different kinds of stains
    and deposits. What is the most ideal lightweight carpet vacuum
    cleaner. The only weight setting on your carper at the roller brush
    is the weight of the nozzle itself.

    1. thatjeffsmith Post
      Author
  5. SQL Developer is so slooow. it actually loads for about 5 minutes on Oracle Developer VM. I’ve already assigned 6GB to that VM. Typing is slow. Executing is slow. “Initializing extensions” takes ages. Horrible IDE. Sorry.

    1. thatjeffsmith Post
      Author
      1. 75 seconds total. after 10 seconds the “loading” window appears. populatng SCOTT “tables” branch (11 tables total) takes 25 seconds.

        even for this tiny home machine (Linux, 16GB RAM, x4 3GHz CPU) I reckon timings could be much better πŸ™

        It is Java, has its pros and cons, I know, but general responsiveness of the IDE is begging for improvement…

        1. thatjeffsmith Post
          Author
          1. Linux 3.13.0-24-generic #47-Ubuntu SMP Fri May 2 23:30:00 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux

            SQLDeveloper: 4.1.0.17 Build MAIN-17.29

            JDK: 1.8.0_25

  6. Hi,

    Does this new version come with a way to set “Schema browser” as the default view? I remember you mentioning that it was on your to-do list.

    Thanks!

  7. Hi Jeff,

    I have been trying to run a simple Create statement through Migration utility in command line. Below is my syntax:

    C:\SQLDeveloper\sqldeveloper\bin>sdcli64 Migration -actions=
    runsql -sql=”CREATE TABLE t1 (col1 number);” -conn=CONV
    Could not find a suitable processor for feature Migration
    cart: Database Cart Batch Tasks
    dba: Basic Batch DBA Tasks
    format: SQL Format Task
    migration: Database Migration Tasks
    reports: Basic Batch Reporting Tasks
    unittest: Unit Testing Batch Tasks

    I get above error message. I used sdcli also. Request you to kindly help me with this.

    Regards,
    C.P.

  8. I have downloaded sqldeveloper v 4.0.2.15 build 15.21. After much difficulty I was able to get the Git support to work sort of. Now it does not work at all. When I try to clone after I enter the repository url, username, password,etc and click on Next, nothing happens at all. Will this ever work or should I just abandon all hope and find a different solution?

    1. thatjeffsmith Post
      Author

      Are you defining a key and a password? I know if you use one, you shouldn’t use the other. Otherwise my experience with Git isn’t very extension. I’d recommend you open an SR with MOS or try reaching out to someone in the community on our OTN Forum. It should work – it’s been part of JDeveloper since last year.

  9. My connection menu dissapeared when restarting sql developer.
    I use version 4.0… of sql developer. In view menu the connections icon is greyed out (or maybe it is always grey?).
    I downloaded the sql developer that include Java.
    Anyone having a clue to solve this?

    1. thatjeffsmith Post
      Author
        1. thatjeffsmith Post
          Author

          Something is borked with your ‘install’ – try putting down a fresh copy in a brand new directory. If that doesn’t work, then you’ll need to open a Service Request with My Oracle Support or try getting help on the OTN Forums.

  10. Hi Jeff
    We have an extension that allows us to launch SQLDeveloper from an in-house password vault and automatically creates a database connection with a given password from the vault under 3.2, however this does not work in 4.0.2.
    Is there a somewhere can look for advice to upgrade our extension ?
    Thanks

    Ian

  11. Hi, I notice that when debugging a procedure in a pakcage body I always get a new package body window. For a procedure or function not in a package it works like expected. I can debug in the same window. I have been looking in the preferences but cannot find how to disable this behaviour… Version is 4.0.0.13 64-bit windows

  12. When I try running Oracle SQL developer, it starts and fails after about 10% start up. There are no errors. The screen just shuts down. Is there a log or something I can look at to decipher what is happening?

    1. thatjeffsmith Post
      Author

      you can open it from the bin directory – you should see a cmd/terminal window open with more feedback.

      OR

      You can go to your application data directory and delete the folder for version 4 – a corrupted file there is responsible about 95% of the time for this behavior

      1. Jeff, I have been running 4.0.3.16 and have had no trouble. I got a new computer and loaded 4.1.1 on my new machine and developer randomly shuts down on its own without warning. Sometimes it stays up for an hour and sometimes it shuts down within seconds of opening it. It’s a 64 bit machine with Windows 7. Do you have any ideas about my issue?

        1. thatjeffsmith Post
          Author

          The only idea I have is a windows driver isn’t happy with Java 8. Check to see if there’s a video driver update available.

          Start running sqldev from a windows cmd window – run the exe directly from there – you should see standard output on the cmd window. The next time it shuts down, check that cmd window for error messages.

  13. Not entirely. I find my way around most of it. I should have added, I ran that command before I sent that. I just get a “bash: ./sqldeveloper.sh permission denied”.
    Sorry to be a bother

    1. thatjeffsmith Post
      Author
      1. THanks a million Jeff. Yess the machine is mine and I used the chmod 777 to sort it. Java was already installed so I entered the path as is.
        Thanks again.

  14. Hi THATJEFFSMITH, getting better at Oracle Database 11g and I decide to upgrade from version 1.5.5 to 4.0.2.15.21-1 on Oracle Linux 5.7. I keep getting this error. Please help.

    [oracle@toochi Practice Labs]$ rpm -Uhv sqldeveloper-4.0.2.15.21-1.noarch.rpm
    error: Failed dependencies:
    rpmlib(FileDigests) <= 4.6.0-1 is needed by sqldeveloper-4.0.2.15.21-1.noarch
    rpmlib(PayloadIsXz) <= 5.2-1 is needed by sqldeveloper-4.0.2.15.21-1.noarch

      1. thatjeffsmith Post
        Author
        1. thanks so far. But I’d like to know if it is okay to extract to any location or should I overwrite the current sqldeveloper directory?

          1. So, I extracted to the desktop and tried executing sqldeveloper.sh and I get this in a window

            #!/bin/bash
            cd “`dirname $0` “/sqldeveloper/bin && bash sqldeveloper $*

          2. thatjeffsmith Post
            Author

            Are you new to Linux? You might want to get an admin to help you out.

            I extracted my copy to $ORACLE_HOME\sqldev4

            I start it from a command window/shell prompt like…

            / > ./sqldeveloper.sh

            That launches SQL Developer – assuming it can find Java

  15. Hi Tom, getting better at Oracle Database 11g and I decide to upgrade from version 1.5.5 to 4.0.2.15.21-1 on Oracle Linux 5.7. I keep getting this error. Please help.

    [oracle@toochi Practice Labs]$ rpm -Uhv sqldeveloper-4.0.2.15.21-1.noarch.rpm
    error: Failed dependencies:
    rpmlib(FileDigests) <= 4.6.0-1 is needed by sqldeveloper-4.0.2.15.21-1.noarch
    rpmlib(PayloadIsXz) <= 5.2-1 is needed by sqldeveloper-4.0.2.15.21-1.noarch

  16. The tool still sucks. It may be functionaly equivelent to TOAD, but it is not a productive tool to use. I abosultely can not stand the tool but my people in out company who decided “free is better” are not the same people that use the tool. The only reason this garbage has any market share is because its free.

    1. thatjeffsmith Post
      Author

      I understand you’re not happy Dave. And I would agree that changing tools can be a sucky experience.

      But.

      I cannot help you have a better experience or help make the tool better for you and your company if you can’t share some actionable feedback. I could tell our devs to do it ‘less sucky’ or I could say something like, ‘Dave cannot do his job b/c X, Y, and Z.’

      I’m here if you want to help.

      Feel free to contact me offline at jeff.d.smith@oracle.com and please feel free to be as honest and brutal with your feedback as you feel comfortable with.

      For what it’s worth, I used your old tool, and I use SQL Dev each and every day for the past 10+ years to do my job. I think it’s possible to be productive AND happy with ours. But I’m just me, and obviously a biased source.

  17. Hi jeff I’m using SQL developer 4 for a while now but I have huge memory issues with it 1024 mb in use!
    Process is slow all lagging and on the end it needs to be killed in task manager…
    Tried to set up
    \ide\bin\ide.conf
    for
    # Set the default memory options for the Java VM which apply to both 32 and 64-bit VM’s.
    # These values can be overridden in the user .conf file, see the comment at the top of this file.
    AddVMOption -Xms512M
    AddVMOption -Xmx2048M

    but no luck tried to untick Look and Feel option on Windows no luck either…

    I work in a banking programming business and this is big problem for all of us… we began to remove instances cause of lagging and loose of work when It hangs…

    Big and good difference is that now I can debug very very big packages that previously I couldn’t debug with developer but with TOAD. (126 000 lines of dynamically created code in production) …

    So plese do you have any solution for us…

    THX…

    1. thatjeffsmith Post
      Author

      I doubt SQLDev is acutally using a gig of memory, is this what jstack shows?

      Also, you don’t set the JVM options in ide.conf

      For version 3.2 and lower, it’s sqldeveloper.conf in the bin directory. For v4 and higher, it’s product.conf up in the user/application data/roaming profiles/sqldeveloper/1.0.0.0 directory.

  18. Hi Jeff,

    I would be happy if you could help me or reference me:-)

    I had developed an extension for Oracle SQL Developer 3 version with the previous JDev versions. Now I have started migrating my extension… Focusing the databases context menus – I have in my extension context menu items added to the existing oracle explorer various objects as connection, table etc. context menu: In my old extension, I had a contextmenu xml file which I have define the various menu items under the specific location by specifing: etc. and the registration I have done in the “initializeAddin” by: Xmlbasedbjectsaction.registercontextmenus (Which currently is obselete).

    In the 12 c version, I am trying to migrate the changes: In the extension.xml file I have added the action->controller->contex-menuhook under the trigger-hook section as described – How can I define the context menu items to be added to the existing oracle connection ide database context menu? If you can provide me a working example of context menu to the sql fev db nav it would be wonderful.
    I assume the namespace of the sql dev context menu should not be the jcp.org etc… and the site id-ref would be also suited to the db nav??
    Thanks a lot in advance!!
    Freydie

  19. I love this tool but I keep getting low memory error when trying to sync my physical with the relational model.

    I tried changing the setting in the ide.conf as instructed but it looks like the memory is limited to about 948mb while my laptop has 8gb of memory available.

    The ide.conf is also not very readable. I’m not sure if the memory setting is really being set or changed.

    1. thatjeffsmith Post
      Author
  20. Hi Jeff,
    I just installed sql developer 4 and found a difference in the display of XML output in the Query Results tab. When I ran a query in sql developer 3 producing xml output, the result is available as text that can be copied and pasted into an editor. In sql developer 4 the same query produces “(XMLType)” which is not helpful for viewing the xml. Is there a setting I need to adjust? Thanks, Olav

    1. thatjeffsmith Post
      Author

      Can you give me an example? Querying a table with column of type SYS.XMLTYPE in version 4 (JDBC connection) to Oracle 11.2.0.3 DB works as it did in version 3.2 – I see the first bit of the XML string in the grid cell.

  21. Hi, I recently tried the database diff tool from SQL Developer and found it really useful.
    However i did think of some changes that might make it even better.
    For example replacing the shuttle control from step 3 of the wizard with a simple text box into which the user could paste for example a prepared list of objects that interest him, or even better give him the option to save such a list or import it from a text file would really be quite useful when dealing with large number of objects.
    Another improvement could be made by providing the option to export all of the scripts
    from the diff report into one file. (If there is one sorry for being to blind to find it :D)
    Sorry for the long post. Thanks and good health.

    1. thatjeffsmith Post
      Author
      1. Super thanks, feeling a bit noob for missing it. πŸ˜€
        Do you think the replacement for the shuttle control makes any sense?

        1. thatjeffsmith Post
          Author
  22. Hi,

    I noticed 2 problems with 4.0.0.13.80

    – Sqldevelopper windows becomes frequently topmost window and alt-tab can’t select another window
    – Deleted packages still appear in connection properties/packages. When I look at the same database with v3, they do not appear.

    By the way, do you know when a new release will be available ?

    Thanks,

    Olivier

    1. thatjeffsmith Post
      Author

      1 – Can you provide an example, I’ve not seen this behavior yet.
      2 – Are you deleting the package by using the tree, right-click, Drop Package… or are you doing it via the worksheet?

      I do not know. We’ll let v4 percolate awhile and issue a patch to address the critical bugs that have been identified.

      1. Not possible to give an example, the behaviour is the sql developer windows staying suddenly topmost, alt-tab not working because sql dev goes back to the top after trying to use the shortcut to go to another windows. Mouse works if I click into another window, this one goes to the top.

        Yes, right click, drop package. The package still appears in the tree but I get the message ORA-04043 non existing object. And it doesn’t appear in SQL3. Looks like the package property branch is stored locally in the treeview ?

        Olivier

        1. thatjeffsmith Post
          Author

          When I drop a package, I get a confirmation dialog saying the package has been dropped, then the tree refreshes and the package is no longer in the tree.

          Do you have a report running with auto-refresh, or maybe a document ‘floated’ off the main SQLDev window? Doing anything funky in Windows? Cause I’m not able to observe or reproduce this problem either. Maybe a screenshot or quick video of what you’re seeing would help diagnose what’s going on.

          1. I can reproduce the problem any time, after closing, reboot of windows. How can I send you a screenshot ? You can email me with the adress I let on this site.

          2. thatjeffsmith Post
            Author
          3. thatjeffsmith Post
            Author
  23. Hi,
    I have problem while upgrading SQL developer 4.0.0.12 to 4.0.0.13 on my windows 64 bit machine. 4.0.0.12 version is working good, where as 4.0.0.13 is showing below error while starting it. I did try adding AddJavaLibFile & SetMainClass to sqldevloper.conf but no luck. Could you please help in this regard.
    Error Message

    C:\Dev Software\sqldeveloper-2\sqldeveloper\bin>java -Xmx640M -Xms128M -Xverify:none -Doracle.ide.util.AddinPolicyUtils.OVERRIDE_FLAG=true -Dsun.java2d.ddoffscreen=false -Dwindows.
    shell.font.languages= -XX:MaxPermSize=128M -Dide.AssertTracingDisabled=true -Doracle.ide.util.AddinPolicyUtils.OVERRIDE_FLAG=true -Djava.util.logging.config.file=logging.conf -Dsql
    dev.debug=false -Dide.conf=”./sqldeveloper.conf” -Dide.startingcwd=”.” -classpath ../../ide/lib/ide-boot.jar oracle.ide.boot.Launcher
    ERROR: You’re trying to run the product with the legacy launcher oracle.ide.boot.Launcher . Check your .conf file and be sure to include:
    AddJavaLibFile ../../ide/lib/fcpboot.jar
    SetMainClass oracle.ide.osgi.boot.OracleIdeLauncher

    1. thatjeffsmith Post
      Author
      1. Well that is an absolutely stupid response. Any idiot would know that oracle calls the sqldeveloper.bat file and they are the ones that call everything else. The problem is not why we are doing anything….it is the problem that it causes an error and we want to know how to fix it…if your blog can’t help then it is just wasting space and should be deleted!!!!

        1. thatjeffsmith Post
          Author

          I’m not just any idiot, I’m THE idiot.

          If you want to set jvm properties, you do that in the product.conf file.

          That previous question/answer is like a year old. If you want to come in now and start a ruckus, that’s cool.

          “Check your .conf file and be sure to include:
          AddJavaLibFile ../../ide/lib/fcpboot.jar
          SetMainClass oracle.ide.osgi.boot.OracleIdeLauncher”

          Try doing that in the product.conf or the ide.conf file.

          Can you help me find a blog post on how to delete my blog in the meantime?

    1. thatjeffsmith Post
      Author
  24. How can i disable the “Check for Updates” entry, or even better, hide the UI under the Help Menu?

    Add “AddVMOption -Dide.noextensions=oracle.ide.webupdate” in the sqldeveloper.conf File doesn’t work for me.

    1. thatjeffsmith Post
      Author
        1. thatjeffsmith Post
          Author

          The check for updates won’t actually update SQL Developer itself – just the extensions. Wanted to make sure you’re aware of that.

          Might be a more complete solution to blacklist the OTN download servers if you want to lock desktops down.

  25. Hi,
    I have a problem with code completion in both SQL Developer 3 and SQL Developer 4.
    For example I type schema_name.package_name. (ctrl+space) and nothing happens if i trying to reference to package in another scheme.
    If I type schema_name. (ctrl_space) it work well for package name, but package members not showing.

    Such references in the same schema works well, but I need to code completion with object in another schema.
    How I can set this?
    Thanks.

    1. thatjeffsmith Post
      Author

      There have been some bugs around code insight, but in the 4 build I have, which is later than EA3, if I type:

      [sql]
      begin
      sys.dbms_ouput.
      [/sql]

      And hit ctrl+spacebar – I get back a list of the DBMS_OUTPUT items.

  26. Never mind…I found the answer in another one of your helpful posts. Thank you for that. I have to say that it is not intuitive at all where to look for the setting and I would suggest that there be a way to change it through the sqldeveloper ui or something akin to that.

    For anyone else who encounters this, the SetJavaHome directive setting is now kept under in a sqldeveloper folder the windows roaming profile folder (%APPDATA%), for me it was: C:\Users\cwhelan\AppData\Roaming\sqldeveloper\1.0.0.0.0 in the product.conf file.

  27. Hi again. One more environmental thing I forgot to mention. I also have a 3.x version of sqldeveloper “installed”.

    Regards,

    Chris Whelan

  28. Hi Jeff,
    I am trying to run EA3 32Bit on Windows 7 against JDK 1.7 with no success. I have both 1.6 and 1.7 JDKs and I still require 1.6 for other development. When I start sqldeveloper.exe from windows explorer (both as admin and as my own user), it never prompts me to point to a JDK, but always insists on loading using the 1.6 version. I have set JAVA_HOME windows system environment variable, I used SetJavaHome in both the jdk.conf and sqldeveloper.conf files to no avail. I have set JDK 1.7 bin folder to be first in my PATH system environment variable. The result is always the same, the warning that 1.6 is not supported and needs to be upgraded. I have uninstalled and reinstalled 1.7. I looked at the registry settings. Nothing I have done will convince sqldeveloper that I have 1.7 installed. I know that my PATH is correct because eclipse loads fine and the help->about->config properties shows 1.7 was used. Do you have any suggestions as to what else I can do to resolve this issue?

    Thanks,

    Chris Whelan

  29. Hi,

    You said: “Exactly what version are you running – we’ve had 3 Early Adopter updates so far?”
    I have a question!!
    I use SQL Developer 4.0.0.12 but I don’t know which EA??
    How can I find EA version?

    1. thatjeffsmith Post
      Author
        1. thatjeffsmith Post
          Author
  30. SQL developper 4 is so slow it can’t even register keypresses in realtime when you type a query. Just like the 3.x series, it’s the only thing that can slow down my powerful computer. Just scrap it and rewrite it in a real programming language.
    I love Oracle Database, but cannot understand why they insist on providing subpar tools.
    Thanks.

    1. thatjeffsmith Post
      Author

      That’s obviously not the desired behavior, can you help me out a bit with some more information?

      Exactly what version are you running – we’ve had 3 Early Adopter updates so far?
      What OS are you on?
      What version of Java are you running?

      We’ve had a few issues with parser bugs that have been addressed, so you could be suffering from those, but that’s just a guess at this point.

      Java is a real programming language, but that doesn’t really matter. Getting it working for you is what matters.

  31. Just downloaded 4 ea 3 on Mac OS X (I like living on the edge…).
    When I try to expand “packages” I get nothing (there are 6 or so in user_objects). Other items (tables, indexes) expand fine. I do not see a filter set, although this would be strange on a just installed program. Anyone else run into this before I attempt a reinstall?

    Mac OS X 10.9
    SQL developer 4..0.0.13.30
    JDK 1.7.0_45
    Attempted Connecting to Oracle 11.1.0.7.0 and 11.2.0.4.0

    1. thatjeffsmith Post
      Author

      So first question: are you already running SQL Developer, say a production version like v3.2, and are able to see the packages no problem?

      Here’s what we’re running to produce the package node list for a user…sorry for the poor formatting, that’s how it’s stored in v$sql…

      [sql]
      — Was (with scalar subquery in the select clause) : — –select * from ( — SELECT OBJECT_NAME, OBJECT_ID, — cast(last_ddl_time as timestamp) LAST_MODIFIED, — DECODE(STATUS, ‘INVALID’, ‘TRUE’, ‘FALSE’) INVALID, — ‘TRUE’ runnable, — ‘TRUE’ BODY_ALLOWED, — PLSQL_DEBUG, — (select count(1) from all_objects o2 — where o2.object_name = o1.object_name — and o2.owner = o1.owner — and o2.object_type = ‘PACKAGE BODY’ ) has_body — ‘PACKAGE BODY’ BODY_TYPE, o.created — FROM SYS.ALL_OBJECTS o, all_plsql_object_settings s — WHERE o.OWNER = :SCHEMA — AND s.OWNER(+) = :SCHEMA — AND s.name(+) = o.OBJECT_NAME — AND s.type(+) = ‘PACKAGE’
      [/sql]

      1. Yes, I was running 3.2 on this test mac. Unfortunately the .app was overwritten by the new install, but it would be a simple restore to recover it.
        I am attempting to run the sql used for the package node in the 4 EA3 version, but give me a minute, the formatting is messy…

        1. I manage to get the SQL to run after fixing the formatting, changing an alias, adding a comma in the section “has_body — ‘PACKAGE BODY’ BODY_TYPE” and adding a paren close at the end. Don’t know if that is the way it is in the code too. This was the resulting SQL:
          select * from
          ( SELECT
          OBJECT_NAME, OBJECT_ID, cast(last_ddl_time as timestamp) LAST_MODIFIED, DECODE(STATUS, ‘INVALID’, ‘TRUE’, ‘FALSE’) INVALID
          , ‘TRUE’ runnable, ‘TRUE’ BODY_ALLOWED, PLSQL_DEBUG
          , (select count(1) from all_objects o2 where o2.object_name = o1.object_name and o2.owner = o1.owner and o2.object_type = ‘PACKAGE BODY’ ) has_body
          , ‘PACKAGE BODY’ BODY_TYPE
          , o1.created
          FROM SYS.ALL_OBJECTS o1, all_plsql_object_settings s
          WHERE o1.OWNER = :SCHEMA AND s.OWNER(+) = :SCHEMA
          AND s.name(+) = o1.OBJECT_NAME
          AND s.type(+) = ‘PACKAGE’)
          ;

          I did not see any packages in the results. Going through that now to figure out why.

        2. I guess I owe an answer even if it was the result of poor eyesight. There were really no packages there. The user I chose was one character off from the one I thought I chose. You may remove my thread and yell at me; I deserve it

          1. thatjeffsmith Post
            Author

            Louis,

            Absolutely no problem! With 4.0 having SO many changes, I’m paranoid about lots of things breaking πŸ™‚ So your feedback is always welcome, even if it turns out not to be a problem.

            Jeff

  32. Hi,

    Looking at a mysql database, selecting a table in the connections properties pane, I can’t find anymore the above tab listing data/structure/index/constraints ?

    Olivier

    1. thatjeffsmith Post
      Author
        1. thatjeffsmith Post
          Author
  33. Hi Jeff,
    I’m trying to run 4.0 EA2 and it crashes immediately on opening. I have it “installed” as sqldeveloper4 next to my sqldeveloper (3.2) instance. It gets to about 10% on the progress bar and then quits, leaving no error message. Same thing when running from /bin and doing a control break. It dumps errors, but then closes the cmd window and itself. If I do a Run as administrator it loads correctly, leading me to believe 4 is needing some C:\ permission that 3.2 does not require, as 3.2 has no problems. Any ideas? Thanks.

    1. thatjeffsmith Post
      Author

      Have you tried EA3 yet? And where do you have it ‘installed’ to, directory-wise? Using Java 7? What does the cmd window show right before it closes? We’ll write to the roaming user’s application settings directory, including things like the location of the JDK and setup other preferences, history files, etc.

      1. I hadn’t noticed EA3 was out, I’ll go try it right away. As for the issue, I deleted the system4.0.0.12.84 folder from the User/AppData/Roaming/SQL Developer folder, and it worked. I guess the settings were messsed up somehow. Thanks much.

        1. thatjeffsmith Post
          Author
  34. Hi,
    the debugger does not remember changed debug-scripts anymore. It always shows the default script when opening the dialog to debug a package-method. You now have to always save your script and manually reload it again on every debug-run. Quite annoying when you once forget to save:-)

    Regards,

    David

    1. thatjeffsmith Post
      Author
  35. How can i get multiple instances to run? i use two or three separate sql developers when i work. i need to be able to run a long script on one whilst monitoring various objects on another. multiple tabs just doesn’t cut it since i need to see the output from both jobs at the same time. hope this hasn’t been removed, it will kill the product for me.

    1. thatjeffsmith Post
      Author

      ad,

      Nothing has changed, but I want YOU to change πŸ™‚

      Instead of wasting a few hundred MB of memory to run a second instance of #SQLDev, try creating a new document tab group – this allows you to see your worksheet and your monitor/report AT THE SAME TIME. I do this all the time, and it works great.

      You could also FLOAT one of your documents off the main application and onto a 2nd monitor if you have one for an even nicer effect.

      But if you still want to run 2 copies of SQLDev, go for it.

      1. With all due respect I don’t need you to try and change me, in fact assuming you know better what I need is patronising and downright rude!

        I solved the problem with the help of my dba. Floating was ok but wouldn’t let me run two scripts on the same connection at the same time which is what I needed.
        Making an exactly identical connection with a different name is excessive admin for a simple task, but suffices as a work around.

        “But if you still want to run 2 copies of SQLDev, go for it”
        yes please, tell me how to do it since it no longer allows me to.
        this is in fact the original question….

        1. thatjeffsmith Post
          Author

          If you want to run 2 queries concurrently on the same connection – not what you asked for originally from what I can tell – open an unshared worksheet. That gives you a dedicated connection.

          To run 2 copies of SQL Developer, double-click on the icon twice.

          I don’t want to change you, I want to help you. You’ll be happier if you learn how to use document tab groups. You can see your work in multiple windows simultaneously w/o the need to open multiple instances of SQL Developer. SQL Developer isn’t designed to run that way, but will if you want it to.

          If it’s not working for you, you need to tell me more information, like, what happens when you try.

          It wasn’t my intent to be rude. It’s the Internet though, sometimes intent doesn’t carry through very well.

          1. double clicking the icon twice just moves focus to the currently open one.

            don’t bother anymore, i’ve found a suitable work around. i just wanted a simple answer to a question. not an analysis of how i go about my work.
            I do db programming because it pays the bills. i write ccd physics engines for fun and would rather put my learning new thing effort into that.

            Thanks for the help.

          2. thatjeffsmith Post
            Author

            Go into the ‘install’ directory, and navigate to your sql developer/bin subdirectory. Run the exe from there. You should get a cmd window and any error messages.

            Are you running EA1 or 2? EA1 had a bug where there was a hard coded limit of 3 instances of the application, but you said you can’t run two.

            Either way, I hope your physics hobby pans out. Do work that makes you happy.

          3. i couldn’t disagree more.
            in my 20’s i did what i loved as a job, and promptly killed my love for it. professional just meant, having to do it even when you didn’t want to, because you were being paid to do it.
            don’t look for your life’s fulfilment in your job, most of the time you don’t have enough control over that.
            i know people who woudn’t know what to do with themselves if they didn’t have to work. i will never be like that. i work because i have to. i do fluffy IT rubbish coz it’s easy for me and it pays the bills.

            btw neither of the solutions you proposed seemed to work for me. i’ll stick with two differently named connections which is a kludge but works.

            thanks for your time.

          4. thatjeffsmith Post
            Author
          5. mate i lost interest ages ago. found a work around that enabled me to do my job and that is all i was after. don’t have a deep seated need to investigate this, gave up on that 20 years ago when i ceased to be a ‘wunderkinder’. now i just learn what i need to get done what i must.

            “A busy connection requires a new one to do additional work”
            i had expected it to quietly create one as necessary if i was prevented from running multiple instances or simultaneous queries. but really i don’t care anymore. got what i needed.

  36. How about a drop down similar to the one in Toad that lets one set current schema? Is one still supposed to issue ‘alter session set current_schema=’?

    1. thatjeffsmith Post
      Author
    2. thatjeffsmith Post
      Author

      One should use the ALTER SESSION. If you’re doing it by default, then I would ask your DBA to write a LOGON TRIGGER for you. Or if it’s just ad hoc, write a snippet you can use on demand. Or you can use the 3rd party extension I mentioned in your other comment.

    1. I too have installed Version 4.0.0.12 on a new laptop (win7). There are some great enhancements like exporting large tables directly into excel and some other little features (but haven’t tried out everything yet, I was on 3.2.20.09 previously).

      Even though I can find the last 5 open files in my menu and even more by using and combined, I cannot increase the number of recent files and all the tabs close after closing sqldeveloper 4. In my previous version after re-opening sqldeveloper the tabs would reopen as well. Like someone said just like in Notepad++.
      I hope that can be restored. Now I have to reopen all the tabs upon opening sqldeveloper.

  37. Jeff,

    I’ve installed Version 4.0.0.12 on a new laptop (win7). When I start up SQL Developer it does not reopen the files that I had open from my previous time I had used the tool. Thoughts?

    Todd

    1. thatjeffsmith Post
      Author
      1. Jeff,
        Thanks for your reply. I did see the File > Reopen and also Navigate > Go to Recent Files. I’m looking for something more automatic though. In the last version I was on ~3.5ish if I closed the tool with 5 files open for edit the next time I started up the tool it would reopen the same 5 files again automatically. I liked that functionality as I’m coding on projects for multiple days…
        Thanks,
        Todd

        1. thatjeffsmith Post
          Author

          Apparently an intentional change as we had a bug come up around this, but the way I see it, it merits another college-try to maintain the previous behavior/feature. I personally like this behavior in Notepad++ and can see why you’d like it here too.

          1. Another vote for restoring this behavior. If you want to go a step further and really take inspiration from Notepad++ add the functionality to save sessions so depending on what i am working on i can open a set of files that i defined and saved as a session. See File->Load Session in Notepad++

          2. Hi Jeff, where is the toggle for the auto-reopen feature? I can’t seem to find anything in Preferences. It works for me, but not for a co-worker (both running the latest).

          3. thatjeffsmith Post
            Author

            It’s not a toggle or preference, the developer fixed this for the GA official release.

            I don’t think there’s a preference for that – but the developer is on vacation this week, so I’ll ask for sure when he gets back.

            You could run with the command console log running and/or in debug mode to see if there are any exceptions or errors generated on startup to see if something funny is going on with your install.

  38. Hey Jeff,

    Been using SQL Developer 4 on Ubuntu 12.04 for a couple of months now and all is good. Today however I needed to connect to a SQL Server and couldnt do so.

    I downloaded the latest jtds drivers from MS for JDK7 into my .sqldeveloper/tmp/update folder and then added them to the Tools->Prefs->DB->JDBC Third Party Drivers.

    Restarted SQL Developer and no joy. I only see the Oracle Tab.

    I repeated the process for MySQL and same results.

    Please let me know if this is a bug or am i doing something wrong.

    Thanks,
    Carl.

    1. thatjeffsmith Post
      Author
  39. Jeff,

    I maintain/develop GeoRaptor for SQL Developer. It has been an extension of SQL Developer since the original SQL Developer 1.0 beta. We currently have a version in production for 3.2.

    I have some updates I am wanting to release which I will do for 3.2 but I am also starting to get questions about 4.0.

    I note that you said on July 11th:

    “All 3rd party extensions are currently disabled – our framework has changed such that they will need to be updated to be compatible with the new version – more to follow early next week”

    I have done some Googling and had a look at OTN but I can’t find any references to any publication of the new integration framework for 3rd party extension developers.

    Has something been published that I have missed? If so, can you give me an URL to that information. Or if it has not been published, when do you expect something to be published?

    regards
    Simon

    1. thatjeffsmith Post
      Author
      1. Jeff, I just upgraded my SQLDeveloper to 4.0. Could you provide me the instructions for adding 3rd party extensions?

        Much appreciated.
        Elan

        1. thatjeffsmith Post
          Author
          1. I cannot make the georaptor work on version 4.0.1.14.
            I installed the files as specified in the instructions of georaptor. What else needs to be done?

          2. thatjeffsmith Post
            Author

            Someone needs to update it for compatibility with JDeveloper 12’s new OSGi framework. Until that happens, it won’t run on v4 or higher versions.

            Have you investigated our native Spatial & Graph support?

          3. I have to admin that I did not. I just saw that in my GEO column I get the MDSYS.SDO_GEOMETRY value instead of detailed info like SRID, bounds, and so on. I thought that GeoRaptor will fix this and then I noticed that it does not work.
            Is there a way to make it display more info with the native support?

          4. thatjeffsmith Post
            Author
    1. thatjeffsmith Post
      Author

      Yeah, so 30 second response time isn’t good. What version of JDK are you using and are you using THICK/OCI driver? If so, what version Oracle client are you using?

      Do you see any waits on your SQL Developer session to explain where the time is being spent?

      Are any of your colleagues experiencing this, or is it just you? Or if you were to try this on another computer/machine, do you experience the same delayed response time?

      1. i am using JDK jdk1.7.0_40
        I am not using THICK/OCI driver..

        One more observation is
        SELECT * FROM DUAL ; on V4.0 first time its taking 48 seconds.
        Then subsequent execution on same SQL is normal.

        Again I execute a new SQL …same delayed response time…2nd time real fast…
        Not sure is there any settings I have to do ?

      1. thatjeffsmith Post
        Author
  40. Hi Jeff ,

    I have downloaded Oracle SQL Developer version 4.0
    When I execute the SQL statements it runs for very long …even the SQLs with WHERE clause condition on primary key.
    Another observation is when SQL developer 4.0 loaded …it consumes lot of DRAM memory and CPU resources.

    Whereas SQL developer version 1.5.5 with the same above SQL statements runs very fast and brings up the data very fast.

    So in version 4.0 do I need to make any settings ?
    Your hrlp is greatly appreciated.

    1. thatjeffsmith Post
      Author

      I’m confused, you’re comparing SQL Dev 4 to SQL Dev 1.5, which is almost 8 years old? Do you have v3.2 you can use for comparisons? Or can you compare SQL execution times with the same query via SQL*Plus?

      1. Jeff ,

        I had a similar experience with V3.2 as well…so i though V4.0 will be faster.

        When I execute the same SET of SQLs from putty SQLPLUS session real fast..
        When I run SQLs on v4.0,v3.2 …SQLs runs for longer time
        even ..simple SQL
        SELECT * FROM dual ; runs for more than 30 seconds.

  41. Hi Jeff,

    Here’s an example of what i’m running :

    VARIABLE sql_id_var VARCHAR2(64);
    VARIABLE sql_child_number_var NUMBER;
    VARIABLE sql_exec_var NUMBER;

    — here’s our target statement :
    select count(*) from gv$session;

    begin
    SELECT PREV_SQL_ID, PREV_EXEC_ID, PREV_CHILD_NUMBER INTO :sql_id_var, :sql_exec_var, :sql_child_number_var
    FROM v$session V
    inner join v$sql S on S.sql_id = V.prev_sql_id
    WHERE SID = (SELECT dbms_debug_jdwp.current_session_id from dual )
    AND serial# = (select dbms_debug_jdwp.current_session_serial from dual)
    and parsing_schema_name = user ;
    end;
    /

    Now, i’ve noticed that in a sense you’re right. If I select all of the above code in one block and then hit F5 – it works. However, if I run each statement separately it doesn’t. It then picks up the sql developer select that we were discussing earlier.

    That is a change from sql developer 3, cause with 3 you could run each statement
    interactively, and still get the right result. But anyway.

    It’s worth being aware of though, cause people often run things one at a time. Take this other example :

    select count(*) from gv$session;
    select * from table( dbms_xplan.display_cursor(NULL, NULL, format => ‘ADVANCED’ ) );

    In this situation, display_cursor should show you the LAST sql executed.

    And, as with the earlier example, if you select both and hit F5 you get the expected result, which is the explain plan for the first statement. If you run one at a time however, you get the explain plan for gypnfv5nzurb0, which is our :
    select child_number from v$sql where sql_id = :1 order by…

    Let me know what you think.

    Paul Stuart

    1. thatjeffsmith Post
      Author

      selecting everything and running at once – that was going to be my suggestion. even for running an xplan request via earlier versions has the same issue you’re referring to – the parent thread (connection) is being used to run things for the IDE vs JUST what you’re running.

  42. Hi Jeff. Yes, I thought it might be something like that.

    The problem now, is that any time you run some sql interactively from SQL developer,
    the PREV* fields from V$SESSION are effectively gone. I have code that was
    using those fields to find, well, the previous sql id. Now that’s not possible.

    Is it possible to enable or disable this feature?

    regards

    Paul Stuart

    1. thatjeffsmith Post
      Author
      1. Hi Jeff,

        Well, not really. Because what I was doing was selecting the
        results of these queries into sqlplus variables.

        I understand the desire to enhance the gui and make sql developer
        a better development environment.

        But there is also a sense in which SQL developer is the main platform
        for executing sql, sqlplus and PL/SQL code. Isn’t it?
        SQLplus for windows is dead, and I personally hate using the
        commandline sqlplus for windows too. I like to use SQL Developer
        for all my work. I’m sure you agree.

        I’m not going to go on about this, but as the main windows client
        for Oracle, doesn’t SQL Developer have a duty to reliably run the
        same sql and pl/sql that sqlplus does? Because if not SQL developer, then who?

        regards

        Paul Stuart

        1. thatjeffsmith Post
          Author

          We run a superset of what SQL*Plus does – that and then some. The ‘and then some’ lets you have fun things like code assistance and such.

          Would you mind sharing your query? And maybe share what you’re using these for? It will help me build a business case for making a change or tweak in how this feature is currently working (or not in your case.)

        2. thatjeffsmith Post
          Author

          Paul, one more question, how are you executing your sql? If you’re using F5, I’m thinking this should work – that should ONLY be running your SQL and it’s intent is to mimic SQL*Plus behavior as close as possible.

  43. Hello,

    I’m using the latest (12.84) build of 4.0.

    Has anyone else noticed that the PREV_SQL_ID column of V$SESSION now
    always shows ‘gypnfv5nzurb0’. This sql is :

    select child_number from v$sql
    where sql_id = :1
    order by child_number

    The PREV_EXEC_ID field keeps increasing too, so it’s obviously something
    being run in the background of SQL Developer. I’ve tried settting SERVEROUTPUT
    to ON and OFF, but that doesn’t seem to affect it.

    And yes, it did work in previous versions of SQL Developer. The PREV_SQLID
    column generally shows the last SQL that you executed.

    Paul S

    1. thatjeffsmith Post
      Author
    2. thatjeffsmith Post
      Author

      Sorry for the multiple replies Paul, but that code you’re finding, from what I can tell, that’s only generated when you have SET AUTOTRACE ON going…did you perhaps set this and forget about it?

  44. Hi.

    Even though I set a break point at a package body, the debugger won’t break at the specified line at all. (I used debug not execute)

    It worked well in version 3.2.20.09 and our oracle server version is 10.2.x.

    1. If I set host to my local IP address after being prompted, It works.
      Without that option enabled in preference, I can not make it work.
      The error messages are as follows:

      ALTER SESSION SET PLSQL_DEBUG=TRUE
      CALL DBMS_DEBUG_JDWP.CONNECT_TCP( ‘127.0.0.1’, ‘1400’ )
      ORA-30683: failure establishing connection to debugger
      ORA-12541: TNS:no listener
      ORA-06512: at “SYS.DBMS_DEBUG_JDWP”, line 68
      ORA-06512: at line 1

      1. thatjeffsmith Post
        Author
  45. hello there, i’ve a problem:

    Illegal character in path at index 53: file:/C:/Users/usuario/AppData/Roaming/SQL Developer/UserSnippets.xml

    Any suggestions?

    Thank you

  46. Hi there!
    1. DB object finder does not work when OSD is installed on Fedora Linux or any distro.
    2. (Sql worksheet) scripts with more than 1,000 lines freeze the editor to the point it become useless.

    1. thatjeffsmith Post
      Author

      1. How so? What happens when you try it? It’s the same code on any OS, so Fedora shouldn’t come into play
      2. Can you get EA2 – came out late yesterday. This was a known bug and should be fixed

      1. Thank you
        This happens on Fedora 18, when I select DB obj finder, I choose all schemas, table, type the table name, click Go and nothing happens, even I check all sources check box. The screen only shows a blink but nothing else appears as a result.

  47. Hello there, I am having issues running SQL Dev 4 on Fedora 19…I installed open jdk7 but when I launch the program, the loading screen shows up but program crashes somehow and doesnt boot. When I run it from terminal as su, I get the following:

    Oracle SQL Developer
    Copyright (c) 1997, 2013, Oracle and/or its affiliates. All rights reserved.

    Sep 09, 2013 9:53:46 AM javax.ide.extension.spi.DefaultElementContext resolveResource
    SEVERE: jar:/file:/opt/sqldeveloper/sqldeveloper/extensions/oracle.sqldeveloper.migration.application.jar!/META-INF/extension.xml:16: Resource not found: ‘${SCRATCH_COMMAND_ICON}’.

    LOAD TIME : 164#
    # A fatal error has been detected by the Java Runtime Environment:
    #
    # SIGSEGV (0xb) at pc=0x0000003b09c62e00, pid=2070, tid=140424423397120
    #
    # JRE version: 7.0_25-b15
    # Java VM: Java HotSpot(TM) 64-Bit Server VM (23.25-b01 mixed mode linux-amd64 compressed oops)
    # Problematic frame:
    # C 0x0000003b09c62e00
    [error occurred during error reporting (printing problematic frame), id 0xb]

    # Failed to write core dump. Core dumps have been disabled. To enable core dumping, try “ulimit -c unlimited” before starting Java again
    #
    [thread 140424509183744 also had an error]
    # An error report file with more information is saved as:
    # [thread 140424509183744 also had an error]
    #
    # If you would like to submit a bug report, please visit:
    # http://bugreport.sun.com/bugreport/crash.jsp
    #
    /opt/sqldeveloper/sqldeveloper/bin/../../ide/bin/launcher.sh: line 611: 2070 Aborted (core dumped) ${JAVA} “${APP_VM_OPTS[@]}” ${APP_ENV_VARS} -classpath ${APP_CLASSPATH} ${APP_MAIN_CLASS} “${APP_APP_OPTS[@]}”

    Thereafter my fedora shows a message saying “A problem in the jdk-1.7.0_25-fcs package has been detected”

    Any ideas how I can fix this

    1. thatjeffsmith Post
      Author
      1. Nelson. I was having the same issue as others, that only sudo would make SQLDeveloper to work. After running a strace on SQLDeveloper with and without sudo, I compared the output of both and identified that the one failing was due to being unable to find some awt libraries. So I started removing environment variables and found out that the culprit is GNOME_DESKTOP_SESSION_ID. Just unset that variable and SQLDeveloper will work fine, at least works fine for me :).

        1. Thanks. That helped me, too. I had to unset two variables:

          unset GNOME_DESKTOP_SESSION_ID
          unset DBUS_SESSION_BUS_ADDRESS

          I just added that to the launcher script, and that fixed my problem.

          1. Merci. Worked for me. Added the following:

            unset GNOME_DESKTOP_SESSION_ID
            unset DBUS_SESSION_BUS_ADDRESS

            Then started sqldeveloper from the command line using sudo as follows:

            sudo sqldeveloper

  48. The PL/SQL debugger does not work.
    no ideas why not… I click on the debug icon and an empty pl/sql calling block is openintg.
    The content can not be stored nor retrieves by the file open function.
    Can you give me please an advice wht is missing in the config or the documentation

    1. thatjeffsmith Post
      Author
        1. thatjeffsmith Post
          Author

          Blank every time for that particular piece of code or for EVERY single pl/sql object you try? Our parser is blowing up on something obviously – and we’ve been fixing these bugs as we’ve been going along.

          Can you share an example program where you’re seeing this behavior?

  49. Hi Jeff, thank you in advance

    UIDefaults.getUI() failed: no ComponentUI class for: oracle.ide.controls.StatusBarControl$JDevStatusBar[,0,0,0×0,invalid,alignmentX=0.0,alignmentY=0.0,border=,flags=0,maximumSize=,minimumSize=,preferredSize=]java.lang.Error
    at javax.swing.UIDefaults.getUIError(UIDefaults.java:729)
    at javax.swing.MultiUIDefaults.getUIError(MultiUIDefaults.java:130)
    at javax.swing.UIDefaults.getUI(UIDefaults.java:759)
    at javax.swing.UIManager.getUI(UIManager.java:1002)
    at oracle.bali.ewt.statusBar.StatusBar.updateUI(StatusBar.java:480)
    at oracle.bali.ewt.statusBar.StatusBar.(StatusBar.java:104)
    at oracle.ide.controls.StatusBarControl$JDevStatusBar.(StatusBarControl.java:264)
    at oracle.ide.controls.StatusBarControl.(StatusBarControl.java:48)
    at com.oracle.jdeveloper.nbwindowsystem.NbMainWindow$11.(NbMainWindow.java:1076)
    at com.oracle.jdeveloper.nbwindowsystem.NbMainWindow.createStatusBar(NbMainWindow.java:1076)
    at oracle.ide.IdeMainWindow.getStatusBar(IdeMainWindow.java:624)
    at com.oracle.jdeveloper.nbwindowsystem.NbMainWindow.getStatusBarStatic(NbMainWindow.java:228)
    at com.oracle.jdeveloper.nbwindowsystem.NbStatusBar.getStatusLineElement(NbStatusBar.java:23)
    at org.netbeans.core.windows.view.ui.MainWindow$4.run(MainWindow.java:365)
    at org.netbeans.core.windows.view.ui.MainWindow.getStatusLineElements(MainWindow.java:377)
    at org.netbeans.core.windows.view.ui.MainWindow.decoratePanel(MainWindow.java:331)
    at org.netbeans.core.windows.view.ui.MainWindow.initializeComponents(MainWindow.java:248)
    at org.netbeans.core.windows.view.DefaultView.showWindowSystem(DefaultView.java:563)
    at org.netbeans.core.windows.view.DefaultView.windowSystemVisibilityChanged(DefaultView.java:542)
    at org.netbeans.core.windows.view.DefaultView.changeGUI(DefaultView.java:187)
    at org.netbeans.core.windows.ViewRequestor.dispatchRequest(ViewRequestor.java:275)
    at org.netbeans.core.windows.ViewRequestor.processVisibilityRequest(ViewRequestor.java:264)
    at org.netbeans.core.windows.ViewRequestor.postVisibilityRequest(ViewRequestor.java:201)
    at org.netbeans.core.windows.ViewRequestor.scheduleRequest(ViewRequestor.java:121)
    at org.netbeans.core.windows.Central.setVisible(Central.java:140)
    at org.netbeans.core.windows.WindowManagerImpl.setVisible(WindowManagerImpl.java:926)
    at org.netbeans.core.windows.WindowSystemImpl.show(WindowSystemImpl.java:105)
    at org.netbeans.core.GuiRunLevel$InitWinSys.run(GuiRunLevel.java:246)
    at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:251)
    at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:705)
    at java.awt.EventQueue.access$000(EventQueue.java:101)
    at java.awt.EventQueue$3.run(EventQueue.java:666)
    at java.awt.EventQueue$3.run(EventQueue.java:664)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
    at java.awt.EventQueue.dispatchEvent(EventQueue.java:675)
    at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:211)
    at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:128)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:117)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:113)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:105)
    at java.awt.EventDispatchThread.run(EventDispatchThread.java:90)

  50. Hi,

    I have downloaded and started using SQL Developer 4.0, but when opening it the loading bar hangs at the 3rd and a section. Any suggestions? I am using the latest JDK, previously I used sql developer 3.2

    Thank you

    1. thatjeffsmith Post
      Author

      Start the tool using the EXE in your bin directory – that will give you a cmd console window with logging info. When SQL Dev hangs at startup, send a ctrl+break/pause and grab that info and post it here.

  51. Hi Jeff,

    using “Remote Debug”, every time I connect with our program to the database in debug mode a dialogue “Choose default run target” appears which I have to “Cancel”.
    Then when debugging is stopped through SQL developer’s “Terminate” button or through kill of our program an IdeConnection…jpr remains in the “Processes” view and cannot be removed anymore.

    Regards,

    Harald

    1. thatjeffsmith Post
      Author
      1. No, I didn’t.
        Now I read it and it does not help, unfortunately.
        Remote Debugging with SQL Developer 4.0 works well.
        Problems arise if you want to change plsql package code and recompile it as once starting remote debugging, these debug sessions stay open until infinity and there is no way to get rid of them anymore. This prevents recompilation. The only way to get out of this is to restart SQL Developer.
        Any other ideas?

        1. thatjeffsmith Post
          Author

          I’m confused. Why would you make changes to your program and compile it whilst debugging? End your debug session and THEN compile it. I imagine this behavior is the same in previous versions?

          1. Exactly that IS the problem. I want to end the debug session and can’t do it.
            All debug sessions except the first one don’t stop in my environment and the red squared stop button is gray out for these debug sessions, then.
            And no, with 3.2 I had no problems.

          2. thatjeffsmith Post
            Author

            Can you confirm for me that you’re able to end a ‘local’ debug session successfully? Thanks for your patience here.

            Also, this works as expected in v3.2.2, or the issues are localized to version 4? And by that I mean, can you try again with 3.2 now just to make sure? When you say you ‘had’ no problems, I don’t know how long it’s been since you’ve tried and want to make sure nothing in your env has changed other than SQL Developer.

          3. Hi Jeff,

            I can confirm ‘local’ debugging works well.

            And this works as expected in 3.2.20.09.
            Currently I use them side by side. 4.0 for its support of svn 1.7 and 3.2, well, for debugging.
            I can send you some screenshots if that helps. Just tell me where I should send them.

          4. Now, in my tries is something different as the red stop button is not greyed out anymore. Instead I can press the button (without result) and get two kinds of error messages:
            Error during handleEvent on action ‘Terminate’ (id=259).
            None of the attached controllers handled the action.
            – oracle.ide.controller.IdeAction$ControllerDelegatingController@c7e040a5[oracle.ideimpl.controller.MetaClassController@c7e040a5[oracle.ideimpl.runner.RunManagerController]].
            and
            Error during handleEvent on action ‘IdeConnections%23PEGAPLAN+at+tslpxm2_ldap.jpr’ (id=1247).
            None of the attached controllers handled the action.
            – oracle.ide.controller.IdeAction$ControllerDelegatingController@5fabbbcf[oracle.ideimpl.runner.TerminateRunProcessButtons@5fabbbcf].

  52. Hi,

    I currently use 3.2.10.09 with the SVN plug-in and in testing out 4.0, I am unable to connect to the repository using the same parameters. The issue is likely that we are using SVN Bridge to connect to a TFS 2010 repository. Any chance you could support this configuration or is this too much of a stretch?

    Thanks!

    1. thatjeffsmith Post
      Author
      1. Hard to believe, but yes that is what it is. We use TFS because the bulk of the work is in MS tools but the database is Oracle. We prefer to keep the db model in the same repository as the code for obvious reasons. It actually works pretty well and we would be sad to see it stop working. This is the link to the TFS/SVN component:

        http://svnbridge.codeplex.com/

        If this is something you can’t support, we hope that you guys test against the new git capabilities in TFS 2013 because that will also be an option for us when released.

        Thanks!

  53. In the AppData there is a large (30Mb) all-resources.dat file. Wondering what that is, doesn’t seem like it was present in 3.2.2. My guess is its part of the new Framework, all attempts at googling returns reference to NetBeans…

    The real question is, can I move it? AppData is synced by my companies (minute) backup and 30Mb is too much for it to handle.

    1. thatjeffsmith Post
      Author

      If you move it, it will just get recreated at startup. It’s a cache file for the netbeans framework. It’s not a critical file, so if it’s not being backed-up, it’s not a big deal. Your IT folks can black-list if that would help?

  54. Hello
    When I run a script F5, I have no screen output.
    And I get the message: SEVERE 141 0 oracle.ide.controller.IdeAction error during handleEvent action on ‘Run Script’ (id = 186).
    None of the attached controllers handled the action ..
    java version “1.7.0_25”
    Java (TM) SE Runtime Environment (build 1.7.0_25-b17)
    Java HotSpot (TM) 64-Bit Server VM (build 23:25-b01, mixed mode)

    Oracle IDE 4.0.0.12.27
    Java Platform (TM) 1.7.0_05
    Versioning Support 4.0.0.12.27

    1. thatjeffsmith Post
      Author
      1. Hello Any script has the same behavior and worked in previous versions. Even a select sysdate from dual does not have output.

  55. Are we going to see a 4.0 download for “other” platforms like 3.2 has available anytime? I run Ubuntu desktop, an RPM isn’t really useful to me…

    1. thatjeffsmith Post
      Author
    1. thatjeffsmith Post
      Author
      1. Has above bug been fixed for not displaying CLOB data. I am facing slowness when I am trying to fetch rows containing CLOB data. As soon as i selectively chose other columns, output is coming fast.

  56. Hello Jeff,

    Can you run this query as such in sql developer 3.2.20.09 and 4.0.0.12. (just do ctrl+enter NOT F5)

    you can see the output in 3.2 but not in 4.0

    select table_name,column_name,
    dbms_xmlgen.getXMLType( ‘select count(‘||column_name||’) from ‘||table_name )
    from user_tab_cols
    where table_name in (‘EMP’,’DEPT’)
    and column_name =’DEPTNO’

    1. thatjeffsmith Post
      Author
  57. I am using sqldeveloper EA1 version, but has an error, because when I connect to a database the IDE displays a dialog box with the error, but then I never see the connections available, I would like to know is when it leaves the final version or next EA2 for download?

    1. thatjeffsmith Post
      Author

      We’re readying EA2, but

      >>but has an error, because when I connect to a database the IDE displays a dialog box with the error
      What’s the error? We can’t fix the problem if we don’t know about it πŸ™‚

        1. thatjeffsmith Post
          Author
    1. thatjeffsmith Post
      Author
  58. Everything running extremely good in the new version but it seems order of magnitude slower with large SQL queries. Every now and then I need to run a bunch of queries that are 6-7K lines long (each); it takes forever between I paste such a query into the SQL worksheet window and I can execute the query (“forever” = some 40 seconds, more or less). In 3.2 it was some 2 or 3 seconds.

    Any ideas?

    1. thatjeffsmith Post
      Author
      1. Disabling semantic analysis info tips helped a bit (thanks!) but the response is still some 15 seconds (as opposed to v 3.2 – less than a second, just checked a moment ago).

        Any other bells and whistles to disable, to gain some responsiveness?

        1. thatjeffsmith Post
          Author
    2. I’m seeing this too (in fact, it’s what brought me here).

      Big queries (1000+ lines) make the editor incredibly slow, to the point that it’s unusable. Typing is slow. Find+Replace is so slow it looks like it hangs SQL Developer (but actually doesn’t).

      Oh, and I’ve disabled all the option in the “Completion Insight” section. It helps, but it’s unbearably slow.

  59. I’m testing it on my Fedora 19, looks fine for now. Please extend the linux support, the RPM package is the only way to install it.

    1. Hi Adrian,
      I’ve noticed that you are using fedora 19 – I’ve installed sqldeveloper 4 + Oracle JDK 1.7 and I’m not able to run it without sudo.

      Did you manage to start sqldeveloper without sudo?
      Thanks,
      Boris

      1. Hi Boris,
        I’m using OpenJDK 1.8 and it works directly from the kde menu. I had to run from the console the first time and update the /opt/sqldeveloper/sqldeveloper/bin/sqldeveloper.conf file adding an option to use with a JDK. But I never used sudo. Just for install the rpm.
        Maybe is a permissions issue on your OracleJDK.

        1. Hi Adrian,
          Thank you for the reply. I’ve hoped that you were using Oracle JDK… Strange… I’ve tried every possible IDE (Netbeans, Idea, Eclipse…) with my installation of JDK and worked perfectly. I have issues only with Sqldeveloper 4 EA1 and JDeveloper 12c…
          Anyway, thank’s again for the reply.

  60. Has anyone lost the ability to print in Version 4.0.0.12 ?

    A Java message box pops up reporting “No print service found” when accessing “File/Print…” or “File/Page Setup..” options.

    Surprisingly, “File/Print Preview” works, and I’m able to access advanced “Print Options” but all paths to actually generating hardcopy lead to “No print service found.”

    I’m on a Mac. My workaround is to shutdown 4.0, start up 3.3.2 and access printing from there.

    1. thatjeffsmith Post
      Author
    1. thatjeffsmith Post
      Author
      1. I misread point 1 in relation to an issue I’m having getting it up and running. I see now the download link said it’s good.

        On my windows 7 32bit box I now have
        C:\Program Files\Java\jdk1.7.0_25\bin
        but the prompt still won’t accept any java.exe locations I supply.

        1. thatjeffsmith Post
          Author
          1. Yup, trying that as I have done in all versions since, but keep getting
            “Cannot find a Java SE SDK installed at path…”
            This also happens on the 64 bit windows box I just tried.
            Time for forum post?

          2. thatjeffsmith Post
            Author
  61. Hi Jeff,
    Seems “find and replace with regexp” functionality is works much slower, than in version 3.
    If we try:
    1. Paste 1000 rows of text (let it be list of usernames, it doesn’t matter)
    2. Do regexp replace of “^” to “select ‘”
    3. Do regexp replace of “$” to “‘ as dummy from dual union all”
    Lines 2 and 3 works for 10-15 seconds each.
    But if we do it on disconnected worksheet – it finishes in less than 1 second.
    In version 3 both connected and disconnected worksheet works immediately.
    Is it expected behavior? Why?

    Thanks,
    Andrew

  62. Hey Jeff, I’m excited to get into SQL Developer 4 EA but before I do, can I run 3 and 4 at the same time? Or at least install them separately and run them at different times without them walking over each other? I’m on a Mac, OS X 10.8.

    Thanks,
    Abe

    1. thatjeffsmith Post
      Author
    1. thatjeffsmith Post
      Author
  63. Dear Jeff, many thanks for this great release.

    I noticed that the navigation bookmark shortcuts ctrl+k/ctrl+q in the code editor are not working. Has this functionality changed since v3.2?

    Thanks, Chris.

    1. thatjeffsmith Post
      Author
  64. Let me first congratulate you on this new release! I really like the look and feel of it and it even seems to be a bit snappier than version 3. I got a question an a bug-report though:

    When exporting a huge dataset to *.xls or *.xlsx in version 3 of SQLDeveloper the export was getting slower and slower the more rows you were exporting until it almost came to a halt (just “almost” because it was still exporting, but only 1-10 rows or fewer per second!). Is this bug fixed already? I think I read somewhere that this should be fixed in the next version. Didn’t get to try it out yet.

    And for some bug-reports:
    https://forums.oracle.com/thread/2561742
    Didn’t know where to post them else.

    Regards
    Markus

    1. thatjeffsmith Post
      Author

      The Excel export bug – where memory wasn’t being released as records were streamed in and written to the file – is FIXED in version 4.0. It required a library update, and the new code works beautifully.

      However, you MUST use the XLSX export formatter. The XLS option will continue to to operate as it has before.

      But reports go to our SQL Developer forum

    2. I’m seeing the same issue. When exporting to Excel, the task at the bottom used to show the Record Count as it was running. Now it just shows a bar that states: “Running”.

      1. Hi Jeff,
        First thanks for your article, being an intensive SQL developer, I really appreciate the quality of your answers here.

        That being said, I was using SQL developer 3.1 and it was impossible for me to export data to XLSX when the number of rows was too high (because of this memory leak you talked about).
        With SQL Developer 4.0.2, this limitation issolved (I was ble to export about 100k rows x 33 columns and the memory used is not increasing over time) but the export is still very slow when the data grid in SQL developer displays all the rows (about 10-20 rows by second apparently – 2h needed forthe 100k rows export, same for csv / text export). This performance issue is not present when exporting without showing all the rows (if only the first 500 rows are displayed for exemple, the full export ok 100k rows is done in only few seconds).
        Is this a known issue?

        Thanks for your help.
        Regards,
        JF

        1. thatjeffsmith Post
          Author

          Why are you reading all the rows into the grid first? You don’t want to run the query again with the export? I imagine reading the queries directly out of the resulset off the cursor handle in JDBC is faster than reading them out of the grid. Esp for that many rows.

  65. Another small thing… I noticed the record counter that used to accompany the export function is not longer there, i.e. x lines exported.

    1. thatjeffsmith Post
      Author
      1. It was in the task/notification bar at the bottom right of the main window, in the same place it tells you line x column y etc. In v4 is just says running, whereas in 3.2 it said Rows x and kept a count of rows exported.

        1. thatjeffsmith Post
          Author

          Thanks James!

          Ok, I’m in version 3.2.20.09, open a worksheet.

          Run a query, select * from scott.emp;

          Execute with Ctrl-Enter.

          Export the grid to ‘delimited -> Clipboard’

          Hit OK, data is exported.

          Not seeing the records exported feedback in that area…are you doing something slightly different?

          1. Sorry, should have said I’m exporting to Excel. I sent you a couple of screenshots to illustrate.

          2. I’m seeing the same issue. When exporting to Excel, the task at the bottom used to show the Record Count as it was running. Now it just shows a bar that states: β€œRunning”.

  66. Any pointers how to install JDK 1.7 without having it be my default. Java 1.7 is not working for EBS forms sessions with my current client (still stuck on using 1.6 version).

    I would like to install 1.7, but I don’t want my browsers (firefox/IE) to use the 1.7 plugins. I still need them to invoke the 1.6 plugins?

    Will your recommendation on the PATH setting accomplish this?

    1. thatjeffsmith Post
      Author

      JDK 7 has nothing to do with the Java that runs in your browser…however if you don’t want to break your applications that require Java 6 JDK/JREs, then yes, remove the JDK7 from your PATH and make sure the Java 6 one remains.

      And then just tell SQL Developer where your 7 install is.

      1. Thanks. Missed the option on the JDK installer for “Public JRE”. I choose not to install the JDK with this component. This ensured that the Runtime Java on my machine was not updated (and is still 1.6). When I launch SQL Developer, it automatically found the JDK 7 install location.

        Things are working so far.

        Thanks!

    1. thatjeffsmith Post
      Author
  67. Hi!
    In the new 4-th version the Code Template’s shortcut key disappeared. Could you help me where from I can configure some one? I used that function every time and now without it it’s slowly for me to write SQL-s.
    ==============================================
    Some proposals for improvement of SQL Developer.
    ——————————————————————————–
    1). In “EditPlus 3” text editor there is a functionality where one can define own word’s delimiters. If you go to it’s Tools menu -> Preferences -> General, there is a field named “Word delimiters”. Here if you define “-;()” for delimiters, and if in the Editor you have a date for ex. “(20-07-2013);”, and if you double click with the mouse on the date the selected words would be only the numbers where the cursor was placed, but if you define for delimeters “;()” and you double click again on the date, the whole date will be selected. And that will also highlight the other occurrencies of that string in the file.
    I would like to see in SQL Developer such functionality.
    2). Like “Eclipse IDE” to have the possibility to replace all occurrencies (and to see immediately the changes) with a shortcut key combination. There the default is “Ctrl+2,R”.

  68. Liking the time saver tweaks in this EA tester edition, I use the query builder alot, a good enhancement to this would be an option to default the building of the graphical view of the query to a collapsed nature with a toggle to expand the individual table to selecting fields.

    Makes it easier to graphically understand the query and rearrange the table objects (drag/drop) without the need to spend ages reducing the length to table with 200+fields in of which or dragging tables to rearrange at one screen length at a time, an option could be to set how many fields to table expands to as a default ie 10 fields, rest you get to by scrolling through the list and have the toggle that cycles through 3 states when clicked – Minimised, Default, Maximised

    I notice on the right click on a graphical table an option to fully expand, so the toggle could be linked to this right click option

    1. thatjeffsmith Post
      Author
  69. Hi!
    I have the strange issue, that a CTAS takes 10 seconds in SQL Developer 3.2.2, but nearly 80 seconds in 4.0. We are using a 11.2.0.3 Oracle Database, SQL Developer shouldn’t be changed from standard configuration, only the Java Edition should differ (3.2.2 is running with a Java version included in the package, 4.0 with newest JDK version)

    1. thatjeffsmith Post
      Author
  70. Hi Jeff , just to say that font smoothing in code editor looks really wonderful in this version , minor issue is that favorite font monaco cannot be rendered correctly ( win7, 64bit ) , nevertheless fantastic job! Cheers

    1. thatjeffsmith Post
      Author
  71. Hi Jeff, with 4.0 I can’t double click a procedure name in the Package-Body on the left (under connections) anymore to jump directly to that procedure.
    Additionally, I can’t start procedures from within packages anymore by clicking on the green play button on top or the “AusfΓΌhren”-button (not sure what it is in English) after a right click on the package-body name.
    Still works though with a right-click on the package name.
    All those still worked with 3.2.

    I’m back to 3.2…

    Bye
    WS

    1. thatjeffsmith Post
      Author

      The first thing is a bug that’s already been identified and fixed for our next EA drop.

      The 2nd thing is also a bug – I’ll log that. As a workaround, open the package in the editor and run it from there.

      1. thanks that’s driving me nuts right now …. took me forever just to find this post about something so simple that you take for granted.
        The Go to Subprogram Implementation ????
        Please let me know as soon as I can download the bug fix for this.. πŸ™‚

        1. thatjeffsmith Post
          Author

          The bug I’ve only taken for granted b/c it’s been reported about 30 times so far πŸ˜‰

          But, it’s fixed, and we’re readying another Early Adopter update for version 4.0 now. You won’t have to wait long Kat!

  72. Hi Jeff, when trying to start the instance viewer on 4.0.0.12 I get this error:

    Problem initializing the JavaFX runtime. This feature requires JavaFX.
    JAVAFX_HOME=null

    java.lang.NoClassDefFoundError: javafx/embed/swing/JFXPanel
    at oracle.dbtools.raptor.dba.navigator.actions.dbagraphics.JFXPanelFactory.createJFXPanelImpl(JFXPanelFactory.java:82)
    at oracle.dbtools.raptor.dba.navigator.actions.dbagraphics.JFXPanelFactory.createJFXPanel(JFXPanelFactory.java:47)
    at oracle.dbtools.raptor.dba.navigator.actions.dbagraphics.FxQueryViewer.createViewerUI(FxQueryViewer.java:186)
    at oracle.dbtools.raptor.oviewer.base.AsynchronousViewerEditor.oldGetGUI(AsynchronousViewerEditor.java:402)
    at oracle.dbtools.raptor.oviewer.base.AsynchronousViewerEditor.getEditorContentImpl(AsynchronousViewerEditor.java:213)
    at oracle.dbtools.raptor.oviewer.base.AsynchronousViewerEditor.getEditorContent(AsynchronousViewerEditor.java:188)
    at oracle.ide.editor.AsynchronousEditor$2.run(AsynchronousEditor.java:347)
    at oracle.ide.editor.AsynchronousEditor$5.run(AsynchronousEditor.java:552)
    at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:1432)
    at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:2044)

    Where do I set the javafx_home ? I am running Windows 7 64 bit jdk 1.7u25
    Thanks

    1. thatjeffsmith Post
      Author

      Congrats on actually finding that ‘feature.’ It’s not supposed to be there πŸ™‚

      So the bug is that you’re able to see it. The fix will mean that it’s going away, although it may come back at some point.

  73. Upgraded to 4.0 from 3.2 and I’m seeing an error in the extensions log every time I start SQL Developer – ‘Error: Resource not found: ${SCRATCH_COMMAND_ICON}.’ Double clicking takes me to this line of XML – ‘res:${SCRATCH_COMMAND_ICON}’

    The error doesn’t seem to cause any problems for me, just thought I’d mention it.

    Great release by the way. Loving the new database object search!

    1. thatjeffsmith Post
      Author
  74. Unfortunately we are unable to upgrade to Java JDK 1.7 because our Oracle Forms 10g applications do not work with Java 1.7 and upgrading to Oracle Forms 11g will not be occurring in the near future. Is there any way to run SQL Developer 4.0 under Java 1.6? If not, we will be using SQL Developer 3.2 for a long time now.

    Thanks,
    Mike

    1. thatjeffsmith Post
      Author

      Fortunately you CAN upgrade.

      You can have as many versions of Java on your machine as you want. You can run Java 6 for 10g Forms and Java 7 for SQL Developer 4 without any problems. Just don’t put the Java 7 dir in your path – that would probably mess up Forms – and then when prompted for Java by SQL Dev, point to the Java 7 install directory.

      Let me know if you have any questions.

      1. After installing Java 7 JDK (which includes the JRE) on the Windows OS if you have an Oracle Forms 10g application that will no longer run (bogus Oracle Jinitiator version too low error) because of the 7 JRE, via the Java 7 Control Panel you can add the following Java 7 Runtime Parameter -Djava.vendor=”Sun Microsystems Inc.” so SQL Developer 4 runs and the Oracle Forms 10g will run.

        1. thatjeffsmith Post
          Author

          It sounds like you’re hacking the Java 7 install to trick Forms into running it, instead of setting up your machine to have SQL Developer use Java 7 and have Forms use Java 6. It might ‘work’, but don’t come looking at us if weird things start to happen.

    1. thatjeffsmith Post
      Author

      I always like to hear about annoying issues being fixed πŸ™‚

      However we already have new bug reports rolling in, so be sure to let us know on the Forums if you run into anything that doesn’t seem right!

  75. SVN 1.7 – wonderful!
    Tried GIT, but was unable to get it to work – is it supposed to be functional? When I put in my remote repo info in the clone dialog it won’t advance to the next screen.

    SVN was one thing that was keeping my developers away, the other was the ‘project’ concept – you can create a collection of objects as a project and open them together. This is an accepted feature request I was hoping would be in 4. Do you know if it is on the radar?

    1. thatjeffsmith Post
      Author
      1. Hi Jeff. Does this mean that if I have more chance of resolving the git problem in the jdk rather than SQL Developer itself? Thanks, Patrick

        1. thatjeffsmith Post
          Author
          1. I was having the same problem as described by Pete 11 months ago: when cloning from GIT I couldn’t do it – working on an xp machine and having loaded SQL Developer a couple of times on to it. Now I’ve tried it with a Vista machine and I have cloned successfully.

            I was hoping to use GIT to manage versions of a logical data model without any physical implementation yet. I have a feeling I can’t do that and so must use Subversion. Is that right?

            Thanks for your help by the way – great product

          2. thatjeffsmith Post
            Author

            The Versioning support in the Modeler is built specifically for Subversion. We’ve talked about building in support for Git as well, but it’s not a top line priority at the moment.

    2. thatjeffsmith Post
      Author
        1. thatjeffsmith Post
          Author
  76. Will a separate JDK download be required during just the early-adopter period or will it still be required with the release version?

    1. thatjeffsmith Post
      Author

      That remains somewhat unknown. For the time being, assume that it will be required going forward. If we can get it figured out internally – it’s NOT a technical challenge – then we’ll do it.

  77. Couple of Things are really missing (or I don’t find) in sql developer 4.0

    1) AskTom search in sql developer 3.2.2 not available in 4.0

    2) Tools->preference->Environment – I don’t find “Theme:” options in 4.0 where as it is available in sql developer 3.2 ( which I use “desert blue” as my favorite)

    1. thatjeffsmith Post
      Author

      1. That will be coming back – the search bar is an extension that we haven’t refactored for the new JDev Framework yet.
      2. Unfortunately the ability to choose/customize themes is something the new JDev Framework deprecated. However, if you you really like the ‘desert blue,’ set it in your 3.2 install, get 4.0 going, and say ‘Yes’ to importing the settings from 3.2. The theme might get carried over. It was for me, although technically it’s a bug and I can’t guarantee that that will work for long.

      1. Hi Aldo, I had the same problem, I solved it by adding JAVAFX_HOME system variable and pointed it to my JDK7 path:
        JAVAFX_HOME = C:\Program Files\Java\jdk1.7.0_25\jre

Leave a Reply

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