Skip to main content

Deploy NodeJS application in Oracle Application Container Cloud

Check my previous blog regarding "How to create a NodeJS application for CRUD services on Oracle Database Cloud", I am going to use that application now to explain the deployment process on App Container Cloud.

As mentioned in the previous blog, you need "manifest.json". It should contain some basic config params. My case it contained :

For more info on these params :

You need to create a .zip file containing all the files and folders inside your NodeJS application :

IMPORTANT : Once you have the zip file, open it and go inside "node_modules" and delete "oracledb" folder from it.
Oracle Application Container Cloud provides this node_module out-of-the-box, so you don't need to include this in the packaging.

Now open service console of Application Container Cloud and click on "Create Application"

Then select "Node"

Give a name and upload your zip by choosing "Upload archive"

This will start the upload and deployment, which will take you to the Application's page and you can see the deployment progress log in the "Activity" section on the bottom of the page.

If it ran into deployment errors, download the deployment logs and check what went wrong, "how to" is here.

If everything goes alright your application will be deployed and will be active. You'll find the application URL in the top section of the page.

You can now check the apis via Postman :

Optionally, you can add your DB Cloud connection details as "Service Bindings" to the application. You need to go to "Deployment" section from the left-hand side and click on "Add" in Service Bindings section.

This will allow you to use "process.env.XXXX" variables in your NodeJS code, which will make the code transportable through different environments (dev, test, uat etc.).
Check in the previous blog : dbutils.js file where I have used these env variables.

That's it. You have now NodeJS application doing mirco CRUD services on DB cloud. A complete JS application for your Oracle DB instance.


Popular posts from this blog

Exception Handling in ADF

This blog will give you an overview on how you can successfully deal with unhandled Runtime exceptions in an ADF application.

This will give you an idea of:
How to catch the unhandled exceptions.Write a separate log file with stacktrace and thread dumps.Redirect the user to an static error page
#1. Catch unhandled exceptions : 

Create a class "MyExceptionHandler" which extends : Override handleException() method.

public void handleException(FacesContext facesContext, Throwable throwable, PhaseId phaseId) throws Throwable {
        // this method is going to create a separate file with stacktrace and thread dumps
        // redirect to error page

 Create a folder "services" inside : ViewController\src\META-INF and then create a file named "".
In the file, add the absolute name of your custom e…

Bean Based ADF Table with List View in detailStamp facet

One of our projects, we had to display a "tree type" table with different datamodel for children. To solve this, I choose a normal af:table with a detailStamp facet with a List view inside it.
But pretty soon, I ran into an issue of correctly identifying the "disclosed" rows. Since my table's datasource is a bean, not ADF managed datacontrol.

So I solved it using a discloseListener on the af:table.

Full Application is on GitHub :

Classes invloved :

1. : dataProvider class for af:table
2. : dataProvider for the list view inside detailStamp of the table.
3. : provides the methods for populating af:table and af:listView. Also has a discloseListener method to correctly populate the listView datasource.

af:table definition :

Chatbots and Oracle Cloud Services

Thanks to Oracle A-Team, I had a chance to work with Chatbots.
3 pure NodeJS applications, on couple of Oracle Cloud platforms and Facebook messenger, and my chatbot was running.

Let me explain, the architecture a bit. To start with, following is the simple representation of how it works.