Discussions
Categories
- 197K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.8K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 556 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.4K SQL Developer
- 296.4K Development
- 17 Developer Projects
- 139 Programming Languages
- 293K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 159 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 468 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
JDeveloper Connection closed.

Hi, I am using Oracle JDeveloper 12.2.1.3.0 with database 19C . I am facing one big issue which is making our development of ADF forms very slow. When Ever we made connection with 19C db within ADF application , connection builds successfully . Issue happens when I try to create Entity Object ( via wizard or from Making Components from Tables ) , modify entity object definition like adding or removing one db column or updating View Object Mappings . JDeveloper stucks and I have to either stop wizards or restart Jdeveloper . Whenever I try to do above all operations with same application using 12C database ( on another server). JDeveloper runs smoothly. I tried connecting with APPS, and other schemas even with sysdba roles but issue is still persistent . Whenever JDeveloper is stuck it only gives messages in Logs like this .
Jun 20, 2022 2:06:23 PM oracle.javatools.db.execute.StatementWrapper cancel
WARNING: Error cancelling statement:IO Error
Jun 20, 2022 2:06:23 PM oracle.javatools.db.AbstractBuildableObject$BuildablePropertySupport logBuildCancelled
WARNING: Building of columns on TABLE PWC_MFG_PRECOSTING_L was cancelled.
Jun 20, 2022 2:06:23 PM oracle.javatools.db.execute.ConnectionWrapper call
INFO: ProgressBarThread: The connection to database Conn1 is closed.
Jun 20, 2022 2:06:23 PM oracle.javatools.db.AbstractDatabase getConnection
INFO: ProgressBarThreadConnection was closed, Conn1 has been reconnected.
Jun 20, 2022 2:06:37 PM oracle.javatools.db.execute.StatementWrapper cancel
Issue is that 19C DB is up and running all the time and TOAD is being connected while JDeveloper hangs out ( so it kills possibility that DB might be down) . Also there isn't much users so there isn't much load on DB also .
What is the cause of this issue and what can be its solution . I have around 20 applications of ADF and I face issue in all . I have to first make connection with 12C database , build my application and then migrate all DB objects in 19C database.
One more thing is that if I runs module tester and save some transactions , it not only runs smoothly but also stores data in database. JDeveloper only stucks when I am making new Entity Object or modifying existing EO or VO definitions .
Best Answer
-
Timo Hahn Senior Principal Technical Consultant - Oracle ACE Director Member, Moderator Posts: 38,590 Red Diamond
@Usman Kp I don't follow dvohra21 reasoning. The certification matrix for 12.2.1.3 (open the Database tab) tell me that DB 19c is supported.
Please note, that we are all normal users. If you want a definite answer, you have to ask Oracle (via support).
Another note: JDev 12.2.1.4 supports DB 19c in version 19.3.0.0, so make sure you do use this version.
Timo
Answers
-
It is no wonder. 19c is not supported, please refer https://www.oracle.com/application-development/technologies/jdeveloper/121300-cert.html
-
It is a big surprise to know this at such stage of project . One more thing that according to this document https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=173383387348232&parent=EXTERNAL_SEARCH&sourceId=HOWTO&id=2726122.1&_afrWindowMode=0&_adf.ctrl-state=16zz7av206_121
***Moderator action (Timo): image removed as it discloses MOS content. Disclosing MOS content in the public-facing community is not allowed .***
it is clearly mentioned that 19C is certified with 12.2.1.3.0 . If it is not compatible with 19C does oracle plans to change this in coming releases? As all our forms are in 12.2.1.3.0 so obviously we cant convert them and downgrade them but we can upgrade them to version which will be compatible with 19C.
Thanks
-
Timo Hahn Senior Principal Technical Consultant - Oracle ACE Director Member, Moderator Posts: 38,590 Red Diamond
Yes, you are right. The doc you mentioned is stating, that DB 19c is supported by JDev 12.2.1.3. You should open an SR with support.oracle.com and ask them about your problem.
All I can say is that I'm using 19c together with JDev 12.2.1.4 without such a problem.
Timo
-
Apologies, 12.2, not 12.1. But even 12.2.1.3 JDeveloper does not support 19c, while ADF does.
Database JDeveloper ADF
Oracle Database 10.x, 11.x, 12.1 11.x, 12.1, 19*
https://www.oracle.com/application-development/technologies/jdeveloper/122-cert.html#Databases
-
User Usman, please note that @Timo Hahn is not getting an issue with JDev 12.2.1.4 and 19c because 12.2.1.4 does support 19c, but not 12.2.1.3. Please refer
https://www.oracle.com/technologies/developer-tools/jdeveloper/12214certification.html
-
Usman: it is clearly mentioned that 19C is certified with 12.2.1.3.0 .
Timo: Yes, you are right. The doc you mentioned is stating, that DB 19c is supported by JDev 12.2.1.3. You should open an SR with support.oracle.com and ask them about your problem.
The support listed is accurate. Yes, 19c-ADF 12.2.1.3 is supported, not 19c-JDeveloper 12.2.1.3
-
Thanks for Replies guys, I am already downloading JDeveloper 12.2.1.4 . @dvohra21 regarding your statement about "The support listed is accurate. Yes, 19c-ADF 12.2.1.3 is supported, not 19c-JDeveloper 12.2.1.3".
I am confused what is difference between ADF 12.2.1.3 and JDeveloper 12.2.1.3 . We can only make ADF form 12.2.1.3 in JDeveloper 12.2.1.3 right? So one is being compatible with 19c( ADF 12.2.1.3 is supported) and other not JDeveloper ( not 19c-JDeveloper 12.2.1.3) is really confusing ? What is the difference between both ?
Hopefully 12.2.1.4 will resolve my Issue , though
Regards
-
Timo Hahn Senior Principal Technical Consultant - Oracle ACE Director Member, Moderator Posts: 38,590 Red Diamond
@Usman Kp I don't follow dvohra21 reasoning. The certification matrix for 12.2.1.3 (open the Database tab) tell me that DB 19c is supported.
Please note, that we are all normal users. If you want a definite answer, you have to ask Oracle (via support).
Another note: JDev 12.2.1.4 supports DB 19c in version 19.3.0.0, so make sure you do use this version.
Timo
-
@Timo Hahn I have installed 12.2.1.4 and its working much fine then 12.2.1.3 . Still not as fluent as JDeveloper is with 12c Database but for now I will take it.
Thanks for you guys.
-
I am confused what is difference between ADF 12.2.1.3 and JDeveloper 12.2.1.3 . We can only make ADF form 12.2.1.3 in JDeveloper 12.2.1.3 right? So one is being compatible with 19c( ADF 12.2.1.3 is supported) and other not JDeveloper ( not 19c-JDeveloper 12.2.1.3) is really confusing ? What is the difference between both ?
@Timo Hahn The reasoning is not complicated. How could ADF 12.2.1.3 be used without using JDev 12.2.1.3?
ADF runtime could be installed to WebLogic Server and used with 19c with another IDE such as OEPE. https://docs.oracle.com/middleware/12213/adf/
Oracle Enterprise Pack for Eclipse (OEPE) 12.2.1 is a feature release which provides new support for Oracle Fusion Middleware 12.2.1 technologies. This includes design time tools for Oracle WebLogic Server 12.2.1, Oracle Coherence 12.2.1, and Oracle ADF 12.2.1
https://www.oracle.com/application-development/technologies/eclipse/whatsnew-12c-relnotes.html