Oracle Mobile Hub Node.js自定义API能否使用node-oracledb连接Oracle DB？

1. Can the node-oracledb plugin be used with Oracle Mobile Hub (OMH) custom APIs? #

Absolutely! node-oracledb is fully compatible with OMH's Node.js custom API runtime, but there's one key thing to keep in mind: version compatibility. OMH typically supports specific Node.js versions (like 8.x or 10.x for older instances—check your OMH console for your runtime's exact version), so you'll need to install a node-oracledb release that matches it. For example, node-oracledb v4.x works seamlessly with Node.js 8/10.

To use it, just add the compatible version to your project's package.json dependencies, and OMH will handle installing the plugin automatically when you deploy your custom API.

2. Can node-oracledb be used to connect to a remote Oracle DB via basic auth (username, password, public IP, port, SID) in OMH Node.js APIs? Is this the best approach, or does OMH have a better mechanism? #

Yes, you can definitely use node-oracledb for this scenario. Here's a straightforward example of setting up the connection:

const oracledb = require('oracledb');

async function fetchDBData() {
  let connection;
  try {
    // Establish connection using your DB credentials and connection string
    connection = await oracledb.getConnection({
      user: 'your_db_username',
      password: 'your_db_password',
      connectString: 'your_public_ip:your_port/your_sid'
    });

    // Example query execution
    const result = await connection.execute('SELECT * FROM your_table WHERE id = :id', [1]);
    return result.rows;
  } catch (err) {
    console.error('DB connection/query error:', err);
    throw err;
  } finally {
    // Always close the connection when finished
    if (connection) {
      try {
        await connection.close();
      } catch (closeErr) {
        console.error('Error closing connection:', closeErr);
      }
    }
  }
}

Now, is this the best approach? node-oracledb is Oracle's official Node.js driver, so it's reliable and high-performance. However, OMH offers a more integrated, secure alternative: OMH Database Connections.

This built-in feature lets you configure your database connection details directly in the OMH console (no hardcoding credentials in your code). You can then use OMH's SDK to fetch a pre-configured connection pool, which handles connection reuse, credential management, and security out of the box. Here's how that works:

const mcs = require('mcs');

async function fetchDataWithOMH() {
  let connection;
  try {
    // Fetch connection from OMH's managed pool
    connection = await mcs.db.getConnection('your_configured_connection_name');
    const result = await connection.execute('SELECT * FROM your_table WHERE id = :id', [1]);
    return result.rows;
  } catch (err) {
    console.error('OMH DB connection error:', err);
    throw err;
  } finally {
    if (connection) {
      await connection.close(); // Returns connection to the pool for reuse
    }
  }
}

The advantages of using OMH Database Connections are:

• No hardcoded credentials in your codebase (more secure, easier to rotate credentials without redeploying)
• OMH manages connection pooling automatically, boosting performance for high-traffic APIs
• Seamless integration with OMH's security policies and logging

For production APIs on OMH, the built-in Database Connections are the recommended best practice. That said, node-oracledb works perfectly if you need more low-level control over your database interactions.

内容的提问来源于stack exchange，提问作者lepton