Windows installs will attempt to auto-find the JDK for you on the first run – if you’re in 64-bit mode, run the 64.exe in the bin directory and we’ll look for the 64bit JDK – once it’d defined, you can run the main dir exe again

Related Posts

Comments 296

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

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.

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.

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?

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.

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?

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.

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

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

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?

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

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

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

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.

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

But.

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

I’m here if you want to help.

Feel free to contact me offline at [email protected] and please feel free to be as honest and brutal with your feedback as you feel comfortable with.

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

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

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

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

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.

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.

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

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

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

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

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

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

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

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.

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.

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?

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.

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?

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…

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.

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

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.

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.

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.

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

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.

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.

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

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.

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.

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.

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.

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.

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.

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

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.

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

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?

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.

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?