nodejs install oracledb

Preface

Node.js developers often need to interact with databases, and Oracle database is an enterprise-level database. Many companies use this database to manage data. Therefore, Node.js developers need to learn to use Node.js to operate Oracle databases. This article explains how to install and configure the oracledb module for operation in Node.js.

Installation preparation

Before installing the oracledb module, you need to complete the following preparations.

1. Make sure Node.js has been installed: You can download the corresponding installation package from [Node.js official website](https://nodejs.org/) for installation.

2. Installing Oracle Instant Client: The oracledb module requires the Oracle Instant Client library to be installed on the computer. Before installing the Oracle Instant Client library, make sure you have the following conditions:

   • Have permission to use the Oracle database.
   • Enough memory. If your computer does not have enough memory, the Oracle Instant Client installation process may hang.

   You can download the corresponding Oracle Instant Client installation package from [Oracle official website](https://www.oracle.com/database/technologies/instant-client/downloads.html).

   In the download page, select the installation package that matches your computer operating system. If your operating system is 64-bit, it is recommended to select the 64-bit Oracle Instant Client installation package.

3. Set environment variables: After completing the installation of Oracle Instant Client, you need to add the path of Oracle Instant Client to the environment variables of the operating system so that the oracledb module can Correctly reference this library.

4. Install Python (optional): oracledb The module uses Python to compile binaries. If Python is not installed on your machine, the oracledb module attempts to compile the binary using Node.js's native compiler. However, this approach is much slower than compiling binaries using Python.

   You can download the corresponding Python installation package from [Python official website](https://www.python.org/downloads/).

Install the oracledb module

After completing the above preparations, you can start installing the oracledb module.

1. Open a terminal or command prompt and go to your project root directory.

2. Run the following command to install the oracledb module:

   npm install oracledb

   If Python is not installed on your computer, the oracledb module will use Node The .js built-in compiler compiles the binary file. The compilation process may take several minutes or longer.

   If you have Python installed, the oracledb module compiles binaries using Python. The compilation process should be faster than compiling binaries using Node.js's native compiler.

3. If an error occurs when you install the oracledb module, please refer to the following steps to troubleshoot.

   • Have you installed the Oracle Instant Client library? If you do not have the Oracle Instant Client library installed, the oracledb module will not work properly.
   • Has the path to the Oracle Instant Client library been correctly added to the operating system's environment variables? If you do not add the path to the Oracle Instant Client library to your operating system's environment variables, the oracledb module cannot correctly reference this library.

Configuring the oracledb module

After installing the oracledb module, you need to configure it to use it in Node.js module.

1. Create a database.js file in your project.

2. Write the following code in the database.js file:

   const oracledb = require('oracledb');
   oracledb.initOracleClient({ libDir: '/path/to/oracle/instantclient' });
   
   module.exports = {
     connect: async function() {
       const connection = await oracledb.getConnection({
         user: 'your_database_username',
         password: 'your_database_password',
         connectString: 'your_database_connection_string'
       });
   
       console.log('Connected to Oracle database');
   
       return connection;
     }
   };

   In the code, we first introduced the oracledb module, and The path to the Oracle Instant Client library is specified using the initOracleClient method.

   Then, we exported a connect method that can connect to the Oracle database asynchronously. In this method, we use the getConnection method to obtain the database connection, and pass the username, password, connection string and other parameters required for the database connection.

   Finally, we printed a message that successfully connected to the Oracle database and returned the database connection object.

   Please note that the database.js file in this article is for demonstration purposes only. In actual applications, you need to configure accordingly according to your actual situation.

3. Use the database.js file in your Node.js application and call the connect method to obtain the database connection when you need to connect to the database. object.

   const database = require('./database.js');
   
   (async function() {
     let connection;
     try {
       connection = await database.connect();
   
       // 在此处开始操作数据库
     } catch (err) {
       console.error(err);
     } finally {
       if (connection) {
         try {
           await connection.close();
           console.log('Disconnected from Oracle database');
         } catch (err) {
           console.error(err);
         }
       }
     }
   })();

   In the code, we first introduced the database.js file and called the connect method to obtain the database connection object. After this, you can operate on the database as needed.

   Finally, we close the database connection in the finally block and print a message that the connection was successfully disconnected from the Oracle database.

Conclusion

Through this article, you have learned how to install and configure the oracledb module in Node.js. I wish you success in working with Oracle databases using Node.js!

The above is the detailed content of nodejs install oracledb. For more information, please follow other related articles on the PHP Chinese website!