How To Convert Attached Libraries to Lowercase Names Using JDAPI (Doc ID 443853.1)

Last updated on AUGUST 07, 2023

Applies to:

Goal

As Unix is case-sensitive, when developing forms on Windows and deploying it on Unix, libraries are referenced inside the form with the exact letter case as it is attached in the development environment. For example if the attached library name is MyLib.pll, the reference to this library is recorded inside the form as MyLib.pll. So, on Unix this form tries to find the library called MyLib.pll (and not mylib.pll nor MYLIB.PLL).

The goal of the document is to convert the library name to lowercase name using JDAPI for multiple attached libraries.

In this code, a loop is constructed to fill an array of string with the list of attached pll names, then a loop in this generated array to detach and reattach again all the libraries in lowercase.

And as JDAPI is just a Java interface that sits on top of the C interface, this approach was done to follow the fact mentioned in  <NOTE:277293.1> - CAPI sample code to reattach PLLs in lowercase to an FMB

/*Note we cannot detach the alb while looping through - the loop will just terminate. */
/* So we follow a 3 step approach: get all, detach all, reattach all with lowercase */
/* In any case detaching and reattaching all (even if only some need it) will */
/* preserve the attachment order. */

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.