I am working towards integrating OpenZiti into an Oracle Apex application.
To do this, I need to install ORDS on a separate compute that works as the webserver to receive and send http requests. ORDS then makes a JDBC request directly into the Oracle database to process each of the requests.
I thought that Ziti would be implemented at the JDBC level… but now I understand that it needs to be integrated into the Apache Tomcat server.
Please confirm if this is correct. I am walking quite blind at the moment.
I found the following example that provides some code to implement into the application server. Would this be similar? What other things to do I need to install on the Tomcat server for this to work?
Quick update… seems that the code needs to be integrated into the ords.war file.
I do not have much idea about what the next step is.
Do you have any suggestions / recommendations?
I personally don't have any familiarity with "Oracle Apex" at the moment but I've seen it mentioned here/there by other employees at NetFoundry. I'll have to look it up to understand what it does and how it works to better answer any questions about it.
Your original post mentioned :
To do this, I need to install ORDS on a separate compute that works as the webserver to receive and send http requests. ORDS then makes a JDBC request directly into the Oracle database to process each of the requests.
I thought that Ziti would be implemented at the JDBC level… but now I understand that it needs to be integrated into the Apache Tomcat server.
You can actually add OpenZiti in at multiple layers. JDBC might be the right layer, it might be tomcat, it might just be inside your war. I really don't think I can give good guidance at this time.
It'd help me if you had a really simple app and architectural overview I could look at to understand where OpenZiti fits into the picture. If you have that and could share it, it'd really be helpful.
In the meantime I'll try to learn what it means to use OpenZiti with "Oracle Apex" and what it might take.
Sorry I don't have a better answer for you at this time
Thanks… this is a pretty good resource for a high level overview.
ORDS talks to the Oracle DB using JDBC… but the http traffic requests comes via the listener inside ORDS. You can also install ORDS on a separate compute to the Oracle DB.
ORDS uses Apache Tomcat server to act as the application web server. One of the key files that is packaged up is ords.war. This is what I believe needs to be zitified.
You can download the installation files from here
Oralce Apex is a low code development environment that can be extended to provide a pathway into enterprise applications. There is a very strong community all over the world.
At this stage, I am considering simplifying my use case by using a reverse proxy to marshall the traffic into the listener on a private IP address.
I think it would be pretty hard to modify the ords.war. It will probably need a new parameter in the constructor to configure the app service to start a ziti network.
Let me know your thoughts… happy to chat in more detail.
Maybe I could ask a few guys I know to see if this could become a demonstration project. It could open doors up into their other suite of enterprise applications which will likely have a similar need.
