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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ADF Library usage and their library dependencies

Stuart FlemingApr 24 2017 — edited Apr 26 2017

Jdeveloper 12.1.2

I have a question about how to properly manage all the libraries that both my consuming applications and my libraries depend on.  I am wondering if things are getting a bit too complicated.....

The goal is to have all the libraries reside in Weblogic.  They have manifest files etc, so they can be accessed.  They will not be deployed within the consuming application.

The consuming applications (even if they themselves are libraries) have weblogic.xml files that contain the references to find the library dependencies. For example, the consuming application, which uses the xxxRoleValidation ADF Library has this entry:

<library-ref>

    <library-name>xxxRoleValidation.shared.lib</library-name>

</library-ref>

However, the library xxxRoleValidation uses the following library: xxxUtilsVC.   xxxUtilsVC itself uses a library called xxxUtilsGeneral.  When I add the xxxUtilsVC to the xxxRoleValidation I see the ADF Library Dependencies Node created.

When I add the xxxRoleValidation to the main consuming application, I also see the ADF Library Dependencies File created.

How should I handle these dependencies? Should they all be added to the application Libraries? Or should they just be listed in the weblogic.xml? 

Or, since each library that has dependencies has a weblogic.xml file with the dependencies listed, do I need to do anything at all?

Thank you,

Stuart

Comments

AndrewSayer
Answer

Raj Aru wrote:

I am looking to bring the select statement sql which I am running in the database to AWR report Is there any way to pin a sql to awr report

Yes, it's called coloring for some reason. Use dbms_workload_repository.add_colored_sql https://docs.oracle.com/en/database/oracle/oracle-database/19/arpls/DBMS_WORKLOAD_REPOSITORY.html#GUID-243BBE24-DF37-45F…

Marked as Answer by Raj Aru · Sep 27 2020
Adityanath Dewoolkar
Raj Aru

Thanks AndrewSayer for the quick help

Jonathan Lewis

A little add-on to the note about coloring - the statement won't necessarily appear in the standard AWR report because it may not have done enough work in any of the ordinary categories; however it will have been captured in the repository and you can report it in the "AWR SQL report" - which I usually run from SQL*Plus: $ORACLE_HOME/rdbms/admin/awrsqrpt.sql

See:  https://jonathanlewis.wordpress.com/2018/10/19/add_colored_sql/

Regards

Jonathan Lewis

Raj Aru

Thanks Lewis

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

Post Details

Locked on May 24 2017
Added on Apr 24 2017
7 comments
1,784 views