为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【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);
}
}
参考下这个文档https://eco.dameng.com/document/dm/zh-cn/app-dev/JavaScript_NodeJs.html