Skip to Main Content

JavaScript and Oracle Database Office Hours

Free tips and training every month! Subscribe for reminders and more from Office Hours. FAQ

Header container

September 3, 2019

21:00 UTC   Start Times Around the World

How To Connect your NodeJS app in Docker to your Oracle Database
In this session we’ll cover how to make a connection from a Node.js application in a Docker container to your Oracle Database in three different scenarios.

* Typical Database connection.
* Database inside a different Docker container.
* Oracle Autonomous Transaction Processing Cloud Database.

Highlights:

02:55 - Overview
04:02 - Why use a simple app to test new concepts
04:43 - What is Docker
08:16 - Walk through the Dockerfile
10:17 - Build the Docker image
13:09 - Connect using a typical database connection
14:28 - Connect to OracleXE in a different Docker container on the same Docker network
16:16 - Blaine answered the question incorrectly. You do need to include the network option when you run the OracleXE container
18:35 - Connect to an Oracle Autonomous Transactin Processing instance
22:51 - Why you should not add your wallet files to your Docker image
23:52 - (Bonus) how to connect with a typical database connection using a tnsnames entry
26:02 - Recap
26:30 - How this could work in Kubernetes
28:08 - Chris' blog post on using the Node.js Docker image instead of Oracle Linux
30:04 - OOW19 program guide

Subscribe to give us feedback and be notified of upcoming sessions!

Experts

Your Experts
Dan McGhan
Dan McGhan, Developer Advocate for JavaScript    
Dan started with MySQL and PHP and happily stumbled upon Oracle Application Express. He never looked back and these days he shares his passion for JavaScript and HTML5 with the community.
Christopher Jones
Christopher Jones, Senior Principal Product Manager    
Chris serves as Product Manager for OCI, Instant Client and scripting language drivers for Oracle Database. These include Python cx_Oracle, PHP OCI8, PHP PDO_OCI, and Node.js node-oracledb.
Anthony Tuininga
Anthony Tuininga, Consulting Member of Technical Staff    
Anthony Tuininga is a software developer in the Data Access group at Oracle. He has over 25 years of experience with Oracle Database, is the creator and maintainer of cx_Oracle, the Python module enabling access to Oracle Database, and is now heavily involved with enhancing the node-oracledb module.