Skip to Main Content

Java Development Tools

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!

How to deploy REST services in GF4.1 + ADFE 12.2.1.0

Jose ArósteguiSep 19 2017

Hi experts,

I have a running application in Production, deployed in Glassfish Server, using ADF Essentials 12.2.1.0.

I have the requirements of publish some Rest services, so I've followed Ashish Awasthi's Blog: Create REST Web Service with Application Module declaratively in ADF 12.2.1 – Ashish Awasthi's Blog (Jdev/ADF) 

...and it works fine.


I have my ADF application (ViewController + Model Projects) and now, I have an extra Web Project using a new AM that have a Rest service configured.


The sample works fine in Weblogic... I have my current URL working plus a new URL that serves the Json content.


My problem is that I cannot deploy to Glassfish, as I don't know what changes need to be done in the deployment descriptors.

Any guidance on it?

BR,
Jose.

Comments

fac586
Answer

van Baal HR wrote:

I want to query the APEX data dictionary for the pages I have created. The authorisation concept here dictates, that the pages created with APEX, must be granteable to roles and therefore I need to query the dictionary. Unfortunately I do not know what tables to access. Some stay empty, even when I connect to the database as DBA

Does anybody have a tip, what I can do here?

Many of the APEX views contain restrictions based on the database user being the parsing schema for the application, or a schema associated for the workspace. Some are dependent on being queried from an active APEX session.

The views can be interactively explored using the APEX Views utility in the Application Builder, and the dictionary is extensively documented in the APEX_DICTIONARY metadata view:

select * from apex_dictionary where apex_view_name = '<view name>'

Marked as Answer by van Baal HR · Sep 27 2020
van Baal HR

The query, that gave me the wanted information is:

SELECT *

  FROM apex_application_pages

WHERE application_id = 103

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 17 2017
Added on Sep 19 2017
0 comments
129 views