JDeveloper Connection closed.

Usman Kp

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 .

Timo Hahn

@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

dvohra21

It is no wonder. 19c is not supported, please refer https://www.oracle.com/application-development/technologies/jdeveloper/121300-cert.html

Usman Kp

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

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

dvohra21

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

dvohra21

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

dvohra21

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

Usman Kp

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

@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

Usman Kp

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

dvohra21

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