Skip to Main Content

APEX

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.

different behaviors same application.

Hello everyone!
To be honest, I don't even know how to phrase this question properly. I am new to Oracle Apex and I love it so far. I am replacing an old Oracle Form legacy system with an app developed in Oracle Application Express 21.1.
For the running environment, I have two different scenarios. The first one is when my users are in the office. They access the app through running the latest Firefox version (currently 91.0.2) on their Windows 10 machine. The second scenario is when they are working remotely. Please don't ask me why but my IT Security Team provides a portal with a very restrict Citrix Enviroment for them to access. On this portal, they can run Firefox ESR 52.9.0, allegedly due to compatibility with other web based systems they keep this version up. The app that I am developing runs fine on the in office setup. Modal pages always popups, insert data form instances shows all the page items and etc. On the Citrix/older firefox version, it doesn't run properly at all. Modal dialog pages are not able to redirect to the pages they were called from, and some forms, when empty or to insert data form just shows up a blank page with no page item fields.
So I assumed it was due to the older version of Firefox and the citrix enviroment. It turns it isn't. I downloaded and installed the Summit Application ( https://apex.oracle.com/pls/apex/f?p=39731:1:4016291120747::::: ) and it runs fine on both scenarios. All the modal dialog pages pop up, blank insert forms have all the page items fields to input data and etc.
So I am assuming it is some configuration on my developed app.
I compared the properties of both apps, mine and the Summit Application app, to see if it was some configuration issue, theme settings or anything but I can not find any different settings. Even buttons look a little different between the two apps.
Here are some screen shots:
My app's home page running in scenario one:

inoffice-homepage.pngMy app's home page running in scenario two:
citrix-homepage.pngNote that frame (for lack of better term) with release version shows up halfway through the browser's page. Also, on the top right hand side corner the icons for login/logout and feedback are over each other.

Blank entry form on scenario one
inoffice-insertdataform.png
Blank entry form on scenario two
citrix-blankentryformpage.pngNote how the buttons look and feel different between the same page on the different scenarios.

Lastly, the modal dialog page on scenario one:
inoffice-modalpagewithpageitems.png
the modal dialog page on scenario two:
citrix-modalpageblank_LI.jpg
Notice the entry form page comes up blank when it is a modal dialog page on scenario two.

I don't know what it could be. I tried checking the html and inspect the pages elements but it is a really time consuming task. And to be honest, for lack of experience, I am not sure if I know what I am looking for because the inspector shows no errors.

Any help is greatly appreciated!

This post has been answered by fac586 on Aug 30 2021
Jump to Answer

Comments

User_64CKJ
The matter of the driver being on the run-time class-path of the applet, and its ability to connect to 'home' or remote servers is quite different.

The driver will need to be on the class-path for either. To achieve that, add the mssqlserver.jar to the archive attribute of the applet element.

To connect to a DB on a remote server, the applet would also need to be digitally signed (by you) and accepted (by the end user).
835813
Thanks for you reply,
can you please tell me how to digitally sign the applet
835174
Hope this help:

<object
classid = "clsid:8AD9C840-044E-11D1-B3E9-00805F499D93"
width = 1 height = 1
name = "Application Web Client"
codebase = "http://java.sun.com/j2se/1.4.1/download.html">

<param name = CODEBASE VALUE = "." >
<param name = ARCHIVE VALUE = "myjar1.jar,
sqljdbc4.jar"
<param name = CODE VALUE = "applet.myapplet.class" >
<param name = NAME VALUE = "Application Web Client" >
<param name = "type" VALUE = "application/x-java-applet;version=1.1" >
<param name = CLIENT_INI VALUE = "client.ini">
</object>
Kayaman
832171 wrote:
Hope this help:
codebase = "http://java.sun.com/j2se/1.4.1/download.html">
Nicely done!

If they gave prizes for worthless advice here, you'd definitely get one.
User_64CKJ
..can you please tell me how to digitally sign the applet
See the Generating and Verifying Signatures lesson (http://download.oracle.com/javase/tutorial/security/apisign/index.html) of the Java Tutorial.
User_64CKJ
See also http://stackoverflow.com/questions/4897758/connecting-to-remote-databasemssqlserver-using-applet
803795
I suggest you have your applet talk to a servlet. The servlet actually talks to the database (and holds the userID/password). This way, you aren't embedding the userID/password to the database in the applet where someone might get it and have direct access ot your database (a security concern).

I also suggest you review your design to see if separation of concerns might be a better choice (model view controller (MVC) design).
1 - 7

Post Details

Added on Aug 30 2021
5 comments
462 views