Configure dads.conf file to connect to two data bases

This tutorial will explain how to configure dads.conf file to get something similar to the image in the left, you already have a server with Apache that is configured to connect to a database with Apex (i.e. Apex 3.2) and now you want to use the same server to connect to other version of apex in other data base server (i.e. Apex 4.2) but you don't want to lost the current connection. In that case you only have to modify the dads.conf file and change something in the new Apex installation.


Installing Apex

Since this post is not about how to install apex, I'll not explain all the steps to install Apex, only the step you have to make something different, you can refer to Oracle documentation or other blogs to install it. If both apex installation have the same version, you'll not need to change this this step.
The different step you have to make is when you run the apexins.sql script, there you include the parameter /i/ to indicate a virtual directory for the images, but probably the old apex installation is using the same directory, and this new apex version will use different images, that's why you have to name the virtual directory with a different name running the script with a command like this one

@apexins.sql SYSAUX SYSAUX TEMP /i2/

Now the virtual directory for the images of this new apex installation will be /i2/.

Configure dads.conf

your dads.conf file is configured to connect the server with the current apex installation, and that connection is indicated in the data block Location, to allow a connection to the new apex installation, you'll have to copy this block and set the parameters for the new connection, next to Location, change that path for the url you want to use for the new apex connection, for example /pls/newapex, and also create a new alias with the path of the images for the new apex

Alias /i/ "ORACLE_HTTPSERVER_HOME/Apache/images2/"

at the end your dads.conf file will be similar to this one, the first Location block allows the connection to the first Apex, and the second one is for the new Apex.

Alias /i/ "[PATH_OF_IMAGES_FOR_APEX_3.2]"
AddType text/xml xbl
AddType text/x-component htc

<location [OLD_APEX_URL]>
 Order deny,allow
 PlsqlDocumentPath docs
 AllowOverride None
 PlsqlDocumentProcedure         wwv_flow_file_mgr.process_download
 PlsqlDatabaseConnectString     [DataBaseServer]:[Port]:[service Name]
 PlsqlNLSLanguage               AMERICAN_AMERICA.AL32UTF8
 PlsqlAuthenticationMode        Basic
 SetHandler                     pls_handler
 PlsqlDocumentTablename         wwv_flow_file_objects$
 PlsqlDatabaseUsername          APEX_PUBLIC_USER
 PlsqlDefaultPage               apex
 PlsqlDatabasePassword          [APEX_PUBLIC_USER_PASSWORD]
 #PlsqlRequestValidationFunction wwv_flow_epg_include_modules.authorize
 Allow from all
</location>

Alias /i2/ "[PATH_OF_IMAGES_FOR_APEX_4.2]"

<location [NEW_APEX_URL]>
 Order deny,allow
 PlsqlDocumentPath docs
 AllowOverride None
 PlsqlDocumentProcedure         wwv_flow_file_mgr.process_download
 PlsqlDatabaseConnectString     [DataBaseServer]:[Port]:[service Name]
 PlsqlNLSLanguage               AMERICAN_AMERICA.AL32UTF8
 PlsqlAuthenticationMode        Basic
 SetHandler                     pls_handler
 PlsqlDocumentTablename         wwv_flow_file_objects$
 PlsqlDatabaseUsername          APEX_PUBLIC_USER
 PlsqlDefaultPage               apex
 PlsqlDatabasePassword          [APEX_PUBLIC_USER_PASSWORD]
 #PlsqlRequestValidationFunction wwv_flow_epg_include_modules.authorize
 Allow from all
</location>

You have to change everything inside [] in the lines 01, 05, 10, 17, 22, 29 and 36 with your data, after that, Restar the Apache server.

Suppose we make the next assignations

[PATH_OF_IMAGES_FOR_APEX_4.2] = /apex3.2/images
[OLD_APEX_URL] = /pls/apex
[PATH_OF_IMAGES_FOR_APEX_4.2] = /apex4.2/images
[NEW_APEX_URL] = /pls/newapex

And we used myserver:8080/pls/apex to connect to apex 3.2, then we'll connect to apex 4.2 using myserver:8080/pls/newapex and it will look for the images from the folder /apex4.2/images

If both Apex have the same version, they will use the same images and that's why they can use the same virtual Directory.

If you are able to connect to both Apex version, then celebrate like Kashiyuka :D and enjoy the below song from Perfume meanwhile you make your work.


Author

Comments

Post a Comment

Popular posts from this blog

View PDF File on APEX (Simple approach)

Image
PDF ( Portable Document Format ) is a popular file format to store digital documents, many applications require to upload PDF documents. Displaying the uploaded document in the same app could be useful for the user because he can review the PDF file without downloading it. I'll show you a simple approach to display the PDF file on an APEX application. This is simple, but it has a problem, it will use the Browser's PDF viewer, it could be not correctly configured on some users and it will not work on mobiles. However, I hope this be useful for you. This is the DEMO app where you can upload a PDF file and view it on the page, if this is not working, check your browser properties. This has been tested on Firefox 73 , Chrome 80, Opera 66, Safari 12 , Not working on Internet Explorer 11 or Edge. WARNING!!!! This will fail with Large PDF Files. If you need to work with large PDF Files, try Daniel's Approach in the Comments Section. PDF Viewer Demo APP If this is what you...
Read More »

Set Custom APP Icon on APEX

Image
I am creating my WorkSpace on  apex.oracle.com  to enable an online demo of my posts, then you can check if that is what you want before try it. Creating a new App, there are only 32 different Icons, but there are not Cat Icons. I wanted to add a Custom Icon, I'll explain how to do it. First, you need your icon on vector (.svg) format, you can create it using free tools like  Inkscape , Paid tools like  Illustrator , get it asking a Graphic Designer for help or Searching a free one on Internet. This time Chose the last one and got this  Cat Vector . You can find more on that site. Just remember, it is better if the vector has a squared aspect ratio Rename the .svg file to  app-icon.svg  and then go to  Your App -> Shared Components -> Static Application Files , upload the file and we got it!. our .sgv file is now our app icon and it will appear on APEX WorkSpace, Login Screen and Home Page. But you can notice that in ...
Read More »

This is How I became an Oracle APEX developer #JoelKallmanDay

Image
It was the Second semester of 2009, I was still a Systems Engineer student in a Data Base Class, and our teacher asked us to build a Web Application that used a Data Base as the final project. We knew nothing about building web applications and had only built standalone applications, so we had to find out how to do it. We found PHP and built a form and a report, it was working, but it took a lot of work and had many issues. My co-worker found Oracle APEX on the Oracle XE Version and showed me it, it was so simple and easy to use, and with a few clicks we had a working application with authentication. It was so easy that we thought our teacher wouldn't accept it, but anyway, we built our application using APEX. Our teacher taught us to use Oracle Data Base, even taught us PL/SQL, that's why we thought: "It seems he is a Fan of Oracle, probably if he knows that we used an Oracle tool to build the application, he will give us a better grade on the final project", we sa...
Read More »