Nearly 7,000,000 Oracle professionals use SQL Developer on a regular basis. Have a question about Oracle SQL Developer? Searched this blog and couldn’t find the answer? Ask away!
If your question is about Oracle Database, SQL, PL/SQL, etc – go Ask Tom!
Feel free to ask anything you want, but I’ll feel free to send you to Support or our Forums if it goes sideways.
Note: This page has turned out way more successful(?) than I would have ever imagined. Please keep these things in mind when asking questions.
- I am NOT support. Don’t expect me to log bugs for you, or give you official timelines on bug fixes, enhancements, or product releases.
- I AM NOT SUPPORT. Don’t open an SR with My Oracle Support AND leave a question here. Pick one and go with it, and when in doubt, go to My Oracle Support.
- I try to answer questions as quickly as possible. If you don’t get an answer, ask me for an update. I may have just forgotten or overlooked your request.
Go!
7,791 Comments
Hello Jeff,
I recently updated my Oracle to Version 4.1.3.20 and it lost all of my passwords for my Database connections along with all of my preferences.
Is there an easy way to restore them?
thank you
Delete your system4.1.3.. directory. Start sqldev again, this time say YES to importing your preferencees from an earlier version
thanks, Jeff, i actually see you have an official post about this too. I’m sorry i asked it again. I will pre-empt keeping my passwords for the future.
Hi Jeff,
I am using SQL Developer 4.1.5 on Linux. When working with files (View ==> Files), is there a way for hidden files and folders to remain hidden in the SQL Developer File navigation tree? I have many hidden files and folders and they are cluttering up the navigation tree and making it hard to find the files I really want to work on.
I am trying to determine a way to modify SQL Developer to read a PKI CAC and use that information (with the prompt for the PIN) for access to an Oracle Database. I know that the docs talk about Strong Authentication and storing certs on the server, but that literally disconnects the cert from the process, and what I am talking about is Multi-factor authentication. Oracle provides tools to do this for Web based applications, but it seems that MF Authentication is missing in connection to the database. Do you have any suggestions on how SQL Developer could be used to do this?
I know we can connect using stuff like YUBIKEY…so you have options
Thanks Jeff. Since this is a DoD customer I don’t think the dongle would be acceptable. I will pursue other options.
we should support pretty much anything the oracle JDBC driver supports – i know there are 2 factor authentication schemes avail
Hi Jeff, I recently upgraded to Windows 10 and downloaded the latest version of SQL Developer(4.1.5). When I launch SQL Developer it is automatically closing at different times. It does not stay open for longer than about 5 minutes and sometimes closes down in seconds. I attempted to launch from the command line and collect the error but it did not provide any information. Can you provide some additional information on what I can try to narrow down the issue?
Thanks,
Jon
open a cmd window, go to the sql developer BIN folder. start the EXE from there
see when it closes, if it prints any info there.
this most closely sounds like an issue where the video driver crashes the JVM – you might just want to update your driver.
Jeff,
When using the instance viewer in Version 4.2.0.16.356, is there a way to show local time instead of GMT on all of the metric graphs?
In Verdion 4.2 of SQLDeveloper, there is a new behaviour in code editor. Just one click is needed to mark a word, which leads to unwanted results:
i.e. when You mark long sections (click at the begin, scroll down hold shift and then click at the end), or when you just want to position the cursor at the end of a word (here the word is marked and you have to click a second time).
Is there a preference to bring back the old editor-behaviour?
no, but i have a bug logged on that
Jeff, Can we join query results and a table to get new results ? for example if i ran one sql and got query result1 now i need to run another sql by using query result1 and table B…is this possible in Sql developer ?
No, you’d what to join your original query to your 2nd query.
SO if query one was
select * from hr.employees
And your 2nd query was
select * from hr.departments
Your 3rd query COULD be
select * from hr.departments a, hr.employees b
where b.department_id = a.department_id
Thanks Jeff, In hyperion we can use results and join with a table that why i asked but any way , it could be the new feature in your new version release.
Thanks
Deepak
This is the closest thing I’ve found to a SQL Developer community, so I thought I’d ask here. I’m trying to get SQL Developer 4.1.3.20 connected to SQL Server 10.50.2500.
I’ve tried both the jtds-1.2 and 1.3 drivers. Due to network and SQL Server configurations outside of my control, I know from connecting other tools (e.g. Oracle Data Integrator) that I have to start any Java-based processes with the -Djsse.enableCBCProtection=false option. I’ve put this in my sqldeveloper.conf file and I see that option reflected in the command that launches SQL Developer.
When I configure the properties in the “SQL Server” tab for a connection and test, I don’t see a database in the dropdown tab and when I test the connection anyway I receive a “DB host closed connection” message. This is the message that I would receive in other tools or test programs when the enableCBCProtection option doesn’t make it to the JVM launch.
Is there something I’m missing here?
Thanks.
Try adding that to the product.conf file. In general, JVM properties are set there.
Official SQL Developer community is here
Latest version of SQLDev, we recommend you use jTDS 1.3.1 JAR
Thanks for the link.
I checked my SQL Developer installation (on Linux) and don’t see a product.conf file. In any case, I verified in Help/About/Properties that the option is being used so I think the issue might be something else.
ahhh, sorry. on *NIX, that would be in your $HOME/.sqldeveloper folder.
you might also be able to edit the connections.xml file and edit the connection entry and insert a connection property to the JBCC URL
Is there any way to quickly jump to a particular column in SQL Developer? I’d like to “Select *” to view the entire row as it is, but scroll over to say column 43 (Brand_Type_Code) to see what the data looks like there. I don’t believe I’ve run across this request before, but it seems like it would be a handy feature.
Thank you!
Nothing like what you’re asking – but the Single Record View might give you some relief?
Yeah, that’s what I thought, but it doesn’t hurt to check.
Thanks again for all you do!
To Whom it may Concern :
Having issues with SqlDeveloper keeps crashing after a few minutes with me loggin in. It just pretty much disappears. Was able to copy debugging info.
Also include the following information:
• The version of SQL Developer you are running
• The version of the JDK you are using
• The OS you are using
• The version of Oracle you are connected to
OS : Windows Server 2008
Java Version 1.8.91
Version Sql Developer : 4.1.3.20….. But really I’ve tried several different versions and I get the same issue.
Oracle version :
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
PL/SQL Release 11.2.0.3.0 – Production
CORE 11.2.0.3.0 Production
TNS for 64-bit Windows: Version 11.2.0.3.0 – Production
NLSRTL Version 11.2.0.3.0 – Production
Below is the debugging info I was able to get. Thanks in advance for your awesome work with sqldeveloper….Unfortunately I couldn’t paste everything because of the character limit..
LOAD TIME : 407UsersCache.fillIn() time = 93 ret==null?: true
2016-12-01 14:09:03
Full thread dump Java HotSpot(TM) 64-Bit Server VM (25.91-b15 mixed mode):
“Background Parser” #63 prio=6 os_prio=0 tid=0x000000001c72d800 nid=0x1354 waiting on condition [0x000000002282f000]
java.lang.Thread.State: TIMED_WAITING (sleeping)
at java.lang.Thread.sleep(Native Method)
at oracle.dbtools.raptor.plsql.BackgroundParser$1.construct(BackgroundParser.java:126)
at oracle.dbtools.raptor.utils.NamedSwingWorker$2.run(NamedSwingWorker.java:115)
at java.lang.Thread.run(Thread.java:745)
“TextBufferScavenger” #61 prio=6 os_prio=0 tid=0x000000001c72c000 nid=0xb10 in Object.wait() [0x000000001b81f000]
java.lang.Thread.State: WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:143)
– locked (a java.lang.ref.ReferenceQueue$Lock)
at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:164)
at oracle.ide.model.FacadeBufferReference$PollingThread.run(FacadeBufferReference.java:145)
“oracle.jdbc.driver.BlockSource.ThreadedCachingBlockSource.BlockReleaser” #58 daemon prio=4 os_prio=-1 tid=0x0000000016908800 nid=0x1b78 in Object.wait() [0x000000001ecdf000]
java.lang.Thread.State: TIMED_WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
at oracle.jdbc.driver.BlockSource$ThreadedCachingBlockSource$BlockReleaser.run(BlockSource.java:327)
– locked (a oracle.jdbc.driver.BlockSource$ThreadedCachingBlockSource$BlockReleaser)
“Timer-2” #55 prio=6 os_prio=0 tid=0x000000001f01e800 nid=0xfcc in Object.wait() [0x000000002410f000]
java.lang.Thread.State: WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
at java.lang.Object.wait(Object.java:502)
at java.util.TimerThread.mainLoop(Timer.java:526)
– locked (a java.util.TaskQueue)
at java.util.TimerThread.run(Timer.java:505)
“status-0” #51 prio=2 os_prio=-2 tid=0x000000001f01c000 nid=0x1ae0 waiting on condition [0x0000000023c0f000]
java.lang.Thread.State: WAITING (parking)
at sun.misc.Unsafe.park(Native Method)
– parking to wait for (a java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject)
at java.util.concurrent.locks.LockSupport.park(LockSupport.java:175)
at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2039)
at java.util.concurrent.DelayQueue.take(DelayQueue.java:211)
at oracle.ide.status.StatusExecutor$StatusQueue.take(StatusExecutor.java:338)
at oracle.ide.status.StatusExecutor$StatusQueue.take(StatusExecutor.java:300)
at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1067)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1127)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
“IconOverlayTracker Timer: null-jdbcNodeInfoType” #46 prio=5 os_prio=0 tid=0x000000001f018800 nid=0x1b6c in Object.wait() [0x0000000023b0f000]
java.lang.Thread.State: WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
at java.lang.Object.wait(Object.java:502)
at java.util.TimerThread.mainLoop(Timer.java:526)
– locked (a java.util.TaskQueue)
at java.util.TimerThread.run(Timer.java:505)
“Timer-0” #45 prio=6 os_prio=0 tid=0x000000001f01a800 nid=0xc18 in Object.wait() [0x000000002325f000]
java.lang.Thread.State: WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
at java.lang.Object.wait(Object.java:502)
at java.util.TimerThread.mainLoop(Timer.java:526)
– locked (a java.util.TaskQueue)
at java.util.TimerThread.run(Timer.java:505)
“WaitCursor-Timer” #44 prio=6 os_prio=0 tid=0x000000001f01a000 nid=0x1350 in Object.wait() [0x000000002315f000]
java.lang.Thread.State: WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
at java.lang.Object.wait(Object.java:502)
at java.util.TimerThread.mainLoop(Timer.java:526)
– locked (a java.util.TaskQueue)
at java.util.TimerThread.run(Timer.java:505)
“WeakDataReference polling” #43 prio=1 os_prio=-2 tid=0x000000001f019000 nid=0x1338 in Object.wait() [0x0000000022f2f000]
java.lang.Thread.State: WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:143)
– locked (a java.lang.ref.ReferenceQueue$Lock)
at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:164)
at oracle.ide.util.WeakDataReference$Cleaner.run(WeakDataReference.java:88)
at java.lang.Thread.run(Thread.java:745)
“RaptorTask: Usage Data” #40 prio=5 os_prio=0 tid=0x0000000016908000 nid=0xe9c waiting on condition [0x000000002272f000]
java.lang.Thread.State: WAITING (parking)
at sun.misc.Unsafe.park(Native Method)
– parking to wait for (a java.util.concurrent.SynchronousQueue$TransferStack)
at java.util.concurrent.locks.LockSupport.park(LockSupport.java:175)
at java.util.concurrent.SynchronousQueue$TransferStack.awaitFulfill(SynchronousQueue.java:458)
at java.util.concurrent.SynchronousQueue$TransferStack.transfer(SynchronousQueue.java:362)
at java.util.concurrent.SynchronousQueue.take(SynchronousQueue.java:924)
at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1067)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1127)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
“Thread-9” #39 daemon prio=5 os_prio=0 tid=0x0000000016907000 nid=0x1448 in Object.wait() [0x000000002242f000]
java.lang.Thread.State: WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
at java.lang.Object.wait(Object.java:502)
at java.util.prefs.AbstractPreferences$EventDispatchThread.run(AbstractPreferences.java:1482)
– locked (a java.util.LinkedList)
Jeff, Wondering if it is possible to execute unittest via sdcli64.exe for a PostGres target e.g. our unit test repository is in Oracle (fine) and works for Oracle target -db (also good) and our Postgres JDBC driver to allows a SQL*developer connection to PostGres ( good/fine/great) BUT : we cannot run a unit test that is testing a PostGres database , from the command line or anywhere else. Works fine for Oracle -db but bot Postgres. We get this sort of error via sdcli64.exe from command line :
“Could not connect to database postgres on localhost. The error encountered was: The connection subtype SDPostgreSQL is not recognized.”
Will the “SDPostgresSQL” connection subtype be supported ever for sdcli64.exe ?? Is there a way for us to extend this ourselves via configuration ?
Ummmm, no.
Ummmm, if you’re trying to be Tom Kyte it helps if you’re Tom Kyte.
I’m just trying to be me.
Hi Jeff,
I’ve started using the SQL Developer Data Modeler tool (4.2.0) and have created a logical model which I want to use with the business users. But some of the attributes have names longer than 30 chars which is a problem when I go to generate the DDL from the relational model. I’m wondering if there is a way (similar to the display entity synonym) to allow long names in the logical model but then have columns names for the relational and physical models.
Also can you recommend any blogs etc (apart from your own obviously!) for new users please.
Many Thanks
N.
hi, found it so please disregard the question.
Can be done via the attributes properties.
Need to go to Logical Model/Entities – expand the entity to show the attributes and then double click the attribute to show the properties.
Regards,
N.
oh good!
btw, other modeler bloggers…
you don’t get better than
Heli
Kent
I am trying to use ‘Oracle SQL Developer’ migration assistant but it errors out without any messages been inserted into ‘MIGRLOG’ table. I have posted the question on stackoverflow where you replied asking for error details which I added but that question was put on hold by some users hence posting it here if you could advise.
Link : http://dba.stackexchange.com/questions/160560/sybase-to-oracle-db-migration
**What has been tried so far:**
Tried using Oracle SQL Developer’s “Migration Assistant” without any luck. It shows errors, not successful.
*Specific questions*:
1. What tools can be used for such migration which converts Sybase objects to Oracle to some extent? Even if we could get partially converted scripts, it can be reviewed and modified manually?
2. Can ‘Sql developer’ be also used or provide any data reconcillation utilities after the migration.?
*SQL Developer Migration assistant errors*
When I run ‘oracle sql developer’ migration assistant, I get error as:
> “Capture failed. Refer to MIGRLOG table in the repository for details”
When I see ‘MIGRLOG’ table, there are no messages at all.
It creates `MigrationLog.xml` file which has below error (same as above). This is just snippet as other info in the xml shows just some class file names. Hence I am unable to research further.
**ERROR**
oracle.dbtools.migration.workbench.core.MigrationLogResourceBundle
SEVERE
oracle.dbtools.migration.workbench.core.logging.MigrationLogUtil
Capture
Enterprise Capture
Capture failed. Refer to MIGRLOG table in the repository for details
oracle.dbtools.migration.workbench.core.ui.FullMigrateTask.doOnlineEnterpriseCapture(FullMigrateTask.java:758)
oracle.dbtools.migration.workbench.core.ui.FullMigrateTask.doCapture(FullMigrateTask.java:601)
oracle.dbtools.migration.workbench.core.ui.FullMigrateTask.doMaskBasedActions(FullMigrateTask.java:400)
oracle.dbtools.migration.workbench.core.ui.FullMigrateTask.doWork(FullMigrateTask.java:314)
oracle.dbtools.migration.workbench.core.ui.FullMigrateTask.doWork(FullMigrateTask.java:147)
oracle.dbtools.raptor.backgroundTask.RaptorTask.call(RaptorTask.java:193)
java.util.concurrent.FutureTask.run(FutureTask.java:262)
oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask.run(RaptorTaskManager.java:554)
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
java.util.concurrent.FutureTask.run(FutureTask.java:262)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
java.lang.Thread.run(Thread.java:745)
oracle.dbtools.migration.workbench.core.logging.LogInfo@4621971a
oracle.dbtools.migration.workbench.core.ui.FullMigrateTask$FullMigrateTaskException: Capture
Enterprise Capture
Capture failed. Refer to MIGRLOG table in the repository for details
what version of SQL Developer?
what version of Sybase ASE?
We have a forum setup JUST for migrations. Suggest you post this there, with the details I asked for.
Also make sure your db user has the privs needed to get all the information out of the database data dictionary.
Ok will post it there too.
The info just for reference is as below :
SQL Developer version : Version 4.0.3.16
Syabase ASE version : 15.7
Oracle version : Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
that’s a really old sqldev…might want to try 4.1.5
I would like to copy and share your Oracle ER Model image, and the link to the article associated with it in a ‘helpful’ document I’ve created for my DB Design and SQL classes. Here is the URL: http://www.thatjeffsmith.com/archive/2013/11/how-to-create-views-for-all-tables-with-oracle-sql-developer/. Please email me with permission or rejection. Thank you kindly.
Absolutely, feel free. Just be aware I’ve been known to make a mistake here and there, so feel free to correct those as you find them 🙂
When I connect SQL Developer to a SQL Server database and run a query, it appears that in the results I cannot double click on the header to sort or click on the filter icon to filter. Are these features disabled when working with SQL Server data?
Maybe/probably. Many/most of the features in SQL Developer are written specifically for an Oracle (or TimesTen) database.
The connectivity for SQL Server allows you to do many things, but it’s there primarily to help you migrate it and its data to an Oracle Database.
Hi Jeff,
Happy New Year and thank you for maintaining this site. I started using SQL Developer on Mac OSX a week ago and find your site very useful. I was a TOAD user on Windows for a long time but find the Mac version of TOAD to be sadly lacking in features. I have mostly been able to find suitable replacements for features and shortcuts that I used in TOAD in my current version of SQL Developer for Mac. But I am facing a peculiar problem. In TOAD for windows, I am able to popup describe packages in the production instance where I have read only access by just typing the package name and hitting F4 (for popup describe). In SQL Developer, however, even though I am able to view the package code using popup describe in the development instance where I have read write access, I get the “No Object Found:” error message when I try to popup describe the same object in the Production instance. Is there a setting that I need to change in SQL Developer that will allow me to popup describe objects in read only databases? This also seems to be the case with custom tables where I have read only access in Production, but I am able to see the table details if I precede it with the schema name. This approach doesn’t seem to work for packages though since the popup describe shows the details of schema user name, user ID and Creation Date instead.
can you give me a scenario…such as
login as user x with y privs to z objects
open worksheet
type ….
try shift+F4
observe code fired as shown in View > Log > Statments
that might be enough for me to see if there’s a problem, or you might see for youself.
You can also try to ctrl+click vs DESC
I am not sure I follow your question completely. In our dev environment, I log in as ‘apps’ user with read and write access. I type in the name of a custom package and use F4 to popup describe the package contents so that I can view the code within the package. In the production environment, I log in with my individual user login to which an IS_USER role has been granted. I believe the access is read only/select for this user role. When I try to use F4 to popup describe, SQL Developer on my mac, it shows me a message that says “No Object Found: “. When I use TOAD on windows, I am able to popup describe the custom package in production. I did notice that SQL Developer automatically opens the popup describe of a package in a new worksheet in editable mode in the development instance whereas TOAD always opens it in read only mode. Could this be causing the issue?
Note: I have mapped the F4 function key as a shortcut for Popup Describe. ctrl+click does not really do anything other than opening the context menu at the cursor from which I can again choose Popup Describe if needed, but this gives the same result. I can see an option to choose View > Log, but there is no submenu under log to choose ‘Statements’. When choosing Log, no additional information screen pops up. The logging page at the bottom of the screen does not have any additional messages either.
Thanks for the help
I tried using SQL Developer on Windows and was able to extract the log Statements from there. Same issue on Windows for Dev vs. Prod. I have the log details in a spreadsheet. Is there a way for me to share the spreadsheet with you?
look at the statements yourself – you should see where we are querying the data dictionary, looking for the object you want to do an DESC on.
run those queries for yourself in a sqlworksheet – is the object you’re trying to DESC coming back from the query? If not, there’s an issue with your security/priv levels in the data dictionary. Or maybe you found a bug.
I have been having this issue with my SQL Developer for several months now. I will open the software and try to connection and it will freeze. I then have to shut the program enough times or shut of computer five plus times. The last time this happened I noticed a error message in the logging page. message “Error in RequestProcessor oracle.ideimpl.usages.UsagesTrackerImpl$3”. This error does not show when you open the program it only showed up when I happen to open the second session of it. I was not in the process of running anything. This is when I am opening the software first thing when I get to work and it starts that freezing issue.
Thanks
try unchecking
preferences > usage reporting > allow automated usage reporting to Oracle
Next time the application freezes, you can use JSTACK program in your JDK/bin folder to grab a stack dump. This can be read to find what the UI blocking process/operation is.
Why does the latest Oracle 12c (Windows 64-bit) include SQL Developer version 3? Why not a newer version?
This makes life very confusing since version 3 does not have the data modeler built in (and some other features like SQL Server connectivity that are discussed widely elsewhere).
Please define, ‘latest.’
But basically, we get to contribute the latest and greatest version of sql developer available when a major new revision of the database is released. when 12c came out, v3.2 was the latest and greatest.
Most of our users don’t run sqldev out of an $ORACLE_HOME, they get a newer version from OTN
Also, SQL Server connectivity is provided by a JDBC driver that you can download from sourceforge – we don’t ship those 3rd party drivers for licensing and other reasons
Happy New Year and thanks for this tremendous service. The CIO is asking me “is there are any java license issues because we use SQLdeveloper”. He’s normally a stay out of the way kind of guy, so someone must be asking him for a response. Is there a tool to check for java lcense compliance? Thanks
Absolutely no worries.
Read this. You fall into category #2 – gratis 🙂
Keywords in licensing that puts you in the ‘free’ bucket are ‘for the sole purpose of running Programs‘
I have reverse engineered a database that has common columns in the tables: CreatedBy, CreatedDate. I want to add a RDBMS Comment to those columns without having to hit each table.
One of the things I did in the past when using Oracle Designer is bulk updates to the metadata repository. In ERwin, this can be done by importing the definitions from a spreadsheet using a macro. ER Studio will interpret these as domains and you can update the domain and the columns will inherit the definition.
I searched to see if anyone had found a way to do this in SDDM. I was thinking that it could be done using a table_template but this will add the columns to tables that do not have them, and it will change the properties from what was RE. I was thinking it could be done with a custom transformation. I also considered editing the XML files directly using Grep for Windows.
Do not want to re-invent the wheel if you have a solution.
I think the best way to go about this today is to do a search for those attributes/columns. Then export that to Excel. Then change the values in Excel, and then import that back to your model – it will update the comments as you’ve entered them in the spreadsheet, back to your data model.
Hi Jeff,
We have installed the Oracle SQL Developer version 4.0.3 in the Citrix Hosted Shared Desktop environment running on top of Windows Server 2008 R2. We have been receiving calls from users that their application is getting crashed less than 2 mins after they launch it. Below is the event viewer log for your investigation. Being a Citrix admin, it is bit challenging for me to fix the issue. Any help from your your end be much appreciated.
Oracle SQL Developer Version : 4.0.3.16
Java(TM) Platform : 1.8.0_112
Log Name: Application
Source: Application Error
Date: 1/3/2017 3:58:30 PM
Event ID: 1000
Task Category: (100)
Level: Error
Keywords: Classic
User: N/A
Description:
Faulting application name: sqldeveloper.exe, version: 0.0.0.0, time stamp: 0x520cfeb5
Faulting module name: ntdll.dll, version: 6.1.7601.23572, time stamp: 0x57fd02d3
Exception code: 0xc0000374
Fault offset: 0x000ce8fb
Faulting process id: 0x6b38
Faulting application start time: 0x01d265ab80e74c27
Faulting application path: C:\Program Files (x86)\Oracle\SQLDeveloper 4.0.3\sqldeveloper.exe
Faulting module path: C:\Windows\SysWOW64\ntdll.dll
Report Id: 5e9fdaf7-d19f-11e6-877d-0050569d0128
Easy peasy – go update the video driver.
It’s a virtual machine running on top of VMWare ESXI. However i do see only “VMWare SVGA 3D” as a driver. Also when i try to update the driver software it says the best driver software for your device is already installed. Please advise.
the ‘best’ driver is crashing Java
So, what next?
go get a newer driver, or open a support ticket on your side to have it investigated
Hello Jeff,
Great blog! I have a question on SQL Developer –> “Is there a way to add an option in the right-click menu while on SQL Worksheet?”
Regards,
Bibhuti
Not without coding a Java extension to do it.
Thanks for the suggestion !! Could you please suggest me some tutorial/ documentation that I can refer to create the extension using JAVA (considering that I have prior knowledge in JAVA programming).
I have read your articles on how to create extension using XML and I have tried searching the internet for creating extension in JAVA but have failed to get any head-start.
Thanks in advance 🙂
SQL*Developer’s ability to view a .png or .jpg saved as a BLOB is super-convenient.
Is there a way to add this same ability for .svg?
I would like to modify the {child}_{parent}_FK default naming convention as in my specific data model it exceeds the 30 character name limit (Oracle 11g XE).
I have found this 2009 white paper:
http://www.oracle.com/technetwork/developer-tools/datamodeler/datamodelernamingstandards-167685.pdf
It states that this template can be found in General Options, but I can’t find in my SQL Datamodeler (Version 4.1.3).
Could you please let me know where to modify that naming convention in recent versions?
Thanks
right click on the design in the tree, they’re in the design properties now, so you can set them at the design level vs entire applications
Thanks Jeff
Can we use sdcli to run just a simple query and spool the output to a file?
I was hoping to do this with sdcli so I can use the connections setup in SQL Developer(rather than using SQL Plus).
I’ve seen the blog entry about “sdcli64.exe reports generate -report”, but was hoping to append to text rather than html.
That is, append the results for one database, then another, then another.