注册

node.js连接达梦数据库报TypeError: Right-hand side of 'instanceof' is not an object

我期待的不是雪 2024/02/04 596 1

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:Windows 10
【CPU】:i7 17800H
【问题描述】*:node.js连接报错

var db = require('dmdb')
var fs = require('fs')
var pool, conn;
var http = require('http')
async function example(){
    try{
        pool = await createPool();
        conn = await getConnection();
        await queryWithResultSet();
    }catch(err){
        console.log(err);
    } finally{
        try{
            await conn.close();
            await pool.close();
        } catch (err) {}
    }
}
example();

async function createPool(){
    try{
        return db.createPool({
            connectString:"dm://SYSDBA:SYSDBA@192.168.1.1:5236?autoCommit=false",
            poolMax:10,
            poolMin:1
        });
    } catch (err) {
        throw new Error("createPool error: " + err.message);
    }
}
async function getConnection(){
    try {
        return pool.getConnection();
    } catch (err) {
        throw new Error("getConnection error: " + err.message);
    }
}

async function queryWithResultSet(){
    try {
        var sql = "SELECT ID,P_ID FROM CS.xm";
        var result = await conn.execute(sql,[],{ resultSet:true});
        var resultSet = result.resultSet;
        result = await resultSet.getRow();
        while (result) {
            console.log(result);
            result = await resultSet.getRow();
        }
    } catch (err) {
        throw new Error("queryWithResultSet error: " + err.message);
    } 
}

回答 0
暂无回答
扫一扫
联系客服