288 responses

  1. Rajesh
    July 12, 2013

    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)

    • thatjeffsmith
      thatjeffsmith
      July 12, 2013

      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.

      • Max
        August 8, 2013

        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

  2. Aaron
    July 12, 2013

    Will a separate JDK download be required during just the early-adopter period or will it still be required with the release version?

    • thatjeffsmith
      thatjeffsmith
      July 12, 2013

      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.

  3. Pete
    July 12, 2013

    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?

    • thatjeffsmith
      thatjeffsmith
      July 12, 2013

      The GIT thing could be a bug, sounds like our developer is on it. This is something we pulled directly from JDeveloper. I’ve found a few blogs that go into more detail…

      http://chadthompson.me/2012/12/12/why-use-git-with-jdeveloper/
      http://tompeez.wordpress.com/2012/12/09/jdeveloper-11-1-1-6-0-the-git-experience-part-1/

      I’m not aware of any major work for SVN in 4.0 other than the upgrade which brings support for 1.7

      • Patrick Cloughley
        June 30, 2014

        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

      • thatjeffsmith
        thatjeffsmith
        June 30, 2014

        I don’t know of any issues with GIT in SQL Developer 4.0.2 – what are you seeing?

      • Patrick
        July 1, 2014

        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

      • thatjeffsmith
        thatjeffsmith
        July 1, 2014

        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.

    • thatjeffsmith
      thatjeffsmith
      July 15, 2013

      Workaround on the GIT issue is detailed on the forums

      • Pete
        July 15, 2013

        Thanks – that was actually my post on the forum :-) and I was able to get it to work on my Mac by using what was posted, I posted my findings there.

        The “project” concept that I asked about was actually not part of SVN, the new feature request I was referring to is https://apex.oracle.com/pls/apex/f?p=43135:7:2209008165526::NO:RP,7:P7_ID:301

      • thatjeffsmith
        thatjeffsmith
        July 15, 2013

        That feature MIGHT be implemented via the Cart. We’re excited by the possibilities of extending the Cart beyond simple deployment tasks. Stay tuned :)

  4. maxolasersquad
    July 12, 2013

    Is the platform-independant download going to be made available? I had to download the rpm and extract the sqldeveloper folder from there.

  5. Sujoy
    July 15, 2013

    Trying it out now. Quite happy to note that a few annoying issues are fixed. Also an import issue about which I had commented on http://www.thatjeffsmith.com/archive/2012/04/how-to-import-from-excel-to-oracle-with-sql-developer/ works fine now!

    • thatjeffsmith
      thatjeffsmith
      July 15, 2013

      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!

      • Sujoy
        July 15, 2013

        Did that already :)

  6. Michael Rife
    July 15, 2013

    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

    • thatjeffsmith
      thatjeffsmith
      July 15, 2013

      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.

      • Michael Rife
        September 10, 2013

        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.

      • thatjeffsmith
        thatjeffsmith
        September 11, 2013

        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.

  7. James
    July 16, 2013

    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!

    • thatjeffsmith
      thatjeffsmith
      July 16, 2013

      yeah, everyone is seeing that – harmless but annoying

      Thanks for the feedback on the object search stuff – be sure to let us know if you see any ways to improve it!

  8. Syed Jaffar Hussain
    July 16, 2013

    Thanks Jeff. I have just configured it and ready to explore the new features.
    Thanks much once again to the team and you for the great efforts you people put in for this product.

  9. Aldo
    July 16, 2013

    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

    • thatjeffsmith
      thatjeffsmith
      July 16, 2013

      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.

  10. WS64
    July 17, 2013

    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

    • thatjeffsmith
      thatjeffsmith
      July 17, 2013

      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.

      • Kat
        September 4, 2013

        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.. :)

      • thatjeffsmith
        thatjeffsmith
        September 4, 2013

        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!

  11. boris
    July 18, 2013

    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

  12. Karl Dall
    July 18, 2013

    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)

    • thatjeffsmith
      thatjeffsmith
      July 18, 2013

      try running that with autotrace, it’s F6 in the worksheet

  13. Dave
    July 20, 2013

    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

    • thatjeffsmith
      thatjeffsmith
      July 20, 2013

      I kind of like that idea..let me see where that goes :)

  14. Janko
    July 20, 2013

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

  15. Bazinou
    July 22, 2013

    Hi

    Be careful if you use SQL Developer with xmltype column, there is a bug in 4.0 :
    https://forums.oracle.com/message/11105913

    :(

    • thatjeffsmith
      thatjeffsmith
      July 22, 2013

      Yes, a big bug, and it’s being exterminated with extreme prejudice. And it’s messy, not that that matters, but yeah. Stay tuned.

  16. Jason
    July 23, 2013

    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?

    • thatjeffsmith
      thatjeffsmith
      July 23, 2013

      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.

      • Jason
        July 23, 2013

        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!

  17. James
    July 24, 2013

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

    • thatjeffsmith
      thatjeffsmith
      July 24, 2013

      Where are you seeing the record counter in 3.2 James? I’ve been using 4 for so long now I’m starting to lose my ‘before 4′ awareness :)

      • James
        July 24, 2013

        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.

      • thatjeffsmith
        thatjeffsmith
        July 24, 2013

        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?

      • James
        July 24, 2013

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

      • Kevin
        August 1, 2013

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

  18. Markus
    July 24, 2013

    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

    • thatjeffsmith
      thatjeffsmith
      July 24, 2013

      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

    • Kevin
      August 1, 2013

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

      • JF
        August 22, 2014

        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

      • thatjeffsmith
        thatjeffsmith
        August 22, 2014

        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.

  19. Christos Michalislis
    July 24, 2013

    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.

    • thatjeffsmith
      thatjeffsmith
      July 24, 2013

      Broken, and we’re waiting on a fix. Not an intentional change, grrr.

  20. pekkle
    July 25, 2013

    Just wonder how to copy text from Script Output in the new sqldev 4.0

  21. Alessandro
    July 25, 2013

    Would you be so kind as to comment about this issue WRT 4.0? https://forums.oracle.com/message/10645708

    TIA.

    • thatjeffsmith
      thatjeffsmith
      July 25, 2013

      The thread is too long, and from what I can understand from Vadim’s responses, it’s working as advertised.

  22. Abe
    July 25, 2013

    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

    • thatjeffsmith
      thatjeffsmith
      July 25, 2013

      You sure can! You can run both concurrently with no issues, just ‘install’ them to separate directories.

  23. Andrew
    July 26, 2013

    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

  24. Scott
    July 28, 2013

    Darn it, I just realise is the place most convenient to start trying this out is 32bit :-(

    • thatjeffsmith
      thatjeffsmith
      July 29, 2013

      We’ll run just fine in 32bit world, why is that bad?

      • Scott
        July 29, 2013

        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.

      • thatjeffsmith
        thatjeffsmith
        July 30, 2013

        You just select the directory and hit ‘OK.’

      • Scott
        July 30, 2013

        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?

      • thatjeffsmith
        thatjeffsmith
        July 30, 2013

        Probably faster than trading comments back and forth :)

  25. Vacationlander
    July 29, 2013

    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.

    • thatjeffsmith
      thatjeffsmith
      July 29, 2013

      It’s working for us internally. Could you post this to the Forums?

  26. Scott
    July 30, 2013

    yeah, it’s like you’re across the other side of the world or something!

  27. Adrian
    July 30, 2013

    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.

    • Boris
      August 6, 2013

      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

      • Adrian
        August 6, 2013

        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.

      • Boris
        August 7, 2013

        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.

      • Natividade
        October 3, 2013

        unset GNOME_DESKTOP_SESSION_ID

      • Natividade
        October 3, 2013

        Hi Boris.
        You solve the problem?

      • edvm
        November 7, 2013

        Magic! Thanks Natividade, i have no idea why, but ‘unset GNOME_DESKTOP_SESSION_ID’ did the magic :)

      • gavin
        January 29, 2014

        i could kiss you Natividade!!

  28. Piotr
    July 31, 2013

    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?

  29. marcel
    August 1, 2013

    I can’t setup my SVN repository (same config like in sqldev 3.2).
    ——-
    Repository:
    http://svn.rz.wdr.de:9880/oracle
    TestMessage:
    svn: E160013: ‘/oracle’ path not found: 404 Not Found (http://svn.rz.wdr.de:9880)
    ——-
    same config works fine in sqldev 3.2.

    • thatjeffsmith
      thatjeffsmith
      August 13, 2013

      Can you report this to the forum? I only know enough about SVN to get me in trouble…

  30. Omar Fernandez
    August 13, 2013

    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?

  31. Rajesh
    August 14, 2013

    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’

    • thatjeffsmith
      thatjeffsmith
      August 14, 2013

      Yup, we know XML is busted in 4.0. It’s the biggest priority bug we have to address before we can release the product officially. Stay tuned…

  32. Kesavan
    August 20, 2013

    Table data is not displaying if it have CLOB/XMLTYPE field

    • thatjeffsmith
      thatjeffsmith
      August 20, 2013

      Yes, a known bug we’re working on now.

      • Apoorv
        October 6, 2014

        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.

  33. Kevin
    August 22, 2013

    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…

    • thatjeffsmith
      thatjeffsmith
      August 22, 2013

      Just grab the Windows ZIP downlaod (I believe that should work just fine) – but yes, you’ll see the other platforms added. And PROBABLY a Windows w/64 bit JDK. Stay tuned.

      • Kevin
        August 22, 2013

        Duh. Yep, that works fine. Up and running on Ubuntu 12.1. Thanks.

  34. Natividade
    August 23, 2013

    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

    • thatjeffsmith
      thatjeffsmith
      August 23, 2013

      Hmmm, does the same script work in version 3.2.2.20 – or is this ALL scripts?

      Can you run in debug mode and get the full log?

      • Natividade
        August 23, 2013

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

  35. Natividade
    August 23, 2013
  36. Mark
    August 27, 2013

    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.

    • thatjeffsmith
      thatjeffsmith
      August 27, 2013

      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?

  37. Jonathan Trumbull
    August 27, 2013

    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!

    • thatjeffsmith
      thatjeffsmith
      August 27, 2013

      Ummmm, yeah. I didn’t even know this was possible. So if I understand, you’re faking SVN and you’re actually versioning your files in TFS?

      • Jonathan Trumbull
        August 27, 2013

        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!

  38. Heggman
    August 29, 2013

    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

    • thatjeffsmith
      thatjeffsmith
      August 29, 2013

      Have you read Barry’s blog on how to setup remote debugging in SQLDev?

      • Heggman
        September 2, 2013

        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?

      • thatjeffsmith
        thatjeffsmith
        September 2, 2013

        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?

      • Heggman
        September 3, 2013

        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.

      • thatjeffsmith
        thatjeffsmith
        September 3, 2013

        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.

      • Heggman
        September 3, 2013

        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.

      • Heggman
        September 4, 2013

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

  39. James Macdonald
    August 31, 2013

    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

    • thatjeffsmith
      thatjeffsmith
      August 31, 2013

      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.

  40. James Macdonald
    September 2, 2013

    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)

  41. Michael
    September 5, 2013

    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

    • thatjeffsmith
      thatjeffsmith
      September 5, 2013

      Does the same thing happen when you try to execute it – a blank pl/sql calling block?

      • Michael
        September 5, 2013

        Yes, it’s everytime blank and nothing happens ……

      • thatjeffsmith
        thatjeffsmith
        September 5, 2013

        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?

  42. Nelson
    September 9, 2013

    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

    • thatjeffsmith
      thatjeffsmith
      September 9, 2013

      It sounds like your java install is borked. Do you have SQL Developer 3.2 installed, if so, does it also ‘not work?’

      Can you try re-installing Java 7?

      • Adrian
        September 12, 2013

        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 :).

      • Jeroen Baten
        December 23, 2013

        Yep, worked for me. Thanks!

      • Peter
        January 10, 2014

        Thanks a lot!

      • Stephen
        January 29, 2014

        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.

      • Flo
        April 30, 2014

        Thank you

      • Frank
        May 26, 2014

        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

      • Renato
        May 3, 2014

        Thank you! You saved my day! All the best!

      • Ben Narendren
        July 26, 2014

        It works! Thanks for posting this.

  43. artso8
    September 12, 2013

    I have same problem with start SQL Developer 4 on Fedora 19 and Oracle JDK 7u40.
    SQL Developer and Oracle JDK installed from RPM.

  44. Andraly Ng
    September 13, 2013

    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.

    • thatjeffsmith
      thatjeffsmith
      September 13, 2013

      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

      • Andraly Ng
        September 13, 2013

        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.

  45. jonathan
    September 13, 2013

    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. jovial
    September 16, 2013

    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.

    • jovial
      September 17, 2013

      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

      • thatjeffsmith
        thatjeffsmith
        September 17, 2013

        That’s as designed. The database is making a connection back to your computer. If you put localhost in, it will only work if the database and sql developer are running from the same machine.

      • jovial
        September 22, 2013

        It used to work in previous version without that option enabled.
        Do I have to see the host input dialog every time I try to debug?

  47. Paul Stuart
    September 16, 2013

    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

    • thatjeffsmith
      thatjeffsmith
      September 16, 2013

      We’re grabbing the SQL_ID’s for the queries in your worksheet. These are then available for the new Explain Plan feature discussed here.

    • thatjeffsmith
      thatjeffsmith
      September 18, 2013

      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?

  48. Paul Stuart
    September 17, 2013

    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

    • thatjeffsmith
      thatjeffsmith
      September 17, 2013

      If the query is in your worksheet, just use the explain plan drop-down, it will show the SQLID of the query at the cursor. Does this give you what you want?

      • Paul Stuart
        September 18, 2013

        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

      • thatjeffsmith
        thatjeffsmith
        September 18, 2013

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

      • thatjeffsmith
        thatjeffsmith
        September 18, 2013

        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.

  49. Paul Stuart
    September 20, 2013

    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

    • thatjeffsmith
      thatjeffsmith
      September 20, 2013

      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.

  50. Aloupha
    September 20, 2013

    I am having issues loading developer, I keep getting the “Cannot find a Java SE SDK installed at path:..” error.

  51. Thiru
    September 28, 2013

    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.

    • thatjeffsmith
      thatjeffsmith
      September 28, 2013

      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?

      • Thiru
        September 28, 2013

        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.

  52. Thiru
    September 28, 2013

    on v1.5.5
    SELECT * FROM DUAL ;
    is as fast as SQLPLUS session response time.

    • thatjeffsmith
      thatjeffsmith
      September 28, 2013

      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?

      • Thiru
        September 28, 2013

        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 ?

      • Thiru
        September 30, 2013

        yes my colleges also facing the same issue with v4.0

    • Thiru
      September 30, 2013

      Status progression in v4.0 shows following event “waiting for statement runner task to finish” for longer time.

      • thatjeffsmith
        thatjeffsmith
        September 30, 2013

        I need to punt this to a developer – I’ve asked for backup and will let you know when I have more info or advice for you Thiru.

  53. Simon Greener
    October 10, 2013

    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

    • thatjeffsmith
      thatjeffsmith
      October 11, 2013

      I replied back directly to your email address, let me know if you don’t get my message.

      • Elan
        December 10, 2013

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

        Much appreciated.
        Elan

      • thatjeffsmith
        thatjeffsmith
        December 10, 2013

        The instructions pretty much remain unchanged – the problem is that version 4 requires all of the 3rd party extensions to be updated. Until they are, they won’t be compatible.

      • RoberR
        April 7, 2014

        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?

      • thatjeffsmith
        thatjeffsmith
        April 7, 2014

        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?

      • RoberR
        April 7, 2014

        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?

      • thatjeffsmith
        thatjeffsmith
        April 7, 2014
  54. Carl Daver
    October 11, 2013

    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.

    • thatjeffsmith
      thatjeffsmith
      October 11, 2013

      >>the latest jtds drivers from MS for JDK7
      Yeah, don’t do that.

      I think you’ll need v1.3.

      • Carl Daver
        October 11, 2013

        Yup, works with 1.3. Thanks.

  55. Todd
    October 12, 2013

    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

    • thatjeffsmith
      thatjeffsmith
      October 14, 2013

      Todd,

      Did you see File > Reopen ? You should see your list of files there.

      • Todd
        October 14, 2013

        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

      • thatjeffsmith
        thatjeffsmith
        October 14, 2013

        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.

      • DJM
        October 21, 2013

        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++

      • Greg
        January 6, 2014

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

      • thatjeffsmith
        thatjeffsmith
        January 6, 2014

        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.

  56. Todd
    October 14, 2013

    Thanks, Jeff :)

    • kombrink
      October 28, 2013

      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.

  57. Jana
    October 24, 2013

    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=’?

    • thatjeffsmith
      thatjeffsmith
      October 24, 2013

      Someone wrote an extension that does this, you can find it here
      http://javaforge.com/project/schemasel

      It’s not compatible for v4, but you can use it in v3.2.2.

    • thatjeffsmith
      thatjeffsmith
      October 24, 2013

      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.

  58. ad
    October 31, 2013

    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.

    • thatjeffsmith
      thatjeffsmith
      October 31, 2013

      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.

      • ad
        October 31, 2013

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

      • thatjeffsmith
        thatjeffsmith
        October 31, 2013

        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.

      • ad
        October 31, 2013

        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.

      • thatjeffsmith
        thatjeffsmith
        October 31, 2013

        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.

      • ad
        October 31, 2013

        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.

      • thatjeffsmith
        thatjeffsmith
        October 31, 2013

        So you tried running from the bin directory…and?

        I’ll only disagree on the ‘kludge’ bit. A busy connection requires a new one to do additional work.

      • ad
        October 31, 2013

        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.

  59. David
    November 19, 2013

    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

    • thatjeffsmith
      thatjeffsmith
      November 21, 2013

      It seems to be working for me.

      I added a rollback to the script, ran it. Then opened the debug dialog again and it was still there.

  60. Greg
    November 20, 2013

    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.

    • thatjeffsmith
      thatjeffsmith
      November 20, 2013

      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.

      • Greg
        November 20, 2013

        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.

      • thatjeffsmith
        thatjeffsmith
        November 20, 2013

        Awesome! Well, awesome that you got it working, not that we borked up your settings.

  61. Olivier
    November 21, 2013

    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

    • thatjeffsmith
      thatjeffsmith
      November 21, 2013

      Bug, and fixed :)

      • Olivier
        November 21, 2013

        Thanks Jeff. Any idea about availability ?

      • thatjeffsmith
        thatjeffsmith
        November 21, 2013

        Sorry, we don’t publish release dates due to being a publicly traded company.

  62. Louis
    November 21, 2013

    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

    • thatjeffsmith
      thatjeffsmith
      November 21, 2013

      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]

      • Louis
        November 21, 2013

        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…

      • Louis
        November 21, 2013

        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.

      • Louis
        November 21, 2013

        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

      • thatjeffsmith
        thatjeffsmith
        November 22, 2013

        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

  63. Vincent
    December 3, 2013

    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.

    • thatjeffsmith
      thatjeffsmith
      December 3, 2013

      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.

  64. Navan
    December 10, 2013

    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?

  65. Chris Whelan
    December 10, 2013

    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

  66. Chris Whelan
    December 10, 2013

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

    Regards,

    Chris Whelan

  67. Chris Whelan
    December 10, 2013

    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.

  68. Emil
    December 11, 2013

    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.

    • thatjeffsmith
      thatjeffsmith
      December 11, 2013

      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.

  69. Raphael
    December 12, 2013

    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.

    • thatjeffsmith
      thatjeffsmith
      December 12, 2013

      Why?

      • Raphael
        December 12, 2013

        Because we want to control updates itself in the company, not over the built-in function. As with any software…

      • thatjeffsmith
        thatjeffsmith
        December 12, 2013

        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.

      • Raphael
        December 12, 2013

        Aah, I didn’t know that it was only for the extensions.

        Many Thanks for the quick answers! :-)

  70. Henk
    December 14, 2013

    Hi,
    I have downloaded the 32 bit version of sqldeveloper 32 bit and downloaded the separate jdk (http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html)
    I alway get the error “Cannot find a java se sdk…”
    Am I doing something wrong?

    I have win7 64 bit. I am not installing 64 bit because I was not able in the past to install the sqlserver jtda jar file succesfully.
    I am running now the 32 bit version 3.2.2…

    • thatjeffsmith
      thatjeffsmith
      December 16, 2013

      Try version 4 – it should find your JDK automatically when you run it.

  71. Dinesh
    January 7, 2014

    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

    • thatjeffsmith
      thatjeffsmith
      January 7, 2014

      Why are you passing all that at the command-line?

      Also, you might want to ask this on the forums over on OTN.

  72. Olivier
    January 8, 2014

    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

  73. Ciprian
    January 21, 2014

    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.

    • thatjeffsmith
      thatjeffsmith
      January 21, 2014

      For the diff script, if you hit the first button in the toolbar of the Dif report, it will give you a file with ALL of the object script output.

      • Ciprian
        January 22, 2014

        Super thanks, feeling a bit noob for missing it. 😀
        Do you think the replacement for the shuttle control makes any sense?

      • thatjeffsmith
        thatjeffsmith
        January 22, 2014

        I have a few things I’d like to do around improving the DIFF feature. I’ll add this suggestion to our list of what’s under consideration.

  74. Olav Jordens
    January 23, 2014

    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

    • thatjeffsmith
      thatjeffsmith
      January 27, 2014

      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.

  75. arnold
    February 20, 2014

    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.

    • thatjeffsmith
      thatjeffsmith
      February 20, 2014

      what version are you running and is is SQLDev or SQL Dev DM?

  76. Freydie
    February 24, 2014

    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

  77. Zach
    March 12, 2014

    For people having issues installing multiple JDKs on one system, you can follow the instructions in this blog: http://www.brucalipto.org/java/how-to-create-a-portable-jdk-1-dot-7-on-windows/ which will show you how to make a portable jdk 1.7 that can be included in sqldeveloper 4.0. Then just update sqldeveloper.conf to point to the folder and you’re all set!

  78. turkidc
    April 17, 2014

    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…

    • thatjeffsmith
      thatjeffsmith
      April 21, 2014

      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.

  79. Dave
    May 29, 2014

    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.

  80. Toochi
    May 29, 2014

    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

  81. Toochi
    May 29, 2014

    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

    • Toochi
      May 29, 2014

      Pllease pardon the earlier typo with your name.

      • thatjeffsmith
        thatjeffsmith
        May 29, 2014

        You can try upgrading your libraries OR you can get the ‘generic’ windows zip download, unzip it, and run it. So bypass the RPM process entirely.

      • Toochi
        May 30, 2014

        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?

      • Toochi
        May 30, 2014

        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 $*

      • thatjeffsmith
        thatjeffsmith
        May 30, 2014

        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

  82. Toochi
    May 30, 2014

    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

    • thatjeffsmith
      thatjeffsmith
      May 30, 2014

      you probably need to change the file perms to allow for execution, chmod 755 sqldev* should do it – assuming this is just your machine, that should be fine

      • Toochi
        May 30, 2014

        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.

  83. Toochi
    May 30, 2014

    And I installed java without any issue.

  84. Chris
    June 2, 2014

    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?

    • thatjeffsmith
      thatjeffsmith
      June 2, 2014

      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

  85. Ton
    June 5, 2014

    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

  86. ian
    June 6, 2014

    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

  87. Anders
    July 9, 2014

    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?

    • thatjeffsmith
      thatjeffsmith
      July 9, 2014
      • Anders
        July 9, 2014

        Yes i did. But it did not help. Actually also the DBA icon is unusuable.

      • thatjeffsmith
        thatjeffsmith
        July 10, 2014

        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.

  88. Sharon O’Connor
    July 18, 2014

    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?

    • thatjeffsmith
      thatjeffsmith
      July 20, 2014

      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.

  89. Chermanna
    August 28, 2014

    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.

  90. Freddy
    September 10, 2014

    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!

  91. MiRR
    December 30, 2014

    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.

    • thatjeffsmith
      thatjeffsmith
      December 30, 2014

      How does it run for you on the native OS? I get 15-20 second start times on Windows and OS X…

      • MIRR
        December 30, 2014

        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…

      • thatjeffsmith
        thatjeffsmith
        December 30, 2014

        I’m not so sure, I think something else is going on. What version of the OS, SQL Developer, and the JDK are you running?

      • MIRR
        December 30, 2014

        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

  92. Anagha jayan
    January 19, 2015

    Heloo,

    in orcale sql inside the view navigator the DBA is not getting viewed and my os is ubuntu.

    • thatjeffsmith
      thatjeffsmith
      January 19, 2015

      Try resetting the desktop, Window > Reset to Default.

      • Anagha jayan
        January 20, 2015

        Thanku sir it worked

  93. Alannah
    February 9, 2015

    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.

  94. James Hambrick
    February 10, 2015

    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

  95. Kelvin Yu
    May 1, 2015

    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.

    • thatjeffsmith
      thatjeffsmith
      May 3, 2015

      I do :)

      Since you said ‘registry’ I’m guessing you’re on Windows.

      Roaming profiles directory in the Application Data folder for your Windows User.

Leave a Reply

 

 

 

Back to top
mobile desktop