Skip to Main Content

SQL Developer Data Modeler

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

unable to import from data dictionary

I tried to import tables of a database (12.1.0.1.0) schema into datamodeler. After selecting the tables I got a lot of "java.sql.SQLRecoverableException: Closed Connection". The import shows only the tables but no columns.
am using SQL Developer Data Modeler 20.4.1.406.0906 (I tried a newer version with the same result) our infrastructure has changed and the networksettings might have changed. I looked up a lot of posts concerning the java error. But I have no clue how solve the problem. From the database point of view nothing has changed.
help is really appreciated
kind regards Raimund

Comments

Mike Kutz

Your procedure is in APP. Correct?

What is your Parsing Schema Name?  It sounds like XXAPEX.

What is your Workspace Schema name? I'm going to guess MILOWSKI

You need to grant permissions to the Parsing Schema in order for the APEX Application to work.

I've found that, under some circumstances, you have to grant permissions to the Workspace Schema too.

I forgot if I still needed the perms after I created the page.

MK

Tomek

Not sure What do you think I missed:

Workspace Name: AIS

Schema connected to the workspace: XXAPEX

Apex Login: MILOWSKI

There is only one schema XXAPEX.

MILOWSKI is my username in Apex with default schema set to XXAPEX.

Mike Kutz

Ok.  I think I understand what is happening.

Creating the synonym should have worked.

However, you need to Create Form on Procedure using the synonym XXAPEX.PAGE_MGR not the underlying package APP.PAGE_MGR.  (current guess)

I haven't had time to try to reproduce the problem.

MK

Tomek

Thanks Mike but this is not working either...

I made sure the synonym is in place. In APPS schema executed the following:

GRANT ALL ON page_mgr to xxapex WITH GRANT OPTION;

DROP SYNONYM xxapex.page_mgr;

CREATE SYNONYM xxapex.page_mgr FOR page_mgr;

When I login to Apex and use "Object Browser" I see the synonym is right in place.

However, when creating the "form on procedure" the package page_mgr is not there listed in the list nor I can just type it in. I specify the XXAPEX as procedure owner.

Tomek

Does anyone experienced this problem?

1 - 5

Post Details

Added on Jun 2 2021
1 comment
217 views