Discussions
Categories
- 196.9K All Categories
- 2.2K Data
- 239 Big Data Appliance
- 1.9K Data Science
- 450.3K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 545 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.9K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.6K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 155 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 18 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 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
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 440 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 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,458 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,458 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,458 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