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 .