Forum Stats

  • 3,838,234 Users
  • 2,262,343 Discussions
  • 7,900,548 Comments

Discussions

JDeveloper Connection closed.

Usman Kp
Usman Kp Member Posts: 5 Green Ribbon

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
    Timo Hahn Senior Principal Technical Consultant - Oracle ACE Director Member, Moderator Posts: 38,579 Red Diamond
    Answer ✓

    @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
«1

Answers