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,793 Comments
Is there any documentation on what privileges are required to use the “Monitor Sessions” feature of SQL Developer? Is there a standard role that includes these? Thanks.
Applying same schema filters across multiple database connections. How can I define a schema filter in other user and have that be applied to multiple database connections rather than just one. This would be akin to the “favourite schema” functionality in toad
is there a quick way of switching current schema other then running alter session set current schema. The drop down in toad to do this is very useful
Short answer: no.
Hi Jeff,
getting some very slow response times in Sql Developer 18.3 using the SQL tab for a table.
Looks like we have up to date dictionary stats in place. Some SQL I can see running below. Any suggestions for speeding it up?
Thanks,
Peter.
SELECT /*+all_rows*/ VALUE(KU$), 0
FROM SYS.KU$_OBJGRANT_VIEW KU$
WHERE NOT BITAND(KU$.BASE_OBJ.FLAGS,128)!=0
AND KU$.BASE_OBJ.NAME=”
AND KU$.BASE_OBJ.OWNER_NAME=”;
SELECT /*+all_rows*/ SYS_XMLGEN(VALUE(KU$),
XMLFORMAT.createFormat2(‘TABLE_T’, ‘7’)),
KU$.OBJ_NUM
FROM SYS.KU$_HTABLE_VIEW KU$
WHERE NOT (BITAND (KU$.PROPERTY,8192)=8192)
AND NOT BITAND(KU$.SCHEMA_OBJ.FLAGS,128)!=0
AND KU$.SCHEMA_OBJ.NAME=:NAME1
AND KU$.SCHEMA_OBJ.OWNER_NAME=:SCHEMA2
That doesn’t look like our code…I’m out of the office today, but our code makes calls to dbms metadata to generate the SQL behind a table.
Thanks for getting back Jeff.
The SQL above is probably originating from within dbms_metadata so.
90sec+ response time on the SQL tab.
Ok, so you’re looking at recursive SQL on a session trace.
DBMS_METADATA is usually ‘slow’ on the first call or 3, and then should have about a 1-2 sec response time on subsequent calls. If you are seeing things differently, I’d open a SR with MOS – but don’t file it on SQL Developer, file it with the general DB, and share the underlying DBMS_ calls that SQL Developer is just happening to be making.
This is after you’re confirmed your data dictionary stats are indeed up to date.
Hi Jeff,
There’s an annoying behavior of SQL Developer’s with LDAP connections. It seems to caches the TNS settings after you’ve loaded them from the LDAP (OID) server. Then, if the database (a PDB) gets moved to another container CDB located on a physically different server, SQL Developer won’t connect without me first going into the connection dialog, and clicking on the “Load” button next to the “DB Service” field. I guess that refreshes the local cache.
Is there a way to prevent this value from being cached? I’d like the connection, when defined with LDAP methog, to query the TNS setting *every* time I connect.
Thanks!
Jack
I doubt we’d ever imagine thise entries would be so volatile.
How often it’s this happening?
It happens fairly frequently… we move PDBs around a lot. In any case, all of our other clients (sqlplus, jdbc, Toad, etc) don’t exhibit this behavior. If the OID setting for a database changes, the client should always know about it. Think of the OID setting as a IP address in a DNS server… it should be “permanently cached” in the client as that defeats the whole purpose of having a centralized location for these settings. Do you agree?
Thanks,
Jack
How do I configure ORDS to not include the items{} wrapper around the return data?
Answer #1 – you don’t. We have a standard here at Oracle for how {JSON} docs are constructed, and this is part of our spec.
Answer #2 – you generate your own {JSON} and make your handler of type MEDIA RESOURCE, and we won’t touch it…in other words we’ll return the raw output you provide.
Wow! You are fast! Much appreciated Sir.
Does this only work if you are on 12c or higher? I’m on 11g.
Generating JSON on your own? True, 11g doesn’t have much. Most people will use the JSON packages that APEX gives you – even if they never use APEX itself (But you should!)
So…. We do not use Apex and I agree with you that we should. The company I work for is moving to 12c over the next few weeks. We you suggest that we would be better served by waiting until after the upgrade in order to utilize the native JSON features included?
A couple of weeks will be here before you know it…once it’s here, you’ll have about a half dozen ways to generate JSON.
What’s wrong with the item wrapper? Any decent JSON parser should be able to work around that.
I mention this because if you go the ‘raw’ route – you lose the automatic paging and url filtering features built into ORDS for query results, etc.
Hi Jeff,
I am a teacher in high school. My students are struggling with data modeler .Is there any video tutorial for them to view and understand
Quite a few – from various different sources.
I haven’t done much in terms of video for the modeler, but I have a ton of blog posts here
Is there a specific area they are having problems?
How many students? I’d be happy to do a webinar for your class! Just email me at [email protected]
We’ve run into a problem that simple queries against rather large tables (100’s of GB) in oracle sql developer can runaway and cause database issues. E.g. we had one today, e.g. select * from warehouse.xyz, which has DOP=16, that someone ran just to look at a few rows from the table, then forgot about it. But later we had numerous production jobs fail due to lack of temp ts, and checking in session monitoring we could see it still out there using 1.4TB of temp and 76 threads, for just that one simple query. I’m not sure if it’s a bug or if there is some setting we need to tweak to avoid this. Other SQL query tools used across the team do not experience this same behavior. We would appreciate any tips or advice you could offer on this. Thanks!
your users need to know if they leave a query ‘open’ – that is, not having fetched all the records – they are leaving those processes out there
the best way to avoid this is with resource consumer groups and a plan that will prevent them from taking more resources than you want them to have
of course, if they would grab all the data they want or close those grids when they’re done looking at them, it would avoid the pain you are seeing
Hey there Jeff and other members here,
I’m trying out ORDS for a new RESTful API setup for work.
We have a remote Oracle Database that has ORDS enabled on it but no application server to handle the requests so we can’t use it yet, but I wanted to try it out locally on my computer using SQL Developer and went to “Tools” => “REST Data Services” => “Run”
And start the standalone that is included with SQL Developer.
I create a Demo module and Template and added a GET Handler to it and select from dual just to test.
But when I load the page in my browser I get: “404 – The request could not be mapped to any database. Check the request URL is correct, and that URL to database mappings have been correctly configured”
The database connection it self in SQL Developer works fine I can do everything from there.
The Scheme I am trying to use has Rest Services enabled
I go to localhost/ords/:scheme/:model/:template
Does the remote database I am connecting to have to have a application server running in order to use it locally from SQL Developer or am I missing something?
Hope I’m making some sense here and you understand me 😀
ORDS has it’s own webserver, it’s called Jetty – and that’s what you’re seeing when you get the 404
so a GET on localhost:port/ords/:schema/demo/:template should work, unless your pattern was actually /demo/:template/
You rest enabled the schema, yes? What did you set for the alias? It defaults to the schema name, but that’s what you have to use for :schema in your URI
Also, as a test, you can just hit
localhost:port/ords/schema/metadata-catalog/
that will bring back a list of modules for your rest enabled schema
Thank you for the response,
Yeah its REST enabled, its alias is “test”
So to see all modules it should be
localhost:8080/ords/test/metadata-catalog/
right?
If I do that I still get “The request could not be mapped to any database. Check the request URL is correct, and that URL to database mappings have been correctly configured”
So I feel like I am missing something, like my Jetty is not getting a connection to my DB but I can’t seem to find anything that tells ORDS to use my current connection to the remote database I am using.
stop ORDS in your copy of SQLDev
download ords from oracle.com/rest
extract the zip on your desktop
go to a cmd prompt,
java -jar ords.war
point it to a config directory
walk the wizard, it’ll start ords up and run it on your db
then try to hit the GET
Hey Jeff,
I tried that but I still get the same erorr, “404 The request could not be mapped to any database. Check the request URL is correct, and that URL to database mappings have been correctly configured”
The database does not have to be on the same machine as the Jetty Server is?
I mean my database is on a remote machine and I am trying to run this on my local machine,
I have the Ords_public_user passwords but always when I give it up it also ask for sys as sysBA to verify REST Data Services schema but I don’t have that, is that needed to set this up localy?
Ords is active on database
You can’t successfully install ORDS w/o the SYS password.
But as I understand from my Oracle System administrator ORDS is installed on the Database Server and the ORDS_PUBLIC_USER does exist, why do I need the SYS password to connect the local Server to the ORDS on the Database server?
Am I misunderstanding how this works, I was under the impression that the Jetty server I was setting up on my local machine was just a version of a HTTP server that answers my uri’s on my local network and routes them to the ORDS on my remote database server.
your oracle system admin will need to do the install
once that happens, the ORACLE_PUBLIC_USER will be able to PROXY CONNECT to ANY rest enabled schema in the database – that’s no small thing, and that’s why we require SYS AS SYSDBA level access to set it up
My Oracle Admin has already installed ORDS on the Database,
So the question is how can I run my Jetty Server locally by just connecting to the database which is on another machione, and not install anything?
“java -jar ords.war standalone” been running this.
Do I need to add some parameters to this or add something to the ords_params.properties file?
and please let me know if I’m misunderstanding this drastically :S
When I run the above command this is t he output
2018-11-27 16:01:28.900:INFO::main: Logging initialized @1103ms to org.eclipse.jetty.util.log.StdErrLog
Nov 27, 2018 4:01:28 PM
INFO: HTTP and HTTP/2 cleartext listening on port: 8888
Nov 27, 2018 4:01:29 PM
INFO: Disabling document root because the specified folder does not exist: /home/{user}/ORDS/ords/standalone/doc_root
2018-11-27 16:01:29.206:INFO:oejs.Server:main: jetty-9.4.z-SNAPSHOT; built: 2018-05-03T15:56:21.710Z; git: daa59876e6f384329b122929e70a80934569428c; jvm 1.8.0_181-8u181-b13-0ubuntu0.16.04.1-b13
2018-11-27 16:01:29.245:INFO:oejs.session:main: DefaultSessionIdManager workerName=node0
2018-11-27 16:01:29.245:INFO:oejs.session:main: No SessionScavenger set, using defaults
2018-11-27 16:01:29.246:INFO:oejs.session:main: node0 Scavenging every 600000ms
Nov 27, 2018 4:01:29 PM
INFO: No pools configured yet
Nov 27, 2018 4:01:29 PM
INFO: Oracle REST Data Services initialized
Oracle REST Data Services version : 18.3.0.r2701456
Oracle REST Data Services server info: jetty/9.4.z-SNAPSHOT
2018-11-27 16:01:29.436:INFO:oejsh.ContextHandler:main: Started o.e.j.s.ServletContextHandler@5ae9a829{/ords,null,AVAILABLE}
2018-11-27 16:01:29.446:INFO:oejs.AbstractConnector:main: Started ServerConnector@74650e52{HTTP/1.1,[http/1.1, h2c]}{0.0.0.0:8888}
2018-11-27 16:01:29.446:INFO:oejs.Server:main: Started @1650ms
run the installer, point it to that db, give it the right password for the ords public user account, and you’re good to go
if we can’t validate the setup, it’ll want to do the install over again and then you’ll need the SYS account
Jeffreys-Mini:ords thatjeffsmith$ java -jar ords.war This Oracle REST Data Services instance has not yet been configured. Please complete the following prompts Enter the location to store configuration data:/ords/config Enter the name of the database server [localhost]: Enter the database listen port [1521]: Enter 1 to specify the database service name, or 2 to specify the database SID [1]:1 Enter the database service name:orcl Enter the database password for ORDS_PUBLIC_USER: Confirm password: Retrieving information. Enter 1 if you want to use PL/SQL Gateway or 2 to skip this step. If using Oracle Application Express or migrating from mod_plsql then you must enter 1 [1]:2 Nov 27, 2018 11:20:45 AM INFO: reloaded pools: [] Nov 27, 2018 11:20:45 AM oracle.dbtools.rt.config.setup.SchemaSetup install INFO: Oracle REST Data Services schema version 18.3.0.r2701456 is installed. Enter 1 if you wish to start in standalone mode or 2 to exit [1]:1 Enter 1 if using HTTP or 2 if using HTTPS [1]:1 2018-11-27 11:20:57.839:INFO::main: Logging initialized @71640ms to org.eclipse.jetty.util.log.StdErrLog Nov 27, 2018 11:20:57 AM INFO: HTTP and HTTP/2 cleartext listening on port: 8080 Nov 27, 2018 11:20:57 AM INFO: Disabling document root because the specified folder does not exist: /ords/config/ords/standalone/doc_root 2018-11-27 11:20:58.227:INFO:oejs.Server:main: jetty-9.4.z-SNAPSHOT; built: 2018-05-03T15:56:21.710Z; git: daa59876e6f384329b122929e70a80934569428c; jvm 1.8.0_191-b12 2018-11-27 11:20:58.266:INFO:oejs.session:main: DefaultSessionIdManager workerName=node0 2018-11-27 11:20:58.266:INFO:oejs.session:main: No SessionScavenger set, using defaults 2018-11-27 11:20:58.267:INFO:oejs.session:main: node0 Scavenging every 600000ms Nov 27, 2018 11:20:58 AM INFO: Creating Pool:|apex|pu| Nov 27, 2018 11:20:58 AM INFO: Configuration properties for: |apex|pu| db.hostname=localhost db.password=****** db.port=1521 db.servicename=orcl db.username=ORDS_PUBLIC_USER resource.templates.enabled=true Nov 27, 2018 11:20:58 AM WARNING: *** jdbc.MaxLimit in configuration |apex|pu| is using a value of 10, this setting may not be sized adequately for a production environment *** Nov 27, 2018 11:20:58 AM WARNING: *** jdbc.InitialLimit in configuration |apex|pu| is using a value of 3, this setting may not be sized adequately for a production environment *** Nov 27, 2018 11:20:58 AM INFO: Oracle REST Data Services initialized Oracle REST Data Services version : 18.3.0.r2701456 Oracle REST Data Services server info: jetty/9.4.z-SNAPSHOT 2018-11-27 11:20:58.534:INFO:oejsh.ContextHandler:main: Started o.e.j.s.ServletContextHandler@8b96fde{/ords,null,AVAILABLE} 2018-11-27 11:20:58.547:INFO:oejs.AbstractConnector:main: Started ServerConnector@1f0f1111{HTTP/1.1,[http/1.1, h2c]}{0.0.0.0:8080} 2018-11-27 11:20:58.547:INFO:oejs.Server:main: Started @72348msThanks, I have been running this and I get this error in the console:
“Retrieving information.
Requires SYS AS SYSDBA to verify Oracle REST Data Services schema.”
So I guess I just have to have the SYS user information to be able to verify the setup or is there something I can get the Oracle admin to change to I don’t need the SYS privileges to validate just to install?
On an export of a query to Excel… The filename should be a drop-down… Same for doing an import from Excel
Hi Jeff
Thanks for maintaining a fabulous site.
Is it possible to get SQL*Developer to remember last used settings in “working session”?
* Last used export settings?
* Last used open folder?
* Last used save folder?
* etc.?
Instead of doing a MRU on an export, you can set the defaults in the preferences.
Most of the file and directory dialogs should have a drop-down control that show the MRU items.
Hi Jeff
I know we can set the defaults for export options, however some users would like MRU.
I fail in finding your MRU drop-downs in file/directory dialogs in windows8. Could you be a bit more specific?
Jeff, is it correct that:
1) all ORDS *_DEFINE APIs could be executed *only* under user whos schema was enabled by “enable_schema call?”
2) user who executes ORDS *_DEFINE APIs will own objects created by that calls (modules, templates etc)?
If yes, what is recommended approach for DevOps users – how to create all ORDS objects in right place (for example in HR schema) if we have to use special DevOps database user for deploying all our database objects to production?
One option could be to create stored procedure under target HR schema containing all ORDS *_Define calls:
Create procedure HR.ORDS_DEFINES as …
BEGIN
ORDS.define_module(
p_module_name => ‘testmodule2’,
p_base_path => ‘testmodule2/’,
p_items_per_page => 0);
ORDS.define_template(
p_module_name => ‘testmodule2′,
p_pattern => ’emp/’);
ORDS.define_handler(
p_module_name => ‘testmodule2′,
p_pattern => ’emp/’,
p_method => ‘GET’,
p_source_type => ORDS.source_type_collection_feed,
p_source => ‘SELECT * FROM emp’,
p_items_per_page => 0);
COMMIT;
END;
/
– then:
1) create that procedure under DevOps user – it will be created in target schema HR
2) run that procedure under DevOps user – it will be run with owner righs as if HR runned it, so we will have ORDS objects created on behalf of HR
Or is there a better way?
Thanks!
your special devOps user will need to alter session set current schema before making the ORDS package calls to deploy the services
I mean, run ORDS.Create_module and enable_schema(‘not_current_schema_name’) for example. Also in create_handler we use objects from different schema.
When we try to run it, it says “insufficient priv-s”.
If i can’t make it clear tomorrow will type an example
Has to be done for the local schema.
Hi Jeff, please answer: what privilegies are required for user so he is able to create ORDS objects in different schema (in all schemas?)
are there some special grants or smth? from what user should this grants be run?
How do you mean, create ords objects?
Do you mean, how to install/configure ords?
Hi Jeff,
With respect to the twit I sent you on Nov 19th 8:25PM , you replied to send you an example to look.
Instead of using twitter I thought this would be a better way to show the weird behaviour with 18.3 (I updated to latest version).
I am just reporting to you. I did not mean to call you on twitter for Tech Support. I apologize if that came across like that. I sincerely just wanted to share with you. I do read your posts and follow you. Thank you for the great work you’re doing. We all benefit from it!
Anyway, here’s the script I ran and the output:
create table names(fname varchar2(20),Notes varchar2(255));
insert into names (fname,Notes) values (‘Fabián’,’Esta es una teoría’);
insert into names (fname,Notes) values (‘Ramón’,’Es una buena canción’);
insert into names (fname,Notes) values (‘Charles’,’great show’);
insert into names (fname,Notes) values (‘Ulíses’,’es un espectáculo’);
commit;
select * from names;
select /*insert*/ * from names;
Output:
Table NAMES created.
1 row inserted.
1 row inserted.
1 row inserted.
1 row inserted.
Commit complete.
FNAME NOTES
——————– —————————————————————————————————————————————————————————————————————————————————————
Fabián Esta es una teoría
Ramón Es una buena canción
Charles great show
Ulíses es un espectáculo
REM INSERTING into NAMES
SET DEFINE OFF;
Insert into NAMES (FNAME,NOTES) values (‘Fabián’,’Esta es una teorÃa’);
Insert into NAMES (FNAME,NOTES) values (‘Ramón’,’Es una buena canción’);
Insert into NAMES (FNAME,NOTES) values (‘Charles’,’great show’);
Insert into NAMES (FNAME,NOTES) values (‘UlÃses’,’es un espectáculo’);
My output in 18.3 with application encoding (set in first page of Preferences) to UTF-8
Is it possible in SQL dev 18.3 or 18.4 to search for a particular database from a list of databases (shown at top right corner in sql worksheet) on which I want to run my custom report? The list is not ordered in any form so it is difficult to scroll list of hundreds of databases to pick one. Some time this list is sorted alphabetically (of connected databases) but this is not always the case. Is there a workaround for this please or can it be added into future releases?
There is an order…it lists CONNECTED connections first, and then the rest are in alphabetical.
They are searchable via the keyboard, you can type in the name of your connection.
You can also open a worksheet from the connection tree.
No they are not keyboard searchable, there is only a drop down list and I have to scroll to find out my required database. Also these are not ordered by alphabetically (of connected databases). I don’t want to open a worksheet but I want to run the report.
I am in the report window, and when I click on a report, by default the report is displayed for the chosen database but I want to run the same report on another database and to do that I have to scroll the whole list of connected and non-connected databases to find my desired one.
I just tried it…i have a connection named ‘HR’ and it took me right to it when I started typing.
Ok, you said you were in a worksheet, but you’re in the reports window. I’ll look again this morning.
Hi, Jeff. Thanks a lot for all these posts.
But I have a trouble, which solution I couldn’t find.
We have a working ORDS service. we did ENABLE_SCEMA(p_schema=>’DEMO’, p_url_mapping_type=>’BASE_PATH’, …);
after we defined all the modules and templates all worked, and the URL was like dev.our.dev-site:8080/ords/DEMO/our_module/our_template/ for GET.
Now we need to have all these things in another schema, ESK. we tried do define it like DEMO: ENABLE_SCEMA(p_schema=>’ESK’, p_url_mapping_type=>’BASE_PATH’, …); and create modules and templates all the same as in DEMO schema but with names esk_module, esk_template.
but URL dev.our.dev-site:8080/ords/ESK/esk_module/esk_template/ returns error 500. Maybe we do smth wrong? how make ORDS look into schema ESK? should we disable DEMO first?
500 means probably something in SQL is bad
Check the ords standard out for the ORA’s, which should point you in the right direction. I talk about this here.
You can also turn on in ords print errors to screen and debug .. but don’t ever do this for prod.
is it better than 404? that means, it found my pool with all these things, but can’t run it properly?
(Excuse my poor English)
Are you getting a 404 or a 500 – those are VERY different problems.
Hi Jeff!
Thank you for your videos on using Reports in SQL Developer, watched them just two months ago and I can not create reports fast enough. This is a feature I have been in search of for a long time. I had adopted SQL Developer years ago and it had glitches which frustrated me and resulted in it being ignored for many years.
I have created a lot of “User Defined Reports” and have found a couple of issues, which I am hoping you can tell me you are aware of these issues and/or Oracle Support is working on them. If you are not aware of these issues, I can write up an SR with Oracle Support to have the issues addressed.
1. When a new report or folder is added, the tree of folders will expand all of its reports; That is, other folders and sub-trees expand out, so I have to find where I was working again and fold in any expanded folders;
2. When the number of folders and reports extend beyond the bottom of the screen, the “Reports” window forces scrolling of the reports up, therefore, not able to select a report until it is done scrolling. Many times, the folders above must be collapsed to be able to work on reports located lower in the window.
Hi Jeff, I’m using SQL Developer Data Modeler (Version 18.3.0.277 build 277.2354) to create a logical data model. How does one visually indicate which entity attributes form an entity to entity relationship? For example, consider entity ‘parent’ that has a single attribute ‘id’ that is also the primary key for that entity. In addition consider another entity ‘child’ that has two attributes, ‘id’ and ‘parent_id’ the former being the primary key and the latter being a foreign key to ‘parent.id’. How do I indicate to the reader that ‘parent.id’ relates to ‘child.parent_id’. Primary keys are denoted by an ‘*’, optional attributes denoted by an ‘o’ but I can’t find anyway to denote an attribute being part of a relationship.
After starting SQL Developer, I get the message SQL Developer has stopped working and shuts down.
I have found the following Null Pointer:
Windows 10 sql dev version 4.15 and 18.x fresh download from today.
java.lang.NullPointerException
at org.netbeans.core.netigso.Netigso.findResources(Netigso.java:380)
at org.netbeans.NetigsoModule.findResources(NetigsoModule.java:177)
at org.netbeans.core.startup.NbInstaller.loadLayers(NbInstaller.java:630)
at org.netbeans.core.startup.NbInstaller.loadImpl(NbInstaller.java:356)
at org.netbeans.core.startup.NbInstaller.access$000(NbInstaller.java:105)
at org.netbeans.core.startup.NbInstaller$1.run(NbInstaller.java:346)
at org.openide.filesystems.FileUtil$2.run(FileUtil.java:444)
at org.openide.filesystems.EventControl.runAtomicAction(EventControl.java:127)
at org.openide.filesystems.FileSystem.runAtomicAction(FileSystem.java:499)
at org.openide.filesystems.FileUtil.runAtomicAction(FileUtil.java:428)
at org.openide.filesystems.FileUtil.runAtomicAction(FileUtil.java:448)
at org.netbeans.core.startup.NbInstaller.load(NbInstaller.java:343)
at org.netbeans.ModuleManager.enable(ModuleManager.java:1351)
at org.netbeans.ModuleManager.enable(ModuleManager.java:1156)
at org.netbeans.core.startup.ModuleList.installNew(ModuleList.java:340)
at org.netbeans.core.startup.ModuleList.trigger(ModuleList.java:276)
at org.netbeans.core.startup.ModuleSystem.restore(ModuleSystem.java:301)
at org.netbeans.core.startup.Main.getModuleSystem(Main.java:181)
at org.netbeans.core.startup.Main.getModuleSystem(Main.java:150)
at org.netbeans.core.startup.Main.start(Main.java:307)
at org.netbeans.core.startup.TopThreadGroup.run(TopThreadGroup.java:123)
at java.lang.Thread.run(Thread.java:745)
During debug command window, also capture the following warning:
Warning – could not install some modules:
oracle.javatools_nodeps – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\external\oracle.javatools-nodeps.jar: Not found bundle:oracle.javatools_nodeps
oracle.javatools_jndi_local – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\external\oracle.javatools-jndi-local.jar: Not found bundle:oracle.javatools_jndi_local
oracle.jewt_olaf2 – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\external\oracle.jewt-olaf2.jar: Not found bundle:oracle.jewt_olaf2
oracle.javaxide – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\ide\lib\javax-ide.jar: Not found bundle:oracle.javaxide
oracle.external.oracle_jrf_adminserver – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\external\oracle.external.oracle-jrf-adminserver.jar: Not found bundle:oracle.external.oracle_jrf_adminserver
oracle.external.jxlayer – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\external\oracle.external.jxlayer.jar: Not found bundle:oracle.external.jxlayer
org.eclipse.equinox.common – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\equinox\org.eclipse.equinox.common_3.6.0.v20100503.jar: Not found bundle:org.eclipse.equinox.common
oracle.external.timing – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\external\oracle.external.timing.jar: Not found bundle:oracle.external.timing
oracle.ide_print_api – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\ide\lib\ide-print-api.jar: Not found bundle:oracle.ide_print_api
oracle.ide.library – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\jdev\extensions\oracle.ide.library.jar: Not found bundle:oracle.ide.library
oracle.ide_osgi – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\ide\lib\oracle.ide.osgi.jar: Not found bundle:oracle.ide_osgi
oracle.external.jdbc – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\external\oracle.external.jdbc.jar: Not found bundle:oracle.external.jdbc
oracle.jewt_core – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\external\oracle.jewt-core.jar: Not found bundle:oracle.jewt_core
oracle.ide.webbrowser – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\ide\extensions\oracle.ide.webbrowser.jar: Not found bundle:oracle.ide.webbrowser
oracle.external.ldap – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\external\oracle.external.ldap.jar: Not found bundle:oracle.external.ldap
oracle.external.balishare – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\external\oracle.external.balishare.jar: Not found bundle:oracle.external.balishare
oracle.ide.persistence – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\ide\extensions\oracle.ide.persistence.jar: Not found bundle:oracle.ide.persistence
oracle.external.xmlparser – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\external\oracle.external.xmlparser.jar: Not found bundle:oracle.external.xmlparser
oracle.external.objectweb_asm – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\external\oracle.external.objectweb-asm.jar: Not found bundle:oracle.external.objectweb_asm
oracle.javatools_jdk – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\jdev\lib\jdkver.jar: Not found bundle:oracle.javatools_jdk
oracle.icons – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\external\oracle.icons.jar: Not found bundle:oracle.icons
oracle.external.odl – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\external\oracle.external.odl.jar: Not found bundle:oracle.external.odl
oracle.external.miglayout – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\external\oracle.external.miglayout.jar: Not found bundle:oracle.external.miglayout
oracle.javamodel_rt – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\external\oracle.javamodel-rt.jar: Not found bundle:oracle.javamodel_rt
oracle.external.berkeleydb – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\external\oracle.external.berkeleydb.jar: Not found bundle:oracle.external.berkeleydb
oracle.idert – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\ide\lib\idert.jar: Not found bundle:oracle.idert
oracle.javatools – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\ide\lib\javatools.jar: Not found bundle:oracle.javatools
oracle.ideimpl.peek – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\ide\extensions\oracle.ideimpl.peek.jar: Not found bundle:oracle.ideimpl.peek
oracle.ide.macros – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\jdev\extensions\oracle.ide.macros.jar: Not found bundle:oracle.ide.macros
oracle.java_annotations – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\ide\lib\annotations.jar: Not found bundle:oracle.java_annotations
oracle.ide.vfs – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\ide\extensions\oracle.ide.vfs.jar: Not found bundle:oracle.ide.vfs
oracle.uic – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\ide\lib\uic.jar: Not found bundle:oracle.uic
oracle.ide_boot – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\ide\lib\ide-boot.jar: Not found bundle:oracle.ide_boot
oracle.ide.navigator – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\ide\extensions\oracle.ide.navigator.jar: Not found bundle:oracle.ide.navigator
oracle.ide – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\ide\extensions\oracle.ide.jar: Not found bundle:oracle.ide
oracle.external.oracle_jrf_dms – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\external\oracle.external.oracle-jrf-dms.jar: Not found bundle:oracle.external.oracle_jrf_dms
oracle.ide.indexing – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\ide\extensions\oracle.ide.indexing.jar: Not found bundle:oracle.ide.indexing
oracle.external.xdb – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\external\oracle.external.xdb.jar: Not found bundle:oracle.external.xdb
oracle.external.nlsrtl – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\external\oracle.external.nlsrtl.jar: Not found bundle:oracle.external.nlsrtl
oracle.ide.searchbar – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\ide\extensions\oracle.ide.searchbar.jar: Not found bundle:oracle.ide.searchbar
oracle.external.xdk – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\external\oracle.external.xdk.jar: Not found bundle:oracle.external.xdk
oracle.ide.ceditor – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\ide\extensions\oracle.ide.ceditor.jar: Not found bundle:oracle.ide.ceditor
oracle.peek – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\ide\lib\peek.jar: Not found bundle:oracle.peek
oracle.ide.file – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\ide\extensions\oracle.ide.file.jar: Not found bundle:oracle.ide.file
Hi Jeff, please answer what should be a timestamp format used by ORDS POST? as I get it, date field should be like ‘2019-09-11T00:00:00Z’, and what about timestamp? And how to define the mask for to_date and to_timestamp? Is there some tricks?
if you query a TIMESTAMP out, you’ll see how we format it – that’s the same way it needs to go back in
Let me explain. I got a procedure, which take valid_from varchar2 as input parameter. in the body of my procedure I convert it into timestamp using mask ‘YYYY-MM-DD HH24:MI:SSXFF’, so when I give a string like ‘2014-12-23 00:00:00,098081333’ and run procedure from Oracle it works pretty well.
The trouble appears when I try to run my procedure through POST method. There are no binds with type, all the conversion are inside the procedure. But wtf?! When I try to call it using CURL, I get ORA-01830! pls, help me understand why does it happen? If I use mask without XFF and valid_from without ‘,nine-digits’ it all works.
Once more: I send into the procedure only varchar2, all the conversion inside. But from Oracle it works, and from curl – No…
You’re asking me to guess – because I can’t see your POST handler code or your cURL command, or the stack trace from ORDS showing the ORA-01830.
Hi Jeff,
I have a customer facing portal developed with Oracle APEX using custom authentication. I want to create ORDS users for every portal customer I create using PL/SQL. Is this possible? REASON: I have a mobile app recently developed and would like for the app to use the same authentication used by the portal. I can achieve this using OAuth2 by ORDS but I need to create the ORDS user via PL/SQL
An ‘ords’ user would be a standalone Jetty user. You can’t create these with PL/SQL.
Oauth2 says let this other party determine if the user is who they say they are.
If you go with oauth2, who will you be handing off to?
Can I replace the authentication URL for “authorization_code” implementation of OAuth 2 to say an Oracle APEX login page. What I hope to achieve is to very similar to what google provides for OAuth2 authentication in Oracle APEX. Just that in this case I would like the mobile app to use “my Oracle APEX” login page then proceed to access APIs hanldles
We support Apex auth, where you have the table os users…
I do have a table of users and their hashed passwords. How do I use this instead of the ords (Jetty) users
Extеnso will completely ѕtгaighten thе hаir, it relaxes the curl and makes it easier to flat iron or blow out.
Detoxifying yoᥙr body is the solіtаry way of cleansing your body of these toxins.
You can do caｒdio, dancе, step and қіckboxing in this game.
Hi Jeff,
In the Connections Pane I want to be able to connect as one user but display the object tree for another user that I have access to. Currently I have to navigate to the “Other Users” node and then apply a filter to isolate the user I want to traverse. This leaves the tree of the connected user visible above the “Other” User. Can I hide the entire “Connected” user tree and just display the “Other” User tree?
No, but you could use the schema browser instead.
I’ve imported a SQL Server database, and I’ve discovered that there are a fair number of inactive foreign keys. Is there a way to tell Data Modeler to delete those from the model?
Hmmm…I like a challenge, let me play with this tomorrow
But
FKs are important – if only to tell a story in your model. Are you sure you don’t need them?
This is an old, not-well-designed application developed by an ever-changing project team. It’s still sitting on SQL 2000. An example – for some reason, on one table, there is one active foreign key – and four that have the exact same constraint, but they’re inactive. There are about 34 FKs inactive out of about 200, and most are like this.
I think you’d have to write a transformation script to find those and auto-delete them.
I can show you how to find them with the search pretty quickly, or I can try to write the script for you.
I’d prefer to know how to do it – I think this redesign may be an iterative process.
Thanks!
Hary